help with sql query...

[Killahbyte]

Ok we have a team table that holds all our teams and stats. What i am trying to do is have a sql query that will update user table with the stats from team table. But the only thing updating is one column. I need both. Anyone care to help with this problem?

global $db;
$sql = $db->query_first("select * from " . TABLE_PREFIX . "userteam WHERE userteamid=$teamid AND WHERE title=$teamtitle");
if ($sql){
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET teamtitle = '$teamtile' WHERE $teamid=userteamid AND WHERE title=$teamtitle");
}else{
$db->query_write("UPDATE " . TABLE_PREFIX . "user SET teamtitle = 'NULL' WHERE userteamid=$teamid");
}

What is happening is the teamid in user table updates but the teamtitle does not. Where is my error?

KB

[Reeve of shinra]

You dont need to use an if/else... it would be something like




$sql = $db->query_first("select * from " . TABLE_PREFIX . "userteam WHERE userteamid=$teamid AND WHERE title=$teamtitle");

$db->query_write("UPDATE " . TABLE_PREFIX . "user SET teamtitle = '$teamtile' WHERE $teamid=userteamid AND WHERE title=$teamtitle");

$db->query_write("UPDATE " . TABLE_PREFIX . "user SET teamtitle = 'NULL' WHERE userteamid=$teamid");


1 - read teh fields in the db
2 & 3 - update those fields

You can probably combine those last two queries into one like in your read query...

[r007]

You also seem to have an error in your 2nd query WHERE clause? (WHERE $teamid=userteamid). Shouldn't it read "WHERE userteamid=$teamid"?