The SELECT statement is used to select data from a database.
To learn more about SQL, please visit our SQL tutorial.
To get PHP to execute the statement above we must use the mysql_query() function. This function
is used to send a query or command to a MySQL connection.
The Below example selects all the data stored in the "Persons" table (The * character
selects all the data in the table):
The example above stores the data returned by the mysql_query() function in the $result
Next, we use the mysql_fetch_array() function to return the first row from the recordset as an
array. Each call to mysql_fetch_array() returns the next row in the recordset. The while loop
loops through all the records in the recordset. To print the value of each row, we use the PHP
$row variable ($row['FirstName'] and $row['LastName']).
The output of the code above will be:
The Below example selects the same data as the example above, but will display the data in an
Your Query was successfully sent!