Hi, You can use join or make this query as follows
$query="select *(or coulmn name) from event, eventdetails where event.id = eventdetails.id"; zareef ahmed --- Karl-Heinz Schulz <[EMAIL PROTECTED]> wrote: > 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 > > ===== Zareef Ahmed :: A PHP Developer in Delhi(India). Homepage :: http://www.zasaifi.com __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php