Re: [PHP] Getting mysql_query results into an array

On Wed, February 14, 2007 11:34 am, Bill Guion wrote:
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.

The original question was "what's most efficient".

For a small number of items (like 15) the efficiency probably isn't
all that big a deal...

For a large number, however, you still might be better off with a
"select count(*)" query, and then use some sort of modulus operator
with a row number in the DB to order the data. Or maybe not, as you
won't have an index on that, most likely... All depends on your
hardware, your data, your situation...

All that said, outputting them as div/span tags might actually be most
efficient, and play a trick with CSS to get them aligned the way you
want, even though they appear in the original order within the raw
HTML output.

--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some starving artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?
.

Relevant Pages

  • Re: Copying a table to an array
    ... You probably don't need a query, ... Dim rstRSet As Recordset ... table to enable data from the latter to be read into an array with GetRows. ... exercise has therefore to be repeated prior to each interrogation. ...
    (microsoft.public.access.formscoding)
  • Re: Mix/Max/Avg Help based on dynamic ranges
    ... Did you enter Biff's formula as an array? ... The query I gave you is dependent on your breaking out the ranges as Biff ... Where Nums are the values to avg based on the head count range. ... deemed optimal for building device profiles based on locn size and device ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Copying a table to an array
    ... "Peter Hibbs" wrote: ... You probably don't need a query, ... Dim rstRSet As Recordset ... table to enable data from the latter to be read into an array with GetRows. ...
    (microsoft.public.access.formscoding)
  • Re: Imitating Mail Merge on server
    ... given moment we know which data (in this case, customers) is being worked ... and concantenate each query together. ... loop the array, plug in the current recordset value. ... We have close to fifty tokens that we use in the application correspondence, ...
    (microsoft.public.inetserver.asp.general)
  • Re: Subquery Confusion
    ... Then I got this crazy idea that an Array can only contain a maximum ... number of characters, ... Then I decide that maybe I'm completely wrong with my query, ... it out of Excel VBA and spit it into Microsoft SQL Server Management ...
    (microsoft.public.excel.programming)