Hey Josh... make sure your mysql table column is a integer... not a varchar.. i've done that by mistake a few times! On Apr 4, 2005 3:22 PM, chris <chrisj@xxxxxxxxxxxxx> wrote: > what is the structure of your table? > > "JoShQuNe" <joshqune@xxxxxxxxx> wrote in message > news:20050403233121.64749.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx > > Hi, i have a strange problem. In my site i have to counters for file > > downloads. One is general, other is weekly. On the main page i > > display a list sorted according to weekly hits. The problem is there: > > i give this prompt mysql_query("SELECT * FROM table ORDER BY > > weekly_hits DESC LIMIT 15") to display top 15 but if the hit is > > greater than 9 itz not displayed. What maybe the reason? Is it > > possible to be because of the place of the weekly_hits column in the > > table? When i try to sort by general hit, it does, but general hits > > are started with 600s so i couldn't get what happens.. Thanx for > > help.. > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Personals - Better first dates. More second dates. > > http://personals.yahoo.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
