checking if a value exist

[amylisa]

I'm trying to check if a value exists and then do something if it does and do something if it doesn't but with this code I get the returned number of rows as being 1 even when the value doesn't exist in the table. I've been googling for a while now and still cant work out what is wrong

 

$query = mysql_query("SELECT COUNT(*) FROM `names` WHERE username='".$username."'");
if (mysql_num_rows($query) > 0) { print "value exists"; }
else { print "value doesn't exist"; }

[trq]

SELECT COUNT will always only ever return 1 row. You need to check that value in that row.

 

if ($query = mysql_query("SELECT COUNT(*) FROM `names` WHERE username='$username'")) {
  if (mysql_num_rows($query)) {
    if  (mysql_result($query,0) > 0) {
      print "value exists";
    } else {
      print "value doesn't exist";
    }
  }
}

[amylisa]

Thanks ^^

It's working now with that