I recently saw a job that I thought I'd be good for, so they sent me a 
All good.. but I realised that I couldn't do it..
I got sooo damned close, but could not finish... :-(

Anyhoo, here's the test:

And the test parameters are below
If anyone can tell me the answer, I'd appreciate it, then I can 
de-engineer it, and hopefully learn something.
I've already mailed them and said thanks, but I give up ;-)

I my prob was in gettin ga distict list of all DVD categories, from within 
the final results page...

Hmmm, any takers?


Modify the test.php file (attached) so a list of categories and the
number of DVDs in each category are displayed when the script is called
in a browser. (See resultspage.html for the EXACT output required)

You must complete the getNumDvdsInCategories() function to query the
database and return a multidimensional array in the required format.

You may use the PHP and MySQL manuals available online.


You may only make ONE select query to the database.
Do not edit code outside the getNumDvdsInCategories() function. The
results in the table must be in alphabetical order (category name). The
Drama category MUST appear even though there are no DVDs in the
category. Categories beginning with the letter "T" must not be
displayed. Values in the database cannot be hardcoded anywhere in the

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to