List:General Discussion« Previous MessageNext Message »
From:George Law Date:April 20 2006 6:08pm
Subject:RE: WHERE doesn't work
View as plain text  
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

Thread
WHERE doesn't workTom Lobato20 Apr
  • Re: WHERE doesn't workBarry21 Apr
  • Re: WHERE doesn't workPeter Brawley23 Apr
  • Re: WHERE doesn't workTom Lobato23 Apr
    • Re: WHERE doesn't workPeter Brawley23 Apr
  • Re: WHERE doesn't workTom Lobato23 Apr
RE: WHERE doesn't workJay Blanchard20 Apr
  • Re: WHERE doesn't workTom Lobato20 Apr
RE: WHERE doesn't workGeorge Law20 Apr
Re: WHERE doesn't workTom Lobato21 Apr
  • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
    • Re: WHERE doesn't workTom Lobato21 Apr
      • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
      • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
        • Re: WHERE doesn't workTom Lobato21 Apr
          • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
            • Re: WHERE doesn't workTom Lobato22 Apr
              • Re: WHERE doesn't workMichael Stassen22 Apr
  • RE: WHERE doesn't workNicolas Verhaeghe21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato21 Apr
RE: WHERE doesn't workJay Blanchard21 Apr
  • Re: WHERE doesn't workTom Lobato21 Apr
Re: WHERE doesn't workTom Lobato24 Apr