// Connect to the database
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
 
// Select the database you want to use on the server
if (!mysql_select_db('databasename', $link)) {
   die('Could not select database: ' . mysql_error());
}
 
// Create the query-string. Nothing is selected yet
$query = "SELECT * FROM cartable";
// Send the query-string to actually perform the query
$result = mysql_query($query, $link);
if (!$result) {
    // This happens if there was something wrong with the query
    die('Invalid query: ' . mysql_error());
}
 
// Iterate over each row the select returned.
// mysql_fetch_assoc returns an associative array
// http://no2.php.net/manual/en/function.mysql-fetch-assoc.php
while ($row = mysql_fetch_assoc($result)) {
    // Now you can print the hyperlink
    print("<a href=\''".$row['carwebsiteurl']."\">".$row['carname']."</a>");
}
 
// Close the link when you're done
// This is also done automatically when the script ends. Do not open and close database connections for every query you do. You open one global connection to the database, and let all the scripts you execute use that one.
mysql_close($link);