mysql quiry help

[jasondavis]

I have the mysql part below,

$res = mysql_query("select * from friend_profilevisitor where profile='$info[auto_id]' order by date desc limit 100");
$riders = mysql_num_rows($res);

What I would like to do though is modify it to also do this

select zip from friend_reguser where autoid='$info[auto_id]'

[sneakyimp]

so perhaps you go for it and see what happens? you might want to change that last line to this:

$riders = mysql_num_rows($res)
  or die('query failed:' . mysql_error());