fenway

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.

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

Sigh... use mysql_error() next time... you have your fields in single quotes.

Depends how common it is... read the refman page, fulltext is funny.

The display has nothing to do with the query -- does the latter work?

Sounds like this should be in the php help forum... please confirm.

Just when you thought normalizing databases had nothing to do with the real world... some (perhaps sarcastic) food for thought -- http://qntm.org/?gay -- I was going to post this in Misc, but maybe there's actually something to learn here.

Don't open a new topic for the same issue.....

Let's see... you're running a query called $ggroup1, but your query string is in $ggroup. Catching mysql_error() will help in the future.

Then you've double-posted... careful now.

I don't understand.

Missing quotes.

You need to echo some queries.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets (PDF).

This resource covers a very broad range of topics... it's worth a look, though, especially if you're stumbling in the early stages of configuration.

Basically, this blog contains a regularly-updated run-down of MySQL functions, with a short description and a few hints on how to use them; RSS feed here.

Please read the excellent FAQ thread on this issue by our very own wildteen88.