i'm trying to use the pagination script created by Stranger Studio [strangerstudios.com
].The script works fine for me but the major issue here i'm having the difficulty to get the highest click based on today date. What i want is today date ranging from the highest click to the lowest.
id| Date | Click
1. 20-07-2010 200
2. 20-07-2010 180
3. 20-07-2010 150
The mysql query were somehow doesn't blend it well with Stranger Studio script. The query worked fine if i don't used the pagination script.
Any idea how to query them in order here?
here's my problem of the code
$result = mysql_query("SELECT * FROM $tbl_name where date = '$time' ORDER BY hits $dir LIMIT $start, $limit");