fenway

How is that helpful? We just metioned above that you CAN'T use * with GROUP BY...

I don't see why it wouldn't work.

This one... there are hundreds of resources posted in the stickes on this board. For now, try this: SELECT * FROM `table` WHERE `surname` IN (SELECT `surname` FROM `table` WHERE `status` = 'confirmed' GROUP BY `surname` HAVING COUNT(*) > 1) AND `status` = 'confirmed' ORDER BY `surname`

Well, to insert into 2 tables you need 2 insert statements, so there's "other way". I would print out a location header to make sure that it doesn't get POSTed twice.. .but that's not a mysql issue anymore.

Why wouldn't it?

Then add a WHERE clause to the subselect.

From the refman:

Posting gobs of code isn't helpful in the least... post the lines around the error message.

The query posted earlier should work.

Yikes... an UPDATE with no WHERE clause....

Where's the group by?

So you're not joining the tables on a UID? That's not going to be fun for performance. Either way, it's a straight-forward join, and after that, the display is up to you.

It's a LEFT JOIN...there should be no issue.

So use ORDER BY percentage DESC, (wins+losses) desc limit 1

Try: CONCAT_WS( ' ', (IFNULL(user.first,'') IFNULL(user.last,'')) AS c

Display is not a mysql issue.

I was thinking that any update to a revision would change the timestamp but not the uid. Anyway, you could still do it with max/min, but you'd have to join them back to the main table to get the details on eacah page.

You can not use * with GROUP BY.

You can use AND, OR in your WHERE clause.

NOT IN? Use a left join instead.

Such as?

Not that helpful... echo mysql_error()... but I would guess it's an escaping issue.

With a join on flag_id.

You have a timestamp... why use the id?

Run what?