Something from Nothing

[Anon]

I have a script which gives members their username and password if they forget them:

$result = mysql_query("SELECT * FROM members WHERE securityword='$securityword' AND email='$email'");while($myrow = mysql_fetch_array($result))echo "table border=1 bgcolor=#D6DFF7 bordercolor=#6487DC width=100% cellpadding=0 cellspacing=0><tr class=t height=23><td width=28%>Your Username:</td><td width=72%><b>$myrow[username]</b></td></tr><tr class=t height=23><td width=28%>Your Password:</td><td><b>$myrow[password]</b></td></tr></table>";

How can I echo something if it returns 0 results. I have tried mysql_num_rows but couldn't get it to work.

[Anon]

try this:
<?php
$result = mysql_query("SELECT * FROM members WHERE securityword='$securityword' AND email='$email'");

$count = mysql_affected_rows();

if ($count == 0) { echo "sorry , invalidate user"}
else echo "<table border=1 bgcolor=#D6DFF7 bordercolor=#6487DC width=100% cellpadding=0 cellspacing=0><tr class=t height=23><td width=28%>Your Username:</td><td width=72%>$myrow[username]</td></tr><tr class=t height=23><td width=28%>Your Password:</td><td>$myrow[password]</td></tr></table>";
?>

Didnt test it, but should work.

[Anon]

Thanks very much works nicely!