Do if no rows found ?

[developer]

Hello!

How do I please make so the if-else code works correct? I do want something to happen if there is row/rows found in the table, and something else to happen if there is not.

Thanks.

$Query = "SELECT * FROM songvotecheck WHERE ip='$ip'" or die (mysql_error());
$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);
$row=mysql_fetch_array($Result);

if(mysql_affected_rows!=0){
   Do something....
}else{
   Do something else...		
}

}

[foolguitardude]

Well, mysql_affected_rows works with INSERT, UPDATE, etc. You need to use mysql_num_rows with SELECT statements.

Good luck

[developer]

Thanks!