whats the error, are there any matching fields for the columns eventetail.event and event.id? Jason
"Karl-Heinz Schulz" <[EMAIL PROTECTED]> wrote: > > Why does this query not work? > It should only show the eventdetails for the shown event. > > ---------------------------------------------------------------------------- > ----------------------------- > > <?php > $event = mysql_query("select id, information from event where id=".$id); > ?> > <?php > > $eventdetail_query = mysql_query("select titles, informations, file_name > from eventdetail, event where eventdetail.event = event.id"); > > while($eventdetail = mysql_fetch_row($eventdetail_query)){ > > > print("<span style=\"font-family: Arial, Helvetica, > sans-serif;font-size:12px;\"><a target=_blank > href=\"../PDF/$eventdetail[2]\" > class=\"decisions_links\">".strip_tags(html_decode($eventdetail[0]))."</a></ > span>"); > print(" <span style=\"font-family: Arial, Helvetica, > sans-serif;font-size:12px;\">".html_decode($eventdetail[1])."</span>"); > > } > > ?> > > ---------------------------------------------------------------------------- > ----------------------------- > > > TIA > > Karl-Heinz > > > > > Tracking #: B3BFF38AEF0C854C96E9B501DD35C6C783308CA5 > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php