displaying database output in a table
| From: | David Mehler | Date: | Wed, 26 May 2010 01:27:35 +0000 |
| Subject: | displaying database output in a table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-305529@lists.php.net to get a copy of this message | ||
Hello,
I'm trying to display mysql database output in a formatted table. My
problem is i'm getting a blank screen with no errors. I've got
debugging on, and have run the cli php on this file which produces no
errors either, but neither does it give me any output.
My eventual goal is to select the two nearest future events to the
current date. Having done that I want to display the name, location,
start date, start time, and a summary. Right now though I just want to
put all information in the database in to a table.
Here's the code. Pointers welcome.
Thanks.
Dave.
<?php
require_once($_SERVER['DOCUMENT_ROOT'] . "/dbconnect.php");
function displayEvents($result) {
echo "<h2>Two Next Upcoming Events.</h2>\n";
?>
<table border=1 cellpadding="5" cellspacing="1">
<tr>
<th>Event Location.</th>
<th>Event Summary</th>
<th>Event Time</th>
</tr>
<?php
while ($row = @ mysql_fetch_row($result))
{
echo "\n<tr>";
foreach($row as $data)
echo "\n\t<td> $data </td>";
echo "\n</tr>";
}
?>
</table>
<?php
$query = "SELECT * FROM events";
if (!($result = @ mysql_query ($query, $db)))
displayEvents($result);
mysql_close($db);
}
?>