Posted by Mark Nenadov on 06/09/07 20:17

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.

> 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.


Thanks,

--

Mark Nenadov
http://www.marknenadov.com/

• Next in forum: Re: mysql_query strangeness (misreported syntax error?)
• Prev in forum: Re: Get/POst method not working
• Thread view: Re: mysql_query strangeness (misreported syntax error?)

[Reply to this message]