i need to have a record pull data that count is less then 30 in all the records, but i need to have it less then 20 in one of the records. Possible in one record set?
what i have: SELECT * FROM sessiona WHERE sessiona.`count`<30 <php mysql_select_db($database_wellness, $wellness); $query_wellnesssessionacount = "SELECT * FROM sessiona WHERE sessiona.`count`<30"; $wellnesssessionacount = mysql_query($query_wellnesssessionacount, $wellness) or die(mysql_error()); $row_wellnesssessionacount = mysql_fetch_assoc($wellnesssessionacount); $totalRows_wellnesssessionacount = mysql_num_rows($wellnesssessionacount); ?> but in one of the records count can needs to be <20 is there a way to do AND so and so is less then 20? Thanks..