Have you ever had a problem where you get a HTTP 403 error from submitting a form? Does this form have a field that submits a URL? If yes to the above two questions, I think I know the problem you're having, and have a solution. It's to do with mod_security (an Apache module) and the 'http://' [...]
This is an update to a previous post of mine which uses the RAND() method. Using the following code, you can retrieve a random row much, much faster (MySQL 4.1.x/5.0.x), with thanks to Jan Kneschke: SELECT <COLUMN> FROM <TABLE> AS r1 JOIN (SELECT ROUND( RAND( ) * ( SELECT MAX( id ) FROM <TABLE>) ) AS [...]
The life of a web application developer, called Ed.