Ed Rackham - Web Application Developer

PHP, MySQL, and Other Web Snippets!

Search

// home

Latest Post

Solution to Form Submit 403 Error

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://' [...]

Continue Reading One comment JavaScript

Featured Post

Get Random Row with MySQL Without ORDER BY RAND()

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 [...]

Asides

Wow. This was definately a gig to remember! I've seen these guys a few times, but the amount of effort they've put into the release of their album has been phenomenal. The energy on stage was amazing, the music was spot on and everyone in the venue were on their feet. I really hope these guys make it. They deserve it. #
Wooo! Well I'll be moving house on Tues 12th Feb, right before my birthday too! Not that there have been lots of posts recently, but just so you know that there won't be many over the next week or so. #