[SOLVED] If SQL Value Exists

[pugboy]

Is there a way to determine if a MySQL database contains a certain value? Kind of like checking if a username is being used or not...

[DarkerAngel]

I'm sure there is something better but this is close to what I always use

<?php
$query = "SELECT username FROM users WHERE username = '{USERNAME}'";
$sql = mysql_query($query);
if(mysql_num_rows($sql)) {
    /* User Exists Code */
} else {
    /* User NOT Exists Code */
}
?>

[mbeals]

<?php
$query = "Select `attribute` from Table where `attribute`  = 'value' ";
$result = mysql_query($query);

if(mysql_num_rows($result)){
    value exists
}else{

it doesn't

}
?>

 

 

beat me to it....and with near exact code too.

 

There is no boolean query that I'm aware of.  Besides, if you think about it, just a yes or a no wouldn't really save anything in terms of speed or efficiency.

[pugboy]

Ok, thanks