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.
Not picking fault at all, but I thought it worth a mention. When using a mysql_query(); function and constructing a statement that contains concatenated vars in there, I would always construct the string outside of the function, and assign it to a var, just so that you can easily debug it should something go wrong.
$SqlQuery = "SELECT * FROM `".$tbl_name."` WHERE `date` = '".$time."' ORDER BY `hits` ".$dir." LIMIT ".$start.", ".$limit." "; $result = mysql_query($SqlQuery);
At least this way its easier to debug the string to screen.