Also, I ran this SQL on the regular mysql client, and it returned the
correct data...for some reason if I run it in PHP, I get the SQL syntax
error.
Tyler
> -----Original Message-----
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 9:20 PM
> To: PHP-General
> Subject: [PHP] Now, why doesn't this work?
>
>
> Hello everybody,
>
> My host seems to be having some weird problems.
> Here's a piece of code:
>
> if (($this_month_sql = mysql_query("SELECT * FROM $mysql_shows_table WHERE
> month = '$thismonth' ORDER BY timestamp ASC")) && ($next_month_sql =
> mysql_query("SELECT * FROM $mysql_shows_table WHERE month = '$nextmonth'
> ORDER BY timestamp ASC"))) {
> do this();
> }
> else {
> print ("<font face=Arial size=2>MySQL query <b>DIDN'T RETURN
> DATA</b><br>Error No.:". mysql_errno(). "<br>MySQL Error:".
> mysql_error().
> "</font><Br>");
> }
>
> Now, this is the error that I get from this:
> MySQL query DIDN'T RETURN DATA
> Error No.:1064
> MySQL Error:You have an error in your SQL syntax near 'WHERE month = '4'
> ORDER BY timestamp ASC' at line 1
>
> Why I get this, I don't know. The code hasn't changed in a few
> days, and it
> just started doing that today. This also works on my home Win2k box, and
> Slackware box. The versions of PHP, MySQL, and apache are the same on my
> host and on my Linux box. The version of php and mysql are the
> same on ALL
> of the machines (host, Win2k, Slackware).
>
> Any ideas?
>
> Thanks everyone,
> Tyler
>
>
> --
> PHP General 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 General 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]
