//make database connection:
include ‘/home/account/MySQLconnections/books1.php’;
//create an SQL statement:
$query = "SELECT author_last FROM author ORDER BY author_last";
//query the database and retrieve the results:
$result = mysql_query($query) or die("Error in: $query");
print "Here are the authors:
"
//display the results
while ($row = mysql_fetch_array($result))
{
print "$row[author_last]";
print "
";
}
?>