MySQL Part 4 - English

2373 visits



Outline:

MySQL (Part 4) Getting data from the database table and displaying it. SELECT QUERY - SELECT * FROM table_name WHERE att1='abc' // Query returns the value from the database where att1 = abc mysql_num_rows() - Gives us the number of rows there are in the query we have just given out. ORDER BY - Helps to order the output result as when selecting the values form the database. Use of DESC for Descending ordering / ASC for Ascending ordering