Hi there I am having a problem querrying to my database. I wish to check to see if a username is listed in the database so that I can authenticate that individual. However, when I try to echo my $_result i'm always getting 0 can someone please help. I think it should be either 1 or 0.
These are my scripts. This is my login pagepage <?php echo "<FORM name=_Form1 method=post action=test.php>"; echo "<TABLE border=1 width=300 height=300>"; echo "<tr>"; echo "<td valign=top>"; echo "<INPUT type=text value='' name=_Name1><br>"; echo "<INPUT type=text value='' name=_Name2><br>"; echo "<INPUT type=submit value='Submit' name=_submitButton>"; echo "<INPUT type=Reset value='Reset' name=_ResetButton><br>"; echo "</td valign=top>"; echo "</tr>"; echo "</TABLE>"; echo "</FORM>" ?> This is my script processor <?php file://Script processor mysql_connect("localhost", "nik", "playas") or die("Could not connect to the server"); mysql_select_db("chronicleOnline") or die("Could not connect to the database"); $_query = " select userName from users where userName='_Name1' "; $_result = mysql_query($_query) or die(mysql_error()); if ( $_result = 0 ) { echo "$_result"; } else { echo "$_result"; } ?> P.S. I have no problem putting the data into the database, just this query. Thx Nik -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php