Working on a calendar, here's what I've got:
$query = "SELECT event FROM calendar where month='$m' order by date";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
HTML:
<tr>
<td height="100" valign="top"><p>1</p>
<p align="center">
<?php
echo "$row[0]";
?>
</p></td>
<td height="100" valign="top"><p>2</p>
<p align="center">
<?php
echo "$row[1]";
?>
</p></td>
<td height="100" valign="top"><p>3</p>
<p align="center">
<?php
echo "$row[2]";
?>
</p></td>
etc. etc. etc. til the end of the month. When I run the script, it only generates the first event and the others aren't there. I've used a while() loop to make sure they're all being selected correctly. Any ideas?
~JOSH
