> Here's the question... > > I can either A) in the header or my page, generate a recordset of all of > the records in the related table and then loop through the recordset > creating an array of the fields I need and then later pull from it in the > repeat region... or B) take the six lines of code Dreamweaver generates to > create a recordset and move them into the repeat region itself. In other > words, I can create a recordset of all of the records in the related table, > loop through it generating a PHP array and pull from this array later OR I > can query the database every time through the loop while creating the > repeat region. > > Robb Kerr > Digital IGUANA > Helping Digital Artists Achieve their Dreams > ---------------------------------------------------- > http://www.digitaliguana.com > http://www.cancerreallysucks.org > Robb,
How about choice "C"? :-) Query once if you can. Running multiple queries in a loop is always going to be slower. Now, I'm not totally sure I understand the problem. It sounds like you have one table to query and then you query a second table??? If that's true then what about a join to get everything you need from both tables at once? The idea here is that you get one result from MySQL and then loop through your result and display your content. Hope I'm not too far off. Jim Grill -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
