November 9th, 2006, 01:40 PM
|
|
|
|
Join Date: Apr 2007
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
MDB2 nested queries problem
Hi every one,
I have a problem with MDB2 when i want to use it inside a loop.
I searched the manual but i couldn't find any solution. it seems second query overrides first one. do you have any idea?
here is my code :
php Code:
 Original
- php Code |
|
|
|
$queryResultLevel1 = &$storage->query('SELECT * FROM users'); while ($rowLevel1=$queryResultLevel1->fetchRow(MDB2_FETCHMODE_ASSOC)) { echo "Photos of user ". $rowLevel1['name']. " : <br/>"; $queryResultLevel2 = &$storage->query('SELECT * FROM users_photos WHERE user_id='.$rowLevel1['id']); while ($rowLevel2=$queryResultLevel2->fetchRow(MDB2_FETCHMODE_ASSOC)) { echo "- ". $rowLevel2['filename']. "<br/>"; } }
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
