COding help

[RON_ron]

this doesn't work. Please help fix this.

 

 

$result1=mysql_query("SELECT * FROM applicants WHERE username = '$user' AND status = 'PendingXCD'");

if(mysql_num_rows($result1)) {

$login = "&err=In progress.";

echo($login);

}

else {

$result=mysql_query("SELECT * FROM  comp WHERE username = '$user' AND password ='$pass'");

if(mysql_num_rows ($result) == 0) {

$login = "&err=Please retry.";

echo($login);

} else {

$row = mysql_fetch_array($result);

$user=$row['user'];

$pass=$row['pass'];

$login = "$user=" . $user . "$pass=" . $pass . "&err=Successful.";

echo($login);

}

?>

[ManiacDan]

Sure it does! 

 

Hint:  "Doesn't work" has no meaning.  Explain.

[RON_ron]

Hey Dan...

 

I'm trying to match a user name in database "applicants" and if it exist and hold the value "PendingXCD" then it returns echo "A"

if not

it should search for the same username in batabase "comp" and if it exist it should match againts it's the password and echo "B"

if not

echo "C"

 

But I'm unable to do it. Please help.

[ManiacDan]

That's basically what this code does.  Have you tried any sort of debugging on your own?

 

Echo the values of all the variables you're using, make sure they're correct.

 

Echo the queries, make sure they're not malformed.

 

Run the queries by hand, see if the output is what you expect.

 

Etc etc.

[RON_ron]

The error I'm getting is

 

unexpected $end in /home/xxx/public_html/xxx/test.php on line 22

 

line 22 is  ?>

 

Any idea why?

[shlumph]

Your bracketing is messed up, look:

if(mysql_num_rows($result1)) {

}
else {

if(mysql_num_rows ($result) == 0) {

} else {

}

[litebearer]

Just a cursory glance...

// Is PendingXCD a constant OR did you forget the Dollar Sign?<br>
$result1=mysql_query("SELECT * FROM applicants WHERE username = '$user' AND status = 'PendingXCD'");
if(mysql_num_rows($result1)) {
$login = "&err=In progress.";
echo($login);
}else {
$result=mysql_query("SELECT * FROM comp WHERE username = '$user' AND password ='$pass'");
if(mysql_num_rows ($result) == 0) {
	$login = "&err=Please retry.";
	echo($login);
} else {
	$row = mysql_fetch_array($result);
	$user=$row['user'];
	$pass=$row['pass'];
	$login = "$user=" . $user . "$pass=" . $pass . "&err=Successful.";
	echo($login);
}
} // THIS BRACE IS MISSING

[ManiacDan]

Three.  Three responses before you gave the actual error you've had all along.

[RON_ron]

Wel spotted litebearer and shlumph.

 

// Is PendingXCD a constant OR did you forget the Dollar Sign?<br>

nope. "PendingXCD" the word I want to match againts the name.

 

But still that doesn't work for the first condition.

 

$result1=mysql_query("SELECT * FROM applicants WHERE username = '$user' AND status = 'PendingXCD'");
if(mysql_num_rows($result1)) {
$login = "&err=In progress.";
echo($login);
//