What's wrong with this query.

[wraygun]

I'm attempting to determine if this user exists. But returns "Resource ID #21" for some reason.

$strSQL = mysql_query("SELECT * FROM bandinfo WHERE username = 'jampa5'");
  
echo $strSQL;

The connection string is working great and I can add records fine, but I can't seem to wrap my mind around this. Any help would be greatly appreciated.

Thanks,
Harold


***You can't change your past, but you can change your future***

 

[kenrbnsn]

After you do the query, you have to get the results or the number of rows affected.

$num = mysql_num_rows($strSQL);
if ($num == 0) // no such user
else  // user exists

Ken

 

[wraygun]

Awesome!

Thank you so much! That was just the push I needed!

Harold

***You can't change your past, but you can change your future***