[PHP] Re: A strange problem..

2005-04-04 Thread chris
what is the structure of your table?


JoShQuNe [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 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



Re: [PHP] Re: A strange problem..

2005-04-04 Thread Joe Harman
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 [EMAIL PROTECTED] wrote:
 what is the structure of your table?
 
 JoShQuNe [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]
  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