Re: How to nest information from different tables.
| From: | Aldwyn | Date: | Fri, 30 Jul 2004 15:39:33 +0000 |
| Subject: | Re: How to nest information from different tables. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-192321@lists.php.net to get a copy of this message | ||
Did your table "event_details" contain a field linked with
"event.id" ? if not, you'll need it
Maybe I misunderstood what you want, but try this
$event_result = mysq_query("SELECT * FROM event_table") or
die("Cant catch events");
print("<table>");
while ($eventDb = mysql_fetch_object($event_result)){
print("<tr>");
print("<td>".$eventDb->id. " " .$eventDb->Information.
"</td">);
print("<td>".$eventDb->detail."</td>");
$event_details_result = mysql_query("SELECT * FROM
event_details WHERE event_details.id_event = ".$eventDb->id);
while ($event_detailsDb =
mysql_fetch_object($event_details_result)){
print("<td>".$event_detailsDb->file1."</td>");
print("<td>".$event_detailsDb->file2."</td>");
print("<td>".$event_detailsDb->file3."</td>");
}
print("</tr>");
}
print("</table>");
I use a script like your on my web site, and it looks like above.
Jonathan Langlois
aldwyn@laposte.net
Accédez au courrier électronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn)