Query Question
| From: | Karl-Heinz Schulz | Date: | Thu, 12 Aug 2004 01:57:27 +0000 |
| Subject: | Query Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193523@lists.php.net to get a copy of this message | ||
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