No need for the "sir" 😛. Anyway, I really don't know why the SQL query is giving you all the records.
But with the table, if you just wanted a table with the events:
echo "<table>\n";
echo " <tr>\n";
echo " <th><b>Event</b></th>\n";
echo " </tr>\n";
while ($row = mysql_fetch_assoc($result)) {
echo ' <tr>'."\n";
echo ' <td>'.$row['event'].'</td>'."\n";
echo ' </tr>'."\n";
}
echo '</table>';
If there are other columns you want to add, you can just add a new <th> and <td> for them. For example, if you had another column named date, it'd look like this:
echo "<table>\n";
echo " <tr>\n";
echo " <th><b>Event</b></th>\n";
echo " <th><b>Date</b></th>\n";
echo " </tr>\n";
while ($row = mysql_fetch_assoc($result)) {
echo ' <tr>'."\n";
echo ' <td>'.$row['event'].'</td>'."\n";
echo ' <td>'.$row['date'].'</td>'."\n";
echo ' </tr>'."\n";
}
echo '</table>';
Hopefully you get the idea.
