Menu
Community /Pin to ProfileBookmark
@NogDogApr 07.2010 — #Update syntax uses commas to separate column=value pairs:
@NogDogApr 07.2010 — #You might want to verify that all the variables have the correct values, especially the one used in the where clause.
[RESOLVED] PHP MySQL UPDATE not working
Can someone let me know what I have wrong?
[code=php]
$busname = $_POST[‘busname’];
$busadd = $_POST[‘busadd’];
$buscity = $_POST[‘buscity’];
$busstate = $_POST[‘busstate’];
$buszip = $_POST[‘buszip’];
$busphone = $_POST[‘busphone’];
$url = $_POST[‘url’];
$catid = $_POST[‘catid’];
$typeid = $_POST[‘typeid’];
$busid = $_POST[‘busid’];
if(isset($url))
$website = 1;
else
$website = 0;
mysql_query(“UPDATE businesses SET busname = ‘$busname’ AND busadd = ‘$busadd’ AND buscity = ‘$buscity’ AND busstate = ‘$bustate’ AND buszip = ‘$buszip’ AND busphone = ‘$busphone’ AND website = ‘$website’ AND url = ‘$url’ AND catid = ‘$catid’ AND typeid = ‘$typeid WHERE busid = ‘$busid'”)
or die(mysql_error());
I have also tried replacing the AND with commas and still no luck.
Sign in
to post a comment7 Comments(s) ↴
0
@NogDogApr 07.2010 — #Update syntax uses commas to separate column=value pairs:<i>
</i>UPDATE table SET col1='val1', col2='val2', col3='val3' WHERE colx=123
0
@NogDogApr 07.2010 — #You might want to verify that all the variables have the correct values, especially the one used in the where clause.[code=php]
$query = "
UPDATE businesses
SET
busname='$busname',
busadd='$busadd',
buscity='$buscity',
busstate='$bustate',
buszip='$buszip',
busphone='$busphone',
website='$website',
url='$url',
catid='$catid',
typeid='$typeid'
WHERE busid = '$busid'
";
$result = mysql_query($query) or die(mysql_error()."<br />n$query");
if(mysql_affected_rows($result) == 0)
{
user_error("No rows updated<br />n$query");
}
[/code]