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
