simple error

[onthespot]

  $result = mysql_query("SELECT team FROM ."$_GET['game']_teams".") or die(mysql_error());

 

How do I get that to work? thankyou, im getting a parse error atm!

[papaface]

  $result = mysql_query("SELECT `team` FROM `".$_GET['game']."_teams"`) or die(mysql_error());

Not a very good way of doing the query though if you ask me.

[onthespot]

Thats giving me a parse error dude?

[AviNahum]

$result = mysql_query("SELECT team FROM ".$_GET['game']."_teams") or die(mysql_error());

 

now it's should work

[onthespot]

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

[AviNahum]

you still need help? or u solved the problem?

[mikesta707]

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'";