The main related clauses

1. Start a connection

<?php
//start a session:
session_start();

// db properties:
$DBhost = 'localhost';
$DBuser = 'root'; 
$DBpass = 'pass_word';    
$DBname = 'academia';

//Open a connection
$conn = mysql_connect($DBhost, $DBuser, $DBpass) or die 
('Error connecting to mysql');
//Select a database:
mysql_select_db($DBname);
?>

2. Query & result

$query  = "CREATE DATABASE academia";
$result = mysql_query($query);
or:
mysql_create_db('academia');

3. Fetching values from MySQL database

Returning the row as an associative array:

$query  = "SELECT value1, value2, ..., other_value FROM table";
$result = mysql_query($query);

4. List the values

4.1. Using MYSQL_ASSOC
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Name1 :{$row['value1']} <br>" .
"Name2 : {$row['value2']} <br>" .
"Name3 : {$row['other_value']} <br>";
} 
or
while($row = mysql_fetch_assoc($result))
{
echo "Name1 :{$row['value1']} <br>" .
"Name2 : {$row['value2']} <br>" .
"Name3 : {$row['other_value']} <br>";
} 

4.2. Using MYSQL_NUM
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
echo "Name1 :{$row[0]} <br>" .
"Name2 :{$row[0]} <br>" .
"Name3: {$row[0]} 
";

4.3. Using LIST
		 
while(list($phys_id,$first_name,$last_name)= mysql_fetch_row($result))
{
echo "id : $phys_id <br>" .
"First name : $first_name <br>" .
"Last name : $last_name <br>";
}
Or:
while($row = mysql_fetch_row($result))
{
$phys_id    = $row[0];
$first_name    = $row[1];
$last_name = $row[2];

echo "id :$phys_id <br>" .
"First name : $first_name <br>" .
"Last name : $last_name <<br>";
} 

5. Free the memory

mysql_free_result($result);

6. Close the connection

mysql_close($conn);