Hi. I am struggling to get a page to work, getting an error instead. connecting to database is fine, but the query is failing.. can you tell me where i am going wrong please. Have edited the names of the fields out, also the database details. The page loads with query fail message, a custom one "Unavailable at present" Any help checking over this code and pointing me in the right direction would be appreciated.
<html>
<head>
<title>page title</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body bgcolor="#CCCCCC" text="#000000" link="#000000" vlink="#000000" alink="#FF0000">
<?php
// (C) 2003
mysql_connect("host","username","pass") or die ("can't select MySQL server");
if (!$link = mysql_connect("host","username","pass"))
exit("Unable to make a connection to the database");
mysql_select_db("database name") or die ("can't open database");
if (!mysql_select_db("database name", $link))
exit("Unable to select the database");
// connecting to database is successful
$query = "SELECT field_1, field_2, field_3, field_4, field_5, field_6, FROM table_name ORDER BY field_1";
$table_name = mysql_query($query) or die ("Unavailable at present");
// am getting the Unavailable at present message
$query = "SELECT field_1, field_2, field_3, field_4, field_5, field_6, FROM table_name ORDER BY field_1";
if (!$table_name = mysql_query($query, $link))
exit("Illegal query");
while ($table_name = mysql_fetch_array($table_name))
{
?>
<table width="70%" border="0" align="center" cellpadding="0">
<tr bgcolor="#666666">
<td width="101"><b><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_1'];?></font></b></td>
<td width="65"><b><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_2'];?></font></b></td>
<td width="73"><b><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_3'];?></font></b></td>
<td width="73"><b><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_4'];?></font></b></td>
<td width="29"><b>
<div align="center"><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_5'];?></font></div>
</b></td>
<td width="26"><b>
<div align="center"><font color="#FFFFFF" size="1" face="Arial, Helvetica, sans-serif"><?php echo $table_name['field_6'];?></font></div>
</b></td>
</tr>
</table>
<?php } ?>
</body>
</html>
