Yes, I gree with all. To test their mySql level, you can show them two tables, and the results from a join between the two tables, so you ask them for what is the SELECT statement to get that results.
Example .. Table1: +----+---------+---------+--------------+ | id | name | surname | departmentId | +----+---------+---------+--------------+ | 1 | John | Doe | 1 | | 2 | Scott | Johnson | 2 | | 3 | Mikael | Martin | 2 | | 4 | Nicolas | Survey | 3 | +----+---------+---------+--------------+ Table2: +----+----------------+ | id | departmentName | +----+----------------+ | 1 | Production | | 2 | Sales | | 3 | Marketing | +----+----------------+ Question: What's the select statement to show this results: +---------+---------+----------------+ | name | surname | departmentName | +---------+---------+----------------+ | John | Doe | Production | | Mikael | Martin | Sales | | Nicolas | Survey | Marketing | | Scott | Johnson | Sales | +---------+---------+----------------+ Answer: select name,surname, departmentName from table1 left join table2 on table1.departmentId=table2.id order by name asc; This example is very very easy, don't put it into your exam :) Look for other examples searching in google or any searcher .. -----Mensaje original----- De: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Enviado el: martes, 26 de agosto de 2003 18:03 Para: Micheal Harris; [EMAIL PROTECTED] Asunto: Re: [PHP] PHP Interview questions From: "Micheal Harris" <[EMAIL PROTECTED]> > I am in the process of hiring someone that needs to have extensive PHP and > MySQL experience. Does anyone have any suggestions for interview questions? > I have no PHP or MySQL experience, and come from a non-technical background. > I want the questions to be technical, but I am unsusre as to how specific I > should get with the questionning! How are you going to grade it, though, if you don't know PHP or MySQL? I say you should send them to the list and let us grill them!! We'll sort out the riff-raff.. :) Seriously, look at their portfolio, call their references, and MAKE them write code. TASK: Create a PHP application that will insert names and dates of birth into a MySQL database. CONDITIONS: Given the PHP Manual, MySQL Manual, Notepad (or similar text editor), and database host, user, and password information. STANDARD: The application will run without errors when complete. The application will accept a first name, last name, and date of birth (in DDMMMYY format) through an HTML form and store the information in a MySQL database. The application will list all current entries in the database in an HTML table after a new row is inserted. Things to look for: 1. Do they program for register_globals ON or OFF? 2. Do they check the setting of magic_quote_gpc? 3. Do they include error checking of form data and queries? 4. Is their program open to cross site scripting or SQL injection attacks? 5. Do they use a DATE type column or VARCHAR column for dates? 6. Do they write valid HTML? 7. How many files do they use to accomplish the task? 8. Do they try to add extra "fluff" instead of just accomplishing the task? Hopefully others will pipe up with their comments, also. :) ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php