HELP With Script

[lch_hosting]

Okay I'm using this script

$zz_string = "SELECT * FROM users WHERE email='$email'";
mysql_query($zz_string);

$zz_result=mysql_query($zz_string);
$zz_num=mysql_numrows($zz_result);
$i=0;
while ($i < $zz_num) {
$ex_id=mysql_result($result,$i,"id");
++$i;
}

So this should connect to the users table and $ex_id should equal the ID field where the email address matches. But it's not returning the right ID value.... any know why?

[lch_hosting]

No one knows??

[[deleted]]

Try the following...

$zz_string = "SELECT * FROM users WHERE email='$email'"; 

$result = mysql_query($zz_string) or die (mysql_error()); 

$zz_num=mysql_numrows($result); 
$i=0; 
while ($i < $zz_num) { 
$ex_id=mysql_result($result,$i,"id"); 
printf($ex_id);  // display result
++$i; 

}

[lch_hosting]

Thanks so much it worked!!