mysql help

[scarface83]

Hi,

 

what would query would i need to use to get php to check if the value set in a variable exits in the database and it if did echo the info otherwise go to another page ?

 

Thanks

[desithugg]

//database connection here
$query = mysql_query("SELECT count(*) as id from table where something = '$whatever'") or die(mysql_error()); 
$row = mysql_fetch_array( $query );
$exists = $row["id"];
if($exists == "" OR $exists == "0") { echo "not found"; }
else { return exists; }

hope that helps

[scarface83]

thanks