[PHP-DB] php-mySQL and an SQL query
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
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
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
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]