fenway

FYI, this isn't as effecient as using a dervied table with this information, since it doesn't depend on the player_score value (so a subquery is expensive for no reason).

Funny, doesn't sound like MySQL...

You'll need to have a serve script that print the appropriate headers... but this isn't a mysql question.

Hidden fields are totally useless for security.

MySQL has a STR_TO_DATE() function too...

And you're confident it's the mysql connection, not the connection itself?

I feel like a broken record... there's a sticky on the Installation child board -- read it and see if that leads you in the right direction.

There's a sticky in the Installation child board that you should read.

Root is the default... you have to make some users.

Then you have some reading to do...

Sort of... there's meta information about the tables that can be queried...

First, you can extract each piece of the date using mysql functions, but I don't see really why you're doing this....

If find it hard to believe that it's the connection as opposed to a query....

I'd recommend this instead: SELECT p.purchaseID, p.productID, u.userName FROM products.productInformation p JOIN user.users u ON p.userID = u.userID ORDER BY u.userName But it should have worked syntactically both ways.

And then you don't need to LOCK/UNLOCK the tables.

Have you ever worked with JOINs before?

Normalized, faster, better, logical, etc.

That would be my suggestion.

If you really want to be fancy, you can issue an alter table statement and sort the whole table,then the rows will be retrieved the way you want them. Really? It doesn't "know" how you want your results, YOU told it to be ordered a certain way. If it can figure out a fast way to do it, it will -- otherwise it will take more work. Try and get a card dealer to deal from the bottom of the deck instead, see if it takes any longer.

ORDER BY rating DESC LIMIT 5.

What?

Yes, and a JOIN would be better.

But which machine will you store the images on if it's not in the db?

Correct how?

Web server do a lot of disk I/O, not a lot of number crunching data set manipulation.