| Nested SQL queries? [message #20907] |
Tue, 02 November 2004 00:24  |
Abraxa
Messages: 72
Registered: August 2004
Location: Germany
Karma: 0
|
Member |
|
|
Heya =)
I was wondering if it's possible to nest SQL queries:
Due to modifications in the message drawing template I need to gather additional data for drawing the messages. If I however do an SQL query in drawmsg.inc.t, the loop in msg.php.t that loops through the results of the big SQL query breaks.
Is there any way to quest SQL queries - as in doing an SQL query while the results of a previous query aren't fully processed yet?
-Abraxa
|
|
|
|
| Re: Nested SQL queries? [message #20909 is a reply to message #20907] |
Tue, 02 November 2004 00:34  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You need to change the query execution function from uq() to q(), the former is an unbuffered query, which means a new query will trash the not yet retreieved rows.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]