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.
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.