Jump to content

simple error


onthespot

Recommended Posts

yeah it did, i fixed it and then realised u had too, thanks though.

got another error, and i cannot work this out!

 

$query3="UPDATE `fixtures` SET `home_user` = '$newuser', `home_team` = '$newteam', WHERE `home_user` = '$olduser' AND `comp` = '$comp'";
$query4="UPDATE `fixtures` SET `away_user` = '$newuser',`away_team` = '$newteam', WHERE `away_user` = '$olduser' AND `comp` = '$comp'";
$query5="UPDATE `submittedresults` SET `home_user` = '$newuser',`home_team` = '$newteam',WHERE `home_user` = '$olduser' AND `comp` = '$comp'";
$query6="UPDATE `submittedresults` SET `away_user` = '$newuser',`away_team` = '$newteam', WHERE `away_user` = '$olduser' AND `comp` = '$comp'";

 

Can anyone see any errors with the WHERE and AND clauses. I am getting errors on those with sql error! thnaks

Link to comment
https://forums.phpfreaks.com/topic/170690-simple-error/#findComment-900262
Share on other sites

delete the comma between the last set and the where clause. it should look like

 

$query3="UPDATE `fixtures` SET `home_user` = '$newuser', `home_team` = '$newteam' WHERE `home_user` = '$olduser' AND `comp` = '$comp'";
$query4="UPDATE `fixtures` SET `away_user` = '$newuser',`away_team` = '$newteam' WHERE `away_user` = '$olduser' AND `comp` = '$comp'";
$query5="UPDATE `submittedresults` SET `home_user` = '$newuser',`home_team` = '$newteam' WHERE `home_user` = '$olduser' AND `comp` = '$comp'";
$query6="UPDATE `submittedresults` SET `away_user` = '$newuser',`away_team` = '$newteam' WHERE `away_user` = '$olduser' AND `comp` = '$comp'";

Link to comment
https://forums.phpfreaks.com/topic/170690-simple-error/#findComment-901469
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.