mysql_fetch_array problem II

[Anon]

Ok, the second problem is probably even more mysql-related:
I am trying to do a count and then fetch the number of results for this count.
However, when I fetch the results, I get more results than expected (I guess because of my query):
Here is my query:
$query2 = "SELECT COUNT(*) AS number FROM table WHERE zip LIKE '1%' || zip LIKE '2%' || zip LIKE '3%' GROUP BY zip";
$result = mysql_db_query("$db", $query2);
I would have expected to get 3 numbers, but unfortunately, this is not the case I am getting numerous results.
What am I doing wrong here? Is this, because of the LIKE in the query?
I would be really glad if someone could help me with these headache giving queries. 🙂
Sarah

[[deleted]]

First, you have your LIKE requirements.
These filter out all zips that don't start with 1,2 and 3.

This gives all zips that start with 1,2 or 3.
Then, to get the count of those records, you correct;y use count(*).

But, then you also use the GROUP BY, which will 'group' the result by 'zip', giving you one count(*) for each unique value of zip.