Mook,
Below is the code I have. Obviously I have amended the name, user and password.
<!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html401/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>ClassicFM CD</title>
</head>
<link rel="stylesheet" href="z_steve.css" type="text/css" >
<body text=#FFFFFF background="z_steve_bg_red.gif">
<?php
// require 'db.inc';
$database_host = "sql5c51a.megasqlservers.eu";
$database_name = "Stephen_ccgi************";
$database_username = "ccgi************";
$database_password = "a password - not this";
// Show the CD's in an HTML <table>
function displayCD($result)
{
print "<div align=\"center\"><h1 class=\"pageName\">ClassicFM CD's by $_POST[composer]</h1></div>\n";
//print "class=\"bodyText\""
// Start a table, with column headers
print "\n<table border=\"1\" bordercolor=\"#FF9900\" align=\"center\" class=\"steve\">\n" .
"\n\t<th>Disc</th>" .
"\n\t<th>Suffix</th>" .
"\n\t<th>Track</th>" .
"\n\t<th>Title</th>" .
"\n\t<th>Movement</th>" .
"\n\t<th>Artist 1</th>" .
"\n\t<th>Artist 2</th>" .
"\n\t<th>Artist 3</th>" .
"\n\t<th>Orchestra</th>" .
"\n\t<th>Conductor</th>" .
"\n\t<th>Time</th>" .
"\n</tr>";
// Until there are no rows in the result set, fetch a row into
// the $row array and ...
while ($row = @ mysql_fetch_row($result))
{
// ... start a TABLE row ...
print "\n<tr>";
// ... and print out each of the attributes in that row as a
// separate TD (Table Data).
foreach($row as $data)
print "\n\t<td><span> {$data}</span> </td>";
// Finish the row
print "\n</tr>";
}
// Then, finish the table
print "\n</table>\n";
}
$query = "SELECT Disc, Suffix, Track, Title, Movement, Artist_1, Artist_2, Artist_3, Orchestra, Conductor, Time FROM cd where composer = '$_POST[composer]'";
// Connect to the MySQL server
// Connect to the MySQL server
if (!($connection = @ mysql_connect($hostName, $username, $password)))
die("Cannot connect");
if (!(mysql_select_db($databaseName, $connection)))
showerror();
// Run the query on the connection
if (!($result = @ mysql_query ($query, $connection)))
showerror();
// Display the results
displayCD($result);
?>
</body>
</html>
