";
print mysql_connect_error();
print "
";
}
// print "connected
";
mysql_select_db('sla');
$query="SELECT * FROM sermons ORDER BY date DESC";
$result=mysql_query($query);
$error=mysql_error();
if($error) {
print "query $query
lead to error $error
";
exit;
}
print "\n";
// fields in the database
$fields=array('date','day','speaker','title') ;
print "";
foreach($fields As $field) {
print "| $field | ";
}
print "
\n";
while($columns=mysql_fetch_array($result)) {
print "";
foreach($fields As $field) {
print "| $columns[$field] | ";
}
print "
\n";
}
print "
"
?>
