Two MySQL AND's returns blank query, one does not?
Posted: Mon Aug 25, 2008 9:43 pm
Works...
Returns blank query...
...can any one please explain to me why?
Does MySQL not allow multiple AND's?
Code: Select all
if (!isset($_GET['folder'])) {$result1 = mysql_query("SELECT id, id_from, date_0, date_1, message, subject FROM `public_private_messages` WHERE id_for = '".$_SESSION['member']."' AND id_for_folder = 'New'");}Code: Select all
if (!isset($_GET['folder'])) {$result1 = mysql_query("SELECT id, id_from, date_0, date_1, message, subject FROM `public_private_messages` WHERE id_for = '".$_SESSION['member']."' AND id_for_folder = 'New' AND id_for_folder = 'Read'");}