[thelist] PHP/MySQL help required

[Warden, Matt]

On Feb 3, Dave Stevens had something to say about Re: [thelist] PHP/MySQL...

>thanks Anthony, so far that's got rid of the error message.
>however, how would I get it to check to see if there is data? every time I
>use anything containing
>
>mysql_fetch_array($result);
>
>it brings back the error message again. any ideas?
>
>thanks again,
>dave stevens

change your sql to something like:

$sSQL = "... where username='$username' and password='$password'";


and then...



$result = mysql_query($sSQL, $connection);

if (mysql_num_rows($result) > 0)
{
	// yes, there was at least one match
}
else
{
	// no match found
}





hth,

--
mattwarden
mattwarden.com