Php sort with mysql_fetch_array

Question

im trying to sort names from sql

while($ddfg = mysql_fetch_array($result_skey002))
{
    $total = $ddfg['name2'];
}
sort($total);
echo $total;

Somthing like that ..,
Im work with name in hebrew so this its doesnt working:

$query_skey002 = "SELECT * FROM s_keywords ORDER BY `name2` ASC";

I have no idea how to work with php sort function.
Thanks for the helpers

Apart from the fact that you should do that in the database, you are overwriting your variable (a string) in the loop and feeding a string to an array function. — jeroen
– jeroen, Commented Jul 17, 2013 at 20:44
$total = $ddfg['name2']; should be $total[] = $ddfg['name2']; and echo $total should be something else — Orangepill
– Orangepill, Commented Jul 17, 2013 at 20:52

Asaph · Accepted Answer · 2013-07-17 21:10:28Z

4

Don't sort in PHP. Your database query is doing that. No need to sort twice. MySQL can sort hebrew text if you use the correct charset/collation.

http://dev.mysql.com/doc/refman/5.0/en/charset-mysql.html

Update:

Here is a working example of inserting hebrew into a mysql table. I tested it and it definitely works:

mysql> create table hebrew_table (my_column varchar(128)) charset=hebrew;
Query OK, 0 rows affected (0.03 sec)

mysql> insert into hebrew_table (my_column) values ('אחד');
Query OK, 1 row affected (0.00 sec)

mysql> select * from hebrew_table;
+-----------+
| my_column |
+-----------+
| אחד       |
+-----------+
1 row in set (0.01 sec)

edited Jul 17, 2013 at 21:10

answered Jul 17, 2013 at 20:43

Asaph

163k25 gold badges204 silver badges204 bronze badges

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

16 Comments

Niv_H Over a year ago

Mysql query dont know to do that with hebrew.

Asaph Over a year ago

Look to see if mysql supports a charset/collation that can sort hebrew.

Eric Petroelje Over a year ago

@Niv_H - it should work in MySQL. Is the table using the utf8 character set and collation for that column and is your database connection using UTF8 as well for the client connection character set?

Samuel Cook Over a year ago

you might be able to cast as hebrew_general_ci

Niv_H Over a year ago

I tried.. sql not suppurt hebrew, when i insert string in hebrew its showing in gibberish

|

Pank · Accepted Answer · 2013-07-17 20:53:19Z

1

Your database query is proper. It will sort result when your SQL query get executed.

You may improve your select SQL query using below one..

$query_skey002 = "SELECT * FROM `s_keywords` ORDER BY `name2` ASC";

answered Jul 17, 2013 at 20:53

Pank

14.4k10 gold badges35 silver badges46 bronze badges

1 Comment

Pank Over a year ago

MySQL has very less support for other languages as well as php5.5 deprecated MYSQL. Try for MySQLi..

Collectives™ on Stack Overflow

Php sort with mysql_fetch_array

2 Answers 2

Update:

16 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update:

16 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related