PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$result = mysql_query("SELECT id FROM pvpchallenges WHERE ((userid='$userid' AND oppid='$usersid' AND mapid='$map->id' AND status='p') OR (userid='$usersid' AND oppid='$userid' AND mapid='$mapid' AND status='p'))") or die(mysql_error());
if(mysql_num_rows($result) == 0)
my statement wont work but I get no errors. all vars are fine. it will always execute my IF statement even after I insert it the first time.
$query = "SELECT id FROM pvpchallenges WHERE ((userid='$userid' AND oppid='$usersid' AND mapid='$map->id' AND status='p') OR (userid='$usersid' AND oppid='$userid' AND mapid='$mapid' AND status='p'))";
echo $query;
$result = mysql_query($query) or die(mysql_error());
SELECT id FROM pvpchallenges WHERE ((userid='$userid' AND oppid='$usersid' AND mapid='$map->id' AND status='p') OR (userid='$usersid' AND oppid='$userid' AND mapid='$mapid' AND status='p'))