Posted by J.O. Aho on 06/09/07 21:58

Mark Nenadov wrote:
> On Sat, 09 Jun 2007 18:54:59 +0200, J.O. Aho wrote:
>> Even if you have done the query yourself and you are 100% sure you done it
>> right, it's always good to print it out
>
> Which, if you read my reply, is exactly what I did. I wrote the query
> myself. And I pasted the exact echo output of the query that is being
> passed to mysql_query() to the mysql console client and it worked.

Which error number did you get?

You checked that the cut and paste didn't include an extra "character" that
isn't displayed with the font used in your editor/ide?

>> PHP itself will not parse or execute the query, but just deliver it to the
>> mysql server.
>
> That makes sense to me, but I have in front of me here a clear cut case of
> a query that works on the mysql console client but not when passed to
> mysql_query(), which leads to why I've posted here.
>
> Something is fishy. I have a query that definitely works in mysql, but
> PHP's mysql_query is choking on it somehow.

If there would be something fishy with the php, then you would not be able to
query something simple as "SELECT NOW()", and if that would be the case, then
your php is compiled against another version of mysql.

--

//Aho

[Back to original message]