You are here: Re: Display X Items per page with sort option? « PHP Programming Language « IT news, forums, messages
Re: Display X Items per page with sort option?

Posted by muldoonaz on 09/08/05 21:59

yellow1912 wrote:
> Thanks a bunch!!!
>
> But I ran into this:
> For example I have a column "NAME" contains name:
> Name 1
> Name 2
> ....
> Name 99
>
> If I ORDER BY NAME DESC I will get something like this:
> Name 99
> Name 98
> .....
> Name 90
> Name 8 //The problems is here
> Name 89
> Name 88
> .....
>
> The problem, I believe, is because of the way mysql compares the
> strings. Hence make this sort kinda weird! How can I fix this, any
> walk-around?
>

add a 0 to the 8 so it shows 08 in the DB. That'll make it order them
right.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация