从单个查询中解析多个$变量值？

Question

I'm trying to learn a more economical way of parsing out multiple variable values from a single mysql_fetch_array query. I know I could write a whole series of individual queries to resolve this, but that's a lot of extra coding and queries to hit the server with and that just seems grossly inefficient.

The base query I'd like to work with is:

SELECT vehicletype, vehiclelength
FROM my_dbase.my_table
WHERE arriveday = '08/07/2013' AND process_status = 'completed'

vehicletype has one of four fixed values assigned, and vehiclelength has one of five fixed values assigned from option_value fields on a form page.

What I need is to parse the result of the query to count the number of records found for each pair-combination and assign a $variable value to each pair-combination to display in a PHP-generated table. I have four different dates that I need to run this operation for.

I've tried some iterations of creating an array() or using array_count_values() with the output of the mysql_fetch_array result with no success.

Answer 1

Perhaps you can try,

SELECT COUNT(*), vehicletype, vehiclelength 
FROM my_dbase.my_table WHERE arriveday = '08/07/2013' 
AND process_status = 'completed' and vehicletype 
in ('t1','t2','t3','t4') and vehiclelength 
IN('1','2','3','3') GROUP BY vehicletype, vehiclelength 
ORDER BY vechicletype

I like to let mysql do all the work.