topher

Ok, so I made an admin interface. If the new insert works, you’ll see this post.

In other news, ORDER BY RAND() appears to be broken when running it through php on my server, which means no random non-sequiters for now.

Breaks your heart, don’t it?

11 thoughts on “testing… testing…

  1. PHP doesn’t affect the ORDER BY RAND() behavior — PHP simply passes your query through to MySQL, and fetches the result back.

    I would wager that you’re seeing the results you’re seeing because of the MySQL version that you’re using. On this page:

    http://www.mysql.com/doc/en/Mathematical_functions.html

    you can read about RAND() not behaving randomly anymore. Look for a comment by “Nick Gaugler”. I think the solution is to add some sort of seed. I’m using NOW(), which isn’t the best, but works a little better.

Leave a Reply

Your email address will not be published. Required fields are marked *