Check if a record matches

[jeff5656]

Hello.  I want to check to see if a record matches based on a field.  So I have this:

 

include "connectdb.php";
$consultsq2 = "SELECT * FROM members WHERE username= '" . $_POST['myusername'] . "'";
$result2 = mysql_query ($consultsq2) or die ("Invalid query: " . mysql_error ());
$row2 = mysql_fetch_array ($result2);

 

What code do I write to see if it exists?  Such as "if there is such a record, do this..."

Thanks!

[Adam]

if (mysql_num_rows($result2) > 0)
{
    //...
}

[RussellReal]

you could also do this..

 

if ($row = mysql_fetch_assoc($result2)) {

  // if it exists.. then $row holds the data for the row.

}