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
