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?
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?
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.
This is a test post.
Apparently this will be the post I do all my testing on.
testing AGAIN
still testing
testing the new design.
Testing a new jabber interface.
Testing jabber again
testing
Testing, 1…2…3…
Once more with FEELING!