fenway

Um, no. Specify "INT", and then UNSIGNED somewhere.

Well, there's always Lucene... but I too have a custom weighted search, so FULLTEXT was never the right match.

Huh?

Great question... and no, mysql won't do this for you. There are a variety of ways to handle this -- it really depends how general a solution you want to implement.

Sounds like you should first figure out how many lyrics per album, and then limit your query accordingly.

Perhaps... I've not really used FULLTEXT much in production.

So start with MAC and left join the other two.

I don't think it's the fulltext that's slow -- that's only returning a singlle record from that table, no?

Then this is the wrong forum..... moving to php.

use a LEFT JOIN.

DISTINCT is not a function -- it will only removes duplicates across the entire column list, not just the first field.

I assume you mean you have a FULLTEXT across multiple columns....

That's backwards... you need to select from the related_products table and then join products in twice.

Why does everyone want to do this? This is NOT a counter. This is a unique row identifier -- never to be re-used. Oh, and you'll kick yourself later for using SMALLINT -- use UNSIGNED INT instead.

in_array() is painfully slow, from what I've read. It would be easier to get all of the PINs (no need to sort), put them in a hash, and then run a while loop using rand() until there's no hash collision.

There's a PERIOD function.

Your sample output is confusing... i see matching records for everything.

Well, REPLACE will still work...

Yes, but each script is effectively a "session".

Why select everything then merge it with a subset????

Why do you have an UPDATE statement inside your INSERT?

Then you would know to turn on error reporting....

You're unfamiliar with sprintf(), but you're using it in your code? Now really.... BTW $forumQ had better be the query string, not the result set. $forumQ="SELECT topic_id, topic_title, topic_replies, topic_views, topic_last_post_id FROM phpbb_topics ORDER BY %s DESC LIMIT 20"; $array1Q = sprintf( $forumQ, 'topic_title' ); And then you can simply run this query.

Well, then you'll just have to wait & see.

You're not reading what I wrote -- a multi-column index. Yes, but you won't have 100 all of the time, and then you can keep track of when this happens.