Re: [PHP-DB] Simple query problem

2001-05-03 Thread Miles Thompson
Suggestions: 1) Can you try this at the database console and see what is returned. 2) Have you echoed $sql to see if the statement looks right. I only ask this because I've been certain that I have a correct statement and then found out that nothing is coming back. 3) What happens if $aff_sp

[PHP-DB] Simple query problem

2001-05-03 Thread Russ Michell
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?e