mysql question

[FrozNic]

anyone know a php function that checks to see if a row exhists?

like:

if row 9 == there
print there
else
row 9 not there

thx

[batman]

Well, you could use something like this.
You will have to SELECT * FROM table WHERE something="$something"

$sql = mysql_query("SELECT * FROM table);
$login_check = mysql_num_rows($sql);

if($login_check > 0)
{
echo"Darn! You found my row!";
}
else
{
echo"Whoopie, my row is still hidden.";
}

You can modify the script for your own needs.

-Blake

[stolzyboy]

http://www.php.net/manual/en/function.mysql-field-seek.php