Hi all:
I have a seemingly simple SQL problem when using the following PHP4/MySQL-3.22.32
query:
$sql="SELECT * FROM $table_users WHERE usrName='$username' AND
usrPswd=password('$password') AND affiliation='$aff_sport'";
$result = mysql_query($sql, $connection) or header("Location: error.php?err=query");
$num = mysql_num_rows($result);
//User hasn't been found in DB with current details:
if ($num != 1) {
header("Location: error.php?err=n_player");
exit;
}
//Else get vars and authenticate
else {
//while loop get's vars etc etc
}
My error checking mechanism check's if the inputted details can be found in the DB if
not you are taken to an error page.
The table $table_users, at present has 2 rows where the same username/password crops
up, but different data
(other than the username and password) in their respective rows.
At it stands, I am taken to the error page. If I remove one of the same-name users it
works fine.
What can I do to this query or even my table to remedy this so I can have multiple
same-name users/pswds but with different data,
such as 'affiliation' as above for example??
Please help - as I have nearly completed the project....just some fiddly lil' things
need to be sorted..
Many thanks.
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
"Web Developers do it on-the-fly."
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
