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

Reply via email to