[SOLVED] Query To Do Simple Update

[dizzy1]

Hi Basically All i want to do is this:

 

 

$mysql = mysql_query("

 

UPDATE `Persons` 

SET 

`Name`='Dave',

`Car`='Ford'

`ID`='$NewID'

 

WHERE

`ID`='$OLDID'

LIMIT 1

");

 

Dont get why it aint working. PLEASE HELP  ???

 

THANKS IN ADVANCE.

[Mchl]

Do

$mysql = mysql_query("
      
      UPDATE `Persons` 
      SET        
         `Name`='Dave',
         `Car`='Ford'
         `ID`='$NewID'
                   
      WHERE
         `ID`='$OLDID'
      LIMIT 1
      ") or die(mysql_error());   

 

If it errors, it will show the message, that will hopefully tell us what's wrong.

[dizzy1]

Do

$mysql = mysql_query("
      
      UPDATE `Persons` 
      SET        
         `Name`='Dave',
         `Car`='Ford'
         `ID`='$NewID'
                   
      WHERE
         `ID`='$OLDID'
      LIMIT 1
      ") or die(mysql_error());   

 

If it errors, it will show the message, that will hopefully tell us what's wrong.

 

 

CHEERS, I was missing a Commar .