fenway

Why not simply: $double = mysql_query("SELECT question, COUNT(id) AS cnt FROM question GROUP BY question HAVING cnt > 1");

You need to find the oldest one FIRST, and join back to your table SECOND.

Should be... it's simply a modifier to SELECT.

Well, what do you have now?

We frown upon posting entire scripts... that's never the answer. And if it's php-related, then it doesn't belong on this board.

Yup... just make sure you use UNSIGNED INT.

I thought we fixed this bug... maybe it was lost during an upgrade.

There's a board that discusses flat file

Don't rely on the ID - not necessarily the most "recent' if anything's been updated.

Actually, there are missing opening/closing backticks -- not that they should be there to begin with.

Stop using persistent connections.

Why are you quoting the filenames?

Then you *do* have a primary key.... post the SHOW CREATE TABLE.

Then push an array and join it at the end.. and PLEASE don't omit the column names.

FULLTEXT is funny,... doesn't always match/return what you'd expect.

Why would it only display the first one?

Or a LEFT JOIN ... IS NULL, so as not to kill performance.

You need to join those tables...

I think I made a comment to this effect earlier... can you post the "working" query and then I'll modify it accordingly?

Except that F.* with a group by will produce meaningless garbage... so it's not "solved", it just looks like it's working.

And by "code" i hope there's an mysql query in there somewhere -- otherwise I'm moving this to a more appropriate board.

Well, not exactly, but you can "cheat" by using REPLACE() to replace "hey" with a single character, and then count the difference in lengths, knowing the length of your target string. It's ugly, but it works like a charm. I've used this before to count spaces or commas.

Well, don't update the PK.

Why not simply run the statement in the loop, instead of concat-ing?

Yup.