Use PHP5 by default by editing your .htaccess file
To make PHP5 as the default version of php for your account please insert the following line of code in the .htaccess file under the public_html directory of your account.
More »
Retrieve Data From a MySQL Database
Using PHP you can run a MySQL SELECT query to fetch the data out of the database.
Here is an example of one of the easiest ways to fetch data, this example uses a table called contact which has four columns, name, subject, address and message
<?php include 'config.php';?>
<?php
$query = "SELECT name, subject, address, message FROM contact";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{echo "Name :$row['name']} <br>
Subject : {$row['subject']} <br>
Address: {$row['address']} <br>
Message : {$row['message']} <br>";
} ?>
