PHP - Sort mysql_fetch_array based on number

Question

So I have a tabel with 10 Rows in it,

They look like this :

+++++++++++++++++++++++++++++++++++++++
+ ID + ACTIVE + NAME + DESCRIPTION    +
+++++++++++++++++++++++++++++++++++++++
+ 1  + 1      + ONE  + O-N-E          +
+++++++++++++++++++++++++++++++++++++++
+ 2  + 2      + TWO  + T-W-O          +
+++++++++++++++++++++++++++++++++++++++
+ 3  + 0      + THREE+ T-H-R-E-E      +
+++++++++++++++++++++++++++++++++++++++
+ 4  + 4      + FOUR + F-O-U-R        +
+++++++++++++++++++++++++++++++++++++++
+ 5  + 5      + FIVE + F-I-V-E        +
+++++++++++++++++++++++++++++++++++++++
+ 6  + 3      + SIX  + S-I-X          +
+++++++++++++++++++++++++++++++++++++++

I'm getting the values of this table by using

$result = mysql_query("SELECT * FROM Table WHERE ACTIVE != 0") or die (mysql_error());

And then I'm fetching them with :

$values = mysql_fetch_array($result) or die (mysql_error());

But now the problem is, that the come out this way : 1 2 4 5 3

And I would like to order this while keeping the NAME and DESCRIPTION that belong to the ACTIVE .

I've read a little bit about sorting 2D array's but I'm not getting anywhere, so if anyone has a clear solution or clear article that would help me alot! Thanks for reading.

You are better off sorting them at the database level, see ORDER BY — hank
– hank, Commented May 15, 2013 at 14:01
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented May 15, 2013 at 14:01
Thanks, is changing mysql to mysqli functions only a case of an extra letter or do I need to change alot more in my code? — notknown7777
– notknown7777, Commented May 15, 2013 at 14:03

alexis · Accepted Answer · 2013-05-15 14:20:37Z

3

Yeah, switch to mysqli or whatever, but the answer to your question is: Add ORDER BY ID to your query:

"SELECT * FROM Table WHERE ACTIVE != 0 ORDER BY ID"

answered May 15, 2013 at 14:20

alexis

50.4k18 gold badges108 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2368299 · Accepted Answer · 2013-05-15 14:04:37Z

0

You need use

while ($values = mysql_fetch_assoc($result))
{
echo $values['NAME']." ".$values['DESCRIPTION'];
}

answered May 15, 2013 at 14:04

user2368299

3793 silver badges15 bronze badges

Comments

aef · Accepted Answer · 2013-05-15 14:06:14Z

0

use mysql_fetch_assoc and access your values by using $values['nameOfValue']

answered May 15, 2013 at 14:06

aef

663 bronze badges

Comments

Fabio · Accepted Answer · 2013-05-15 14:20:10Z

0

What about using ORDER BY directly in mysql?

$result = mysql_query("SELECT * FROM Table WHERE ACTIVE != 0 ORDER BY ACTIVE ASC") or die (mysql_error());

Then I would like you to remember that mysql_* functions are deprecated so i would advise you to switch to mysqli or PDO

answered May 15, 2013 at 14:20

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Collectives™ on Stack Overflow

PHP - Sort mysql_fetch_array based on number

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related