Displaying Headers

jennifer_ann

Ok I have this php page that displays my query results. However, above the results on my webpage I want there to be a header above the colum that will look something like this

Country City State

 country                            city                                 state

Here is the code

<html>
<head>
	<title>Eye Contact - Century to Century</title>
	<link rel="stylesheet" href="eye01.css" type="text/css" />
</head>
<body>
<form name ="" method = "post" action="">
<table width="100%" height="100%" border="0">

<?php
$db = mysql_connect("localhost","root","");
if (!$db){
		print "error - Could not connect to MySQL";
		exit;
}

$er = mysql_select_db("touch_art1");
if(!$er)
{
	print "error - Could not select the database";
	exit;	
}
extract($_POST);

$query = "SELECT date, yr_left, city_origin, country_origin, yr_arrival, city_arrival, state_arrival, filename FROM story WHERE state_arrival = '$state_select' AND pamapproved = 'y' ORDER BY yr_left";
	$result = mysql_query($query);

if(!$result)
{
	print "Error on Query";
	exit;
}	
else
{
	while($column = mysql_fetch_object($result))
	{
		print "<tr>";
		foreach($column as $colval)
		{
			print "<td>$colval</td>";
		}
		print "</tr>";
	}
}

mysql_free_result($result);

mysql_close();
?>

<input type="hidden" name="" value="none">

<tr height="10%">
	<td align="left" valign="top" width="50%">
	<embed src="images/home.svg" width="100%" height="100%" wmode="transparent" type="image/svg+xml" />
	</td>
	<td align="right" valign="top" width="50%" colspan="2">
	<embed src="images/back.svg" width="100%" height="100%" wmode="transparent" type="image/svg+xml" />
	</td>
</tr>
</table>
</form>
</body>
</html>

I would appreciate any suggestions!

gardnc

more or less like this - just add a row with the headings:

else
{
echo "<tr>";
echo "<td>County</td><td>City</td><td>State</td>"'
echo "</tr>";
while($column = mysql_fetch_object($result))
{
print "<tr>";
foreach($column as $colval)
{
print "<td>$colval</td>";
}
print "</tr>";
}
}

jennifer_ann

Do i place that before my query?

Houdini

Place it before the while{do something} loop so placing it before the query would be alright unless it fails so instead place it in the else block before the while{do something} loop.

gardnc

Place it right where I placed it, just after the else and prior to the while.