First of all, you are not using the variable when you are passing it to
the sql string. Second, you are doing a pointless var check, and
thirdly, your condition statement is flawed.
1. SQL should be (if you have register globals turned on, otherwise you
must use $_GET['_Name1'] ):
$_query = " select userName from users where userName='$_Name1' ";
2. mysql_query returns a result identifier - not the actual results. You
should use mysql_num_rows() to find out if any rows were returned (or
use the other mySQL functions to retrieve the actual data):
$numRows = mysql_num_rows($_result);
3. Print the value of $numRows, without doing a check:
echo $numRows;
4. In your IF statement, the equal comparison operator should be '=='
(otherwise you are assigning the value to the variable). What you also
could choose to do, is to leave out the comparison like so:
if ( $_result ) // 0 = false, 1 = true;
{
echo "Name was found in the database";
}
else
{
echo "Name was NOT found in the database";
}
Hope that helps..
Adam
> 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
