RE: WHERE doesn't work

[George Law]

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:tomlobato@stripped] 
Sent: Thursday, April 20, 2006 1:55 PM
To: Jay Blanchard; mysql@stripped
Subject: Re: WHERE doesn't work


>From: "Jay Blanchard" <jblanchard@stripped>
>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/mysql?unsub=1