fenway

Perhaps if I had said "Is this problem your site is experiencing new, or is this a new setup?" instead of "Clearly someone else has set up this site for you... has it ever worked?" Then no feathers would have been ruflled.

Clearly someone else has set up this site for you... has it ever worked? you must be one sad *********************** I set the sites up myself but since this is a new site and my other site is almost 5 years old you tend to forget some of the things you did to set it up. no point in reporting you as you would just delete it... selfish uptight worst mod come to mind when thinking of you.... go ****** yourself and never reply to any topics I make on here ever again please as you are disrespectful and make claims that you have not even asked enough info before making. just like I bet you will ban me and delete this only because I had the guts to stand up to you. I'm glad you've enjoyed your opportunity to rant; and you did report the post anyway, contrary to your statement above. I definitely had enough info -- you posted an error message that you didn't write, you were willing to give someone else access to your site to fix it, and you had a set-up where someone else can determine which tables your users have access to. Result = you're not in control. Which means there's no way to know what's wrong without additional information -- which you never provided. You never indicated if the site was working fine at any point in time, so it wasn't clear if this was a typo, a corrupt DB, a change in permissions, etc. If asking questions to make you think about *your* problem is being disrespectful, well... but since you're so quick to judge after being part of this forum for <24 hours, I'll be certain to keep your nickname blacklisted so that you don't get any of my "help" again. Doesn't matter to me. I'll unlock this topic briefly so that you don't feel slighted at the thought of not being able to respond (now that doesn't sound disrespectful, does it?) -- but tread carefully. I'm sure one of the other mods will be more than happy to re-lock it if things get out of hand.

select recordID, max(date) from records where row( challengeID, score ) = ( select challengeID, min(score) from records group by challengeID ) group by challengeID

Yes, kudos to all who contributed.

First, don't run two queries... you're not even using the first result. Second, don't refer to columns by their position... that's bad form. Third, what doesn't work?

Sorry, I missed that... one row? Sure, the statement you wrote is fine (but you need to quote your values).

That's not what you described before.... so instead, you need to get the lowest score for each challenge first, and then join this result back selecting the most recent date.

First, don't bump unless 24 hours have passed. Second, you're not ever retreiving any of the rows.

Don't use the first method (also called theta style). -- edit: typo First, it's very hard to mix comma with other JOINs. Second, commas have different predence than JOINs, which is a nightmare. Third, you end up munging the where clause with join conditions, which is hard to read. Fourth, you can't leave off a join condition easily... but leaving off part of a where clause it very easy to do by accident. Fifth, it's much easier to add extra tables to the second style. Basically, it causes problem and is of no benefit whatsoever.

You can use FIND_IN_SET() if they are comma separated.

You can use a CASE statement.

MySQL can do date math and automatically account for timezone differences.

How about the table structure?

You have no IN/OUT.

So then order by score DESC, `date` DESC LIMIT 1. BTW, it's bad to use a reserved keyword as the name of your field.

Clearly someone else has set up this site for you... has it ever worked?

What's dreamcoder? Aren't you writing the script yourself?

There's a BIT field, too.

Yes, indeed it is... you won't get any help that way.

Isn't this a simple ORDER BY score DESC LIMIT 1 on the records table (and then joins to get the details)?

LOL -- oops.

This is a PHP issue....

Read the sticky on this topic.

There's a sticky that has a link to one of these...

You can all multiple columns to the group by.