Philippe,
I changed my to the following but the result is now (I deleted the print
stuff for better reading)
<?
$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)){
$eventdetail_query = mysql_query("select titles, informations, file_name
from eventdetail, event where event.id=eventdetail.event AND
event.id=".$event[0]);
while($eventdetail = mysql_fetch_row($eventdetail_query)){
}
}
?>
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
But I would need
Event 1
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
Event 2
Details 1 for event 2
Details 2 for event 2
Details 3 for event 2
Is this even possible?
TIA
-----Original Message-----
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 5:52 AM
To: Karl-Heinz Schulz
Cc: [EMAIL PROTECTED]
Subject: Re: SQL Syntax Question
Karl-Heinz Schulz wrote:
> Thank you for trying to help me.
> The output is wrong
>
> I get either
>
> Event 1
> Event 2
>
> Details 1 for event 1
> Details 2 for event 1
> Details 3 for event 1
that query is wrong :
$eventdetail_query = mysql_query("select informations, titles, file_name
from eventdetail, event where eventdetail.event =".$event[0]);
try :
select informations, titles, file_name
from eventdetail, event where event.id=".$event[0] " AND
event.id=eventdetails.event
Tracking #: 3842A5D2EB81014B918FDB71F1DE0830A35E8D56
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
