2 replies to this topic

[Davyy]

Heya this is my code and for some reason it gives me errors

 <?
 include'connect.php';
 $maler = mysql_query("SELECT * FROM `alerts` WHERE `to` = '$logged[username]' AND `recieved` = '0'");
 $lol = mysql_fetch_array($maler);
 $num = mysql_num_rows($maler);
 $alert = $lol[alerttext];
 
 if($num > 0) {
 echo ('
 <script>
 alert ("CityHabbo Moderator Says:" + "\n" + "'.$alert.'") 
 </script>
 '); //send it
 mysql_query("UPDATE `alerts` SET `recieved` = '1' WHERE `id` = '$lol[id]"); //then delete alert
 }
 
 $male = mysql_query("SELECT * FROM `alerts` WHERE `to` = '[*]' AND `recieved` = '0'");
 $lo = mysql_fetch_array($male);
 $nu = mysql_num_rows($male);
 $aler = $lol[alerttext];
 
 if($nu > 0) {
 echo ('
 <script>
 alert ("CityHabbo Staff Say:" + "\n" + "'.$alert.'") 
 </script>
 '); //send it
 mysql_query("UPDATE `alerts` SET `recieved` = '1' WHERE `id` = '$lo[id]");
 }
 ?>

here are the errors any one help


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/city/public_html/sitefiles/includes/alertcheck.php on line 4

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/city/public_html/sitefiles/includes/alertcheck.php on line 5

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/city/public_html/sitefiles/includes/alertcheck.php on line 18

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/city/public_html/sitefiles/includes/alertcheck.php on line 19

[Hayden]

SELECT * FROM `alerts` WHERE `to` = '$logged[username]' AND `recieved` = '0'

Test your query in PHPMyAdmin, or whatever you use, and make sure it pulls up without errors.

[Mr. Matt]

add or die( mysql_error() ); to the end of the mysql query then post what returned.