MySQL/php

[LRM_php]

Hey Guyz

 

Im tryin to do an update in my table from my php page heres my code:

 

 

function UpdateOwn($Title,$Name,$Address,$Phone,$OwnID)

 

{

 

$updateQuery = "UPDATE tblOwner

SET Title = $Title,

Name = $Name,

Address = $Address,

Phone = $Phone

WHERE OwnerID = $OwnID";

 

$result = mysql_query($updateQuery);

 

if (!$result)

{

 

$errorString = mysql_error();

echo("<br> The error was,  $errorString <br>");

}

 

}

 

UpdateOwn($OwnTitle,$OwnName,$OwnAddress,$OwnPhone,$PatOwner);//from form data

 

i keep getting this error:

 

The error was, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Jump St, Phone = 0210220345 WHERE OwnerID = 1005' at line 4

 

[paul2463]

the error does not match the query you dont have a Phone or OwnerID in your query, which query is throwing that error??

[DyslexicDog]

You need to add some quotes around your different column values.