[PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt

Hi, folks,

Can someone insight me regarding this?

I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time

I want to pull records hitting against this field with the idea:

where the abbreviated month from this field LIKE '$month'

and here's the SQL string I've been playing with. It works when I comment
out the line that tries to do the above with a subquery.

$strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname,
image ";
$strSQL .= "FROM doings, styles ";
$strSQL .= "WHERE style = musicstyle ";
$strSQL .= "AND bandname LIKE '$artist' ";
$strSQL .= "AND style LIKE '$style' ";
$strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE
'$month' ";
$strSQL .= "ORDER BY event_time";
echo "$strSQLBR";

$month will be carrying the three-character short version of the alpha month
name.

I don't think it likes my subquery, though I like it just fine.

Regards,
Michael



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Michael Gerholdt

Hi, folks,

Can someone insight me regarding this?

I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time

I want to pull records hitting against this field with the idea:

where the abbreviated month from this field LIKE '$month'

and here's the SQL string I've been playing with. It works when I comment
out the line that tries to do the above with a subquery.

$strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname,
image ";
$strSQL .= "FROM doings, styles ";
$strSQL .= "WHERE style = musicstyle ";
$strSQL .= "AND bandname LIKE '$artist' ";
$strSQL .= "AND style LIKE '$style' ";
$strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE
'$month' ";
$strSQL .= "ORDER BY event_time";
echo "$strSQLBR";

$month will be carrying the three-character short version of the alpha month
name.

I don't think it likes my subquery, though I like it just fine.

Regards,
Michael




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread Beau Lebens

mysql doesn't support sub-queries unfortunately =(




At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote:
Hi, folks,

Can someone insight me regarding this?

I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time

I want to pull records hitting against this field with the idea:

where the abbreviated month from this field LIKE '$month'

and here's the SQL string I've been playing with. It works when I comment
out the line that tries to do the above with a subquery.

$strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname,
image ";
$strSQL .= "FROM doings, styles ";
$strSQL .= "WHERE style = musicstyle ";
$strSQL .= "AND bandname LIKE '$artist' ";
$strSQL .= "AND style LIKE '$style' ";
$strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE
'$month' ";
$strSQL .= "ORDER BY event_time";
echo "$strSQLBR";

$month will be carrying the three-character short version of the alpha month
name.

I don't think it likes my subquery, though I like it just fine.

Regards,
Michael



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
Beau Lebens - Web Master
Insurance My Way, Your Friendly Online Broker
(08) 9226 5888
http://www.insurancemyway.com.au/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] php-mySQL and an SQL query

2001-03-08 Thread CC Zona

And even without the subquery, the "like" keyword expects a wildcard 
character or two, for example:

LIKE '$month%' "

 mysql doesn't support sub-queries unfortunately =(
 
 
 
 
 At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote:
 Hi, folks,
 
 Can someone insight me regarding this?
 
 I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time
 
 I want to pull records hitting against this field with the idea:
 
 where the abbreviated month from this field LIKE '$month'
 
 and here's the SQL string I've been playing with. It works when I comment
 out the line that tries to do the above with a subquery.
 
 $strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname,
 image ";
 $strSQL .= "FROM doings, styles ";
 $strSQL .= "WHERE style = musicstyle ";
 $strSQL .= "AND bandname LIKE '$artist' ";
 $strSQL .= "AND style LIKE '$style' ";
 $strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE
 ;
 $strSQL .= "ORDER BY event_time";
 echo "$strSQLBR";
 
 $month will be carrying the three-character short version of the alpha month
 name.

-- 
CC

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]