Re: How to nest information from different tables.

From: 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)

« previous php.general (#192321) next »