[PHP] Query Question

[Karl-Heinz Schulz]

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("&nbsp<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