At 6:22 PM -0600 2/13/07, Richard Lynch wrote:
The most efficient way is "Don't do that." :-)
Simply loop through the results and do whatever you want to do with
them, and don't put them into an array at all.
This question has appeared before, and usually breaks down to one of
these scenarios:
#1
snip 1
#2
snip 2
#2 does occasionally have an exception to the rule, where the SQL
query is nasty and the PHP is fast and easy, but that's awfully rare.
How about scenario #3: I wish to output my data in (for example)
three columns, as a phone book does. To make the example simple,
assume 15 data points. I wish the output to look like
1 6 11
2 7 12
3 8 13
4 9 14
5 10 15
So when I'm outputting row 1, I need data points 1, 6, and 11. Isn't
it easier to generate the query, put in array, and output the rows
from the array? Keep in mind, the number of data points might be
variable, the constraints being n columns with approximately the same
number of data point in each column.
-----===== Bill =====-----
--
The secret of life is...I can't tell you. It's a secret.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
