Check if value exist?

[Incredinot]

Hi..

 

So what i want to do is basicly to check if id XX exist in my database.

How can this be done?

 

Im thinking of something like:

 

if(xx exist){do this}

else{do this}

 

Iv'e tried google etc before i posted here, but couldent really find anything where i found a soutable answer..

 

Hope someone can help! (:

[trq]

// make connection

$sql = "SELECT fld FROM tbl WHERE fld = 'XX'";
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    // XX exists
  } else {
    // XX not found
  }
}

[Incredinot]

Wow, that was fast! (:

 

Thanks alot dude.. Thumbs up