help with output

[D2T]

Hi everyone,

The output of the second query in the following script doesn't work correctly. It keeps giving me incorrect numbers, randomly, mostly 20, 50, 13.. interesting. I would appreciate very much your help.

thanks!

<?php
$login = $_POST['login'];
$passwd = $_POST['passwd'];

@ $db = mysql_pconnect ("localhost", "xxx", "xxx");

mysql_select_db ("members");
$query1 = "select id from MEM where username='$login' and passwrd='$passwd'";
$result1 = mysql_query($query1);

if (mysql_num_rows($result1) < 1)
{
mysql_select_db ("members2");
$query = "select Custname from Customer where Username='$login' and Password='$passwd'";
$result = mysql_query($query);

if (mysql_num_rows($result) < 1)
{
echo "Dear Visitor,<br> Your login credentials are incorrect, please try again.";
}
else {
while ($row=mysql_fetch_array($result)) {
$name = $row["Custname"]; echo $name;
}
}}
else {
while ($row=mysql_fetch_array ($result1)) {
$a = $row["id"];
echo $a;
}
}
?>