Re: displaying result problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/12/06, adi zebic <azebic@xxxxxxxxx> wrote:
Hi,

I have little problem while displaying a result from one simple querry.
If i insert values into mysql DB in following order (12, 3, 14, 4 )
I allways have  ( 12, 14, 3, 4 ) displaying when query the DB. (same with
letters - dcba -> abcd etc)
I would like to be able to display the data like they are inserted into
database.

A database will order things randomly unless you tell it how to order
the results.

As Tedd suggested, add an id field and then you can order by that field:

select * from table order by id ASC;

http://dev.mysql.com/doc/refman/5.1/en/sorting-rows.html

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux