the "if" statement has me by the .....

I cannot figure out what I am doing wrong... I am trying to create a "register" page for my site where the user fills in his desired username, real name, password, and his email address... for my example I will be passing $username and $email from a previous form..

register.php3
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
$query1 = "SELECT username FROM tblusers WHERE username='$username'";
$query2 = "SELECT email FROM tblusers WHERE email='$email'";
//
// here's the problem part
//
$user_prev_a = MYSQL_QUERY($query1);
if ($user_prev = MYSQL_FETCH_ARRAY($user_prev_a)) {
$userexists = 1;
}
$email_prev_a = MYSQL_QUERY($query2);

if ($email_prev = MYSQL_FETCH_ARRAY($email_prev_a)) {
$emailexists = 1;
}

[/code]

What I'm trying to do is say "Query for the provided username, if it exists in the database, then set $userexists to 1", but what I am getting is the following error :

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
Warning: 0 is not a MySQL result index in /www/yoursite/register.php3 on line 84

Warning: 0 is not a MySQL result index in /www/yoursite/register.php3 on line 91
[/code]


Any help on how to accomplish this would be greatly appreciated.

Mike

Something seems to be the matter with your query, either the table name is wrong or the column name(s) is/are incorrect.

Use
else
print(mysql_error());
after both IF statements to check the error message.

Other than that, your code seems to be O.K.

yea,

The code is correct it seems.

i think field name must have written wrong.or just check it out whether values are passing correct to the query.

$result = mysql_query("SELECT * FROM tblusers WHERE username='$username'");

if (mysql_num_rows($result) == 1)
{
$userexists = 1;
}

$result1 = mysql_query("SELECT * FROM tblusers WHERE email='$email'");

if (mysql_num_rows($result1) == 1)
{
$emailexists = 1;
}




------------------
SR -
shiju.dreamcenter.net

Just a thought.... I don't know if this makes any difference as I always code this way, but I add the final semicolon to the statement. This would make your select clause appear thus :

("......where fred=37;");

....fred=37[;]"); the semicolon in the Sq brackets is the chap I always add (without the brackets of course).

URL

------------------


GE @ Obsidian Software

Thanks for the help peoples... I think what I was really looking for was the MYSQL_NUM_ROWS statement to determine whether or not a record existed...

Oh, and Shiju, I'm still working on the login script... with this out of the way finally, I'll definitly have it done by this weekend

Later,
Mike