[RESOLVED] returning results bug?

[lukeurtnowski]

I'm so confused, I checked mysql_num_rows()

$sql = "SELECT thumb_name, photo_name, Email FROM PHOTO WHERE Email = '$Email'";
$handle = mysql_query($sql) or die("Error: " . mysql_error()); //Do the query
$row = mysql_fetch_array($handle);
echo mysql_num_rows($handle);
echo '<pre>';
print_r($row);

And it returns 0 (but I ran the query in PHPMyAdmin and it produces 3 results.. see screenshot)

[bradgrafelman]

Echo out the query - double check that it looks the same (i.e. $Email is a valid variable and contains the value you thought it did).

[lukeurtnowski]

ok, I put this in...

<?php
$sql = "SELECT thumb_name, photo_name, Email FROM PHOTO WHERE Email = '$Email'";
$handle = mysql_query($sql) or die("Error: " . mysql_error()); //Do the query
$row = mysql_fetch_array($handle);
echo $sql;
echo $handle;
echo $row;
echo mysql_num_rows($handle);
echo '<pre>';
print_r($row); 
?>

To see it, go
http://www.houstonasp.com/php/show_provider.php?ID=3

[bradgrafelman]

SELECT thumb_name, photo_name, Email FROM PHOTO WHERE Email = '<a href="mailto:[e-mail]">[e-mail]</a>'

Is your e-mail address really "<a href="mailto:[e-mail]">[e-mail]</a>" ?

Seems like a fairly long (and invalid) e-mail address to me...

[lukeurtnowski]

Oh, I see. Thank you

[bradgrafelman]

Don't forget to mark this thread resolved (if it is).