If Statement Not Returning Values MYSQL

[MidNightSkinHD]

Have tried many different styles but ending up with the same results.. The form doesn't work and the same with the results.

Here's the code:

// Check if member wants email notifications
$emailpref = db_res("SELECT EmailNotify FROM Profiles WHERE ID = '{$recipient['ID']}' AND EmailNotify = 1");
if ( mysql_num_rows( $emailpref ) < 0 )
{
?>
<input type="hidden" name="sendto" value="lovemail" />
<input type="hidden" name="notify" value="checked">
<?
}

[dagon]

the rows returned will never be less than 0, either 0 or more (or FALSE on failure)

[MidNightSkinHD]

Ok that makes sence 🙂 forgot I left it on that.

What I'm trying to do is have it check the Boolean value of EmailNotify and if it's 1 then insert that HTML in the form.

[dagon]

MidNightSkinHD;10965254 wrote:

What I'm trying to do is have it check the Boolean value of EmailNotify and if it's 1 then insert that HTML in the form.

if ( mysql_num_rows( $emailpref ) ==1 ){
echo '<input type="hidden" name="sendto" value="lovemail" />
<input type="hidden" name="notify" value="checked">';
}else{
//nada
}

if that fails check the return value of $emailpref