Off the top of my head, try using OR in your query rather than AND
day=\"2\" or day=\"3\"
day probably won't equal both 2 and 3, which is why you are getting 0.
Also, if you group by item name, you are going to get the total for each
itemname, is that what you want, or just the overall total?
>
On Tue, 22 Jul 2003 17:08:50 -0400, you wrote:
>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 th
ot;amount from DB query"; echo $shipping;
?>
- Original Message -
From: "Curt Zirzow" <[EMAIL PROTECTED]>
To: "PHP List" <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 5:23 PM
Subject: Re: [PHP] MySQL/PHP problem.
> * Thus wrote Phillip Blan
* Thus wrote Phillip Blancher ([EMAIL PROTECTED]):
> 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 gettin
4 matches
Mail list logo