I am trying to count in mySQL the number of entries in the field "day" where day=2 or
3.
Then I want to check just to see if that returned a value greater than 0 or not.
I am using the code below, but having a problem, I keep getting 0 as the total
What am i doing wrong.
$dbqueryshipping1 = "select *, COUNT(day) from tempuserpurchase where day=\"2\" and
day=\"3\" GROUP BY itemname";
$resultshipping1 = mysql_db_query($dbname,$dbqueryshipping1);
if(mysql_error()!=""){echo mysql_error();}
$shipping1 = mysql_fetch_array($resultshipping1);
Thanks in advance,
Phil
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 7/14/2003
