Posted by Joe Harman on 04/05/05 00:38

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@data-trak.com> wrote:
> what is the structure of your table?
>
> "JoShQuNe" <joshqune@yahoo.com> wrote in message
> news:20050403233121.64749.qmail@web50809.mail.yahoo.com...
> > 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
>
>

[Back to original message]