building data into tables from mySql

[vincewooll]

OK, I guess I'm suffering brainfade here, but can anybody tell me why this isn't working?
I can get it to work if I manually run php.exe & pipe it to a document then call that, but when running it directly only the table headers are picked up. Any help much appreciated guys & girls.

<snip>

$result = mysql_query($sql,$connection)
or die("Couldn't execute query.")
?>

<table width="100%" border="1">
<tr>
<td class="table_header" width="20%">Poster</td>
<td class="table_header" width="70%">Message</td>
<td class="table_header" width="10%">Date</td>
</tr>

<?
while ($row = mysql_fetch_array($result)) {
$p_name = $row['pub_name'];
$p_message = $row['pub_message'];
$p_date_posted= $row['pub_date_posted'];

echo "<tr>";
	echo  "<td>$p_name</td>";
	echo  "<td>$p_message</td>";
	echo  "<td>$p_date_posted</td>";
echo "</tr>";
}  

?>
</table>

[Anon]

vince, you are missing the ; at the end of this line.

$result = mysql_query($sql,$connection)
or die("Couldn't execute query.") ;

usually PHP tells you the line where your error is, and ofthen the error is in the previous line.