I have two tables with relevant information's;
Table1 -> event
Table 2 -> eventdetails
I'm trying to list all events in table one plus to show for each event
whatever documents are available (file_name, information)
My code to list all events from the "event" table is:
<code>
<?php
require("../admin/functions.php");
include("../admin/header.inc.php");
?>
<?
$event_query = mysql_query("select id, inserted, information, eventname,
date, title from event order by inserted desc LIMIT 0 , 30");
while($event = mysql_fetch_row($event_query)){
print("<b><span style=\"font-family: Arial, Helvetica,
sans-serif;color:#003300;font-size:14px;\">".html_decode($event[5])."</span>
</b><br>");
print("<span style=\"font-family: Arial, Helvetica,
sans-serif;font-size:12px;\">".html_decode($event[4])."</span><br>");
print("<span style=\"font-family: Arial, Helvetica,
sans-serif;font-size:12px;\">".html_decode($event[2])."</span><hr><p>");
print ( here I would need the list of all files associates with the event "
$eventdetails_query = mysql_query("select filename, information from
eventdetails where event=".$id);"
}
?>
</code>
Can this be done and what would be the best approach?
TIA
Karl-Heinz
Tracking #: A3E9B485BFDA4A44A6BFCE20A805CA39C3D820DA
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
