show the top 5 records of the Users table. (in order to test it populate your table with more than 5 records) in the P
Practice Question 1.
Assume that the Users table has a plenty of records but only three colums: UserID, FirstName and LastName.
Write the following:
a) Write an SQL query to show the top 5 records of the Users table. (in order to test it populate your table with more than 5 records) in the PHP file and to display the result in well-readable format (table preffered) in the browser using parameters.
b) Write a SQL query in the PHP file that will print details of all users excluding those with the FirstName “Will” and “Michael” from the Users table and to display the result in well-readable format (table preffered) in the browser using parameters.
Hint: you can either write all your code in the same file or use two different files
Step by step
Solved in 2 steps
