Little problem understandign the WHERE clause
Posted: Mon Jun 19, 2006 6:56 pm
Hi,im using this query to retrieve all results where the username is equal to $payee and the payed status s N,i think it is because i am not understaind the WHERE clause:
cansoemone just clear it up for me? i checked out in the manual and could not really udnerstand how to define the WHERE.
Code: Select all
$sql = "SELECT * FROM coffers WHERE username= $payee AND payed=N";