Array sorting question

[dr. zoidberg]

Hello,

I have mysql table:

+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

TNX

[Albert Vernon]

> What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");
into array like this:

Add an ORDER BY clause to your SELECT statement. You didn't say what
the names of your columns are, but it'll look something like this:

SELECT * FROM table ORDER BY column2

[dr. zoidberg]

dr. zoidberg wrote:

Hello,

I have mysql table:

+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));
maybe I didn't ask correctly. Sorry for my bad english. If I do a
regular query array is:
array(
0 => 'value1',
1 => 'value2',
2 => 'value3',
3 => 'value4'));

but I need to have field ID as array key and the other field as array value.

[Garp]

"dr. zoidberg" <zo*@example.org> wrote in message
news:c5*************@ID-93631.news.uni-berlin.de...

dr. zoidberg wrote:

Hello,

I have mysql table:

+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

maybe I didn't ask correctly. Sorry for my bad english. If I do a
regular query array is:

> array(
> 0 => 'value1',
> 1 => 'value2',
> 2 => 'value3',
> 3 => 'value4'));

but I need to have field ID as array key and the other field as array

value.

You want to use the id field (I assume that's the first column in your
table) as the array key for a hash table? I don't think there's much you can
do beyond creating the array manually in your array_fetch loop:

$sql="select id,value from mytable";
$result=mysql_query($sql,$dbhandle) or die("Bad SQL! $sql");
$r=array();
$hash=array();
for($i=0;$i < mysql_num_rows($result);++$i) {
$r=mysql_fetch_array($result);
$hash[$r['id']] => $r['value'];
}

HTH
Garp

[Jan Pieter Kunst]

In article <yD*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

You want to use the id field (I assume that's the first column in your
table) as the array key for a hash table? I don't think there's much you can
do beyond creating the array manually in your array_fetch loop:

$sql="select id,value from mytable";
$result=mysql_query($sql,$dbhandle) or die("Bad SQL! $sql");
$r=array();
$hash=array();
for($i=0;$i < mysql_num_rows($result);++$i) {
$r=mysql_fetch_array($result);
$hash[$r['id']] => $r['value'];
}

Even simpler:

$sql="select id,value from mytable";
$result=mysql_query($sql,$dbhandle) or die("Bad SQL! $sql");
$hash = array();
while($r = mysql_fetch_assoc($result)) {
$hash[$r['id']] = $r['value'];
}

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

[Sandman]

In article <c5*************@ID-93631.news.uni-berlin.de>,
"dr. zoidberg" <zo*@example.org> wrote:

Hello,

I have mysql table:

+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

$q=mysql_query("select value from table") or print mysql_error();
while ($r=mysql_fetch_array($q)){
$nr++;
$array[$nr] = $r["value"];
}

--
Sandman[.net]

[Sandman]

In article <c5*************@ID-93631.news.uni-berlin.de>,
"dr. zoidberg" <zo*@example.org> wrote:

dr. zoidberg wrote:

Hello,

I have mysql table:

+----+---------+
| 1 | value1 |
+----+---------+
| 2 | value2 |
+----+---------+
| 3 | value3 |
+----+---------+
| 4 | value4 |
+----+---------+

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

maybe I didn't ask correctly. Sorry for my bad english. If I do a
regular query array is:

> array(
> 0 => 'value1',
> 1 => 'value2',
> 2 => 'value3',
> 3 => 'value4'));

but I need to have field ID as array key and the other field as array value.

$q=mysql_query("select id, value from table") or print mysql_error();
while ($r=mysql_fetch_array($q)){
$array[$r["id"]] = $r["value"];
}

--
Sandman[.net]

[Garp]

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...

In article <yD*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

You want to use the id field (I assume that's the first column in your
table) as the array key for a hash table? I don't think there's much you can do beyond creating the array manually in your array_fetch loop:

$sql="select id,value from mytable";
$result=mysql_query($sql,$dbhandle) or die("Bad SQL! $sql");
$r=array();
$hash=array();
for($i=0;$i < mysql_num_rows($result);++$i) {
$r=mysql_fetch_array($result);
$hash[$r['id']] => $r['value'];
}

Even simpler:

$sql="select id,value from mytable";
$result=mysql_query($sql,$dbhandle) or die("Bad SQL! $sql");
$hash = array();
while($r = mysql_fetch_assoc($result)) {
$hash[$r['id']] = $r['value'];
}

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

Stop simplifying my code!!

Garp

[Jan Pieter Kunst]

In article <b1*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

Stop simplifying my code!!

OK then, I'll start simplifying my own code. With PEAR::DB, you can do
this to get a database result in an associative array in one go:

$hash = $database_object->getAssoc($query);

getAssoc() gives you an associative array with the first column as the
key. Very handy.

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

[Garp]

"Jan Pieter Kunst" <de*****@cauce.org> wrote in message
news:de***************************@news1.news.xs4a ll.nl...

In article <b1*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

Stop simplifying my code!!

OK then, I'll start simplifying my own code. With PEAR::DB, you can do
this to get a database result in an associative array in one go:

$hash = $database_object->getAssoc($query);

getAssoc() gives you an associative array with the first column as the
key. Very handy.

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

Gotta love PEAR.

Garp

[dr. zoidberg]

Jan Pieter Kunst wrote:

In article <b1*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

Stop simplifying my code!!

OK then, I'll start simplifying my own code. With PEAR::DB, you can do
this to get a database result in an associative array in one go:

$hash = $database_object->getAssoc($query);

getAssoc() gives you an associative array with the first column as the
key. Very handy.

wow, I didn't know this. Thanks.

[Jan Pieter Kunst]

In article <Js*******************@news-text.cableinet.net>,
"Garp" <ga***@no7.blueyonder.co.uk> wrote:

Gotta love PEAR.

Indeed! I especially love centralized error handling. You just put this
in a config file:

PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'pear_error_handler');

You define your own pear_error_handler function:

function pear_error_handler($error_object) {
do_something_with($error_object);
}

.... and you can remove all "if error, do something" or "or die" stuff
from your database access code. Much cleaner and more readable code all
around.

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

[Frank Schummertz]

Sandman schrieb:

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

$q=mysql_query("select value from table") or print mysql_error();
while ($r=mysql_fetch_array($q)){
$nr++;
$array[$nr] = $r["value"];
}

Doing this will bring you into trouble when you delete some entries from
the table during life time.

To avoid this you would use

$q=mysql_query("select id, value from table order by id") or print
mysql_error();
while ($r=mysql_fetch_array($q)){
$array[$r["id"]] = $r["value"];
}

Frank

--
http://www.pncommerce.de

[Sandman]

In article <40*********************@news.freenet.de>,
Frank Schummertz <fr**************@landseer-stuttgart.de> wrote:

Sandman schrieb:

What is the best way to sort results from:

$query = mysql_query("SELECT * FROM table");

into array like this:

array(
1 => 'value1',
2 => 'value2',
3 => 'value3',
4 => 'value4'));

$q=mysql_query("select value from table") or print mysql_error();
while ($r=mysql_fetch_array($q)){
$nr++;
$array[$nr] = $r["value"];
}

Doing this will bring you into trouble when you delete some entries from
the table during life time.

Yes, my second post to him, after he clarified what he wanted to do, did what
you do below.
To avoid this you would use

$q=mysql_query("select id, value from table order by id") or print
mysql_error();
while ($r=mysql_fetch_array($q)){
$array[$r["id"]] = $r["value"];
}

Frank

--
Sandman[.net]