PHWinfo - Afficher un message - INSERT query runs in mysql client, but not in PHP.

26/04/2006, 21h23

Aggro wrote:
> You don't seem to actually check the return value from mysql_query().
> You return it from your function, but where you call addNewStory(), you
> don't check what it returns.

I support this advice, and here's another comment: while debugging, it
is useful to output the query that caused the error, _after_
interpolating the PHP variables into it. Often, mismatched quotes and
other errors introduced by the variables become obvious if you look at
the SQL that is actually executed.

Regards,
Bill K.

26/04/2006, 21h23	#4
Bill Karwin Messages: n/a Hébergeur:	Re: INSERT query runs in mysql client, but not in PHP. Aggro wrote: > You don't seem to actually check the return value from mysql_query(). > You return it from your function, but where you call addNewStory(), you > don't check what it returns. I support this advice, and here's another comment: while debugging, it is useful to output the query that caused the error, _after_ interpolating the PHP variables into it. Often, mismatched quotes and other errors introduced by the variables become obvious if you look at the SQL that is actually executed. Regards, Bill K.