Someone reported to me that none of the links on the blog were working (including comments). Turned out to be a .htaccess problem. Fixed it.
My bad.
Someone reported to me that none of the links on the blog were working (including comments). Turned out to be a .htaccess problem. Fixed it.
My bad.
Nice workaround, thanks for sharing.
Other solution will be(with php/mysql):
$total_rows = your_query_invoker(“SELECT Count(*) FROM your_table”);
$pos = rand(0,$total_rows);
$sql = “SELECT * FROM your_table WHERE something LIMIT $pos,1”
The most important thing is that the rand is in php, and consume few CPU. I know that need two calls to MySQL, but if not close the socket connection it is not a big problem.
Another solution is on my blog at http://rhcms.de/blog.php 😉 Nice workaround anyway.