After you give the query, try : echo mysql_error()."<P>".mysql_info();
This way, you should be able to see exactly what error is coming back from PHP/MySQL -----Original Message----- From: Tom Lobato [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 1:55 PM To: Jay Blanchard; mysql@lists.mysql.com Subject: Re: WHERE doesn't work >From: "Jay Blanchard" <[EMAIL PROTECTED]> >More of a PHP question. Echo the UPDATE statement to the browser so that >you can see what it looks like. It is what I did. As I explain in the mail, I executed the command extracted from the browser. The command is: UPDATE clientes SET tipo='r', nome_fantasia='cc',estado='24' WHERE id = '5' Then, I copyied this from browser and executed in the mysql client, And all worked well. Only in the client, not php. And executed in other clients too, all working well. Only the php mysql client api behave wrong. Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
