Sid - Blogging for Newbie Webmasters’

Here is a list of questions that you may face in an interview for PHP-MySQL

1. What is the scope of global variable?
2. How will you access the value contained in a global variable within a function?
3. What is the function for getting current date and time?
4. How will you arrange data in a mysql table to see the name of few clients in a Tree Structure?
5. How will you access browser screen resolution?
6. How do the functions mysql_fetch_array() and mysql_fetch_rows() differ?
7. How can you create a PHP Session?
8. How will you set the value of php.ini in the run time?
9. How will you know the user agent and referral url using PHP?
10. How can you destroy a session in PHP?
11. How is secured session implemented in PHP?
12. How will you get the ip address of the user?
13. What are the parameters of the mail() function?
14. Mention the function for opening a file, reading its data line by line and output that data?
15. How will you show the data stored in a MySQL table using  PHP?
16. What is  W3C compliance?
17. Mention the parameters of  ereg()?  How does  it differ from eregi()?
18. What is the role  of include ()?
19. How does include() differ from require()?
20. What is the difference between include() and include_once()?
21. What is the difference betwenn require() and require_once()?
22. Write a script to upload file using FTP in PHP?
23. What is the role of substr()?
24. In a newsletter service, where news items are stored in seperate text file, how will you read the content of those files one after another and output only first 100 characters from that file?
25. How will you generate random numbers using PHP?
26. How can you fetch data from MySQL database at random?
27. What is natural join?
28. Which version of MySQL supports IN clause?
29. What is temporary table?
30. Can you create a session with the same session_id that has just been destroyed?

I may consider developing an interview-oriented PHP tutorial  in  future.
There are many more questions actually, but these are the basic guideline of different points that you must note to face an interview for PHP-MySQL.