Posted by Toby A Inkster on 08/28/07 07:20

JackpipE wrote:

> NAME | VALUE
> nameA | 10
> nameB | 12
> nameB | 10
> nameB | 10
> nameC | 87
> nameC | 56

$myarray = array();
while ($row = sql_fetch_row($results))
{
list($name, $value) = $row;
if (!isset($myarray[$name]))
$myarray[$name] = array();
$myarray[$name][] = $value;
}
extract($myarray);

Where sql_fetch_row() is whatever function is provided by your database to
retrieve an enumerated array -- e.g. pg_fetch_row() or mssql_fetch_row().

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 68 days, 10:49.]

TrivialEncoder/0.2
http://tobyinkster.co.uk/blog/2007/08/19/trivial-encoder/

[Back to original message]