fenway

There's obviously some collation that was missed... post the detailed column info for each table involved.

This doesn't sound like a mysql question....

Agreed... you may want to store them in the DB after all....

There are two different syntaxes, though the latter is more common.

How?

Have you tried re-installing?

It's ugly, why do you need to?

So what do you have now? what error do you get when you add back the order by?

It's not solved until you tell us how....

What are the collations for the tables/columns?

Post what you have so far, and I'll show you how to inject this.

Yes, two commas.

Something mysql-specifc?

Yes, well, if you've already authenticated the user, you can spit out UIDs, but they can still change them in the hidden inputs... so as long as this won't result in them editing someone else's record, that's fine... hence the security issue.

I do this sometimes, but not very often... even so, a TIME field is always the best choice vs TIMESTAMP.

We're just looking for some effort on your end to work towards a solution.... select t.id count(p.question_id) from topics as t left join posts as p on p.question_id=t.id group by t.id Will give you the # of posts per topic. If you want to deal with subcategories, you'll need to join them in as I said earlier.

they are your domains, no?

You just need to join in the players table.

You need to add c.x=1 to the ON clause.

Actually, didn't realize it was based on the current time, so it's a bit different: SELECT some, fields FROM mytable WHERE `time` BETWEEN CURDATE()+INTERVAL 9 HOUR AND CURDATE()+INTERVAL 9 HOUR-INTERVAL 1 DAY

What have you tried? Whare you uploading it to?

Agreed... don't reset IDs, unless you blow away all of the data in the table, in which case use TRUNCATE, not DELETE.

Which is why I said you'd have to replicate the directory tree containing the images...

Don't know what you mean about unique rows... if you're only using a single table, a row can never be returned twice.

You can try and use FEDERATED tables.