help quering mysql

[sdizier]

when doing a query using php and my sql
such as
$value = mysql_query("SELECT * FROM table WHERE name = $UserName",$linkID);
What can I return if the $UserName variable is not matched.

What I would like is that if there is no match then I want to print a message no user with user name $Username was found.

please help

[ranam]

Just do something like:

$sql="SELECT * FROM table WHERE name = $UserName";
$result = mysql_query($sql,$SESS_DBH);
if ($myrow = mysql_fetch_array($result))
{
echo "you have access";
}
else
{
echo "NO access";
die;
}

[sdizier]

Thanks, Great help