fenway

The mysql refman has all of the syntax for MATCH... AGAINST()... but it should just be quoted.

You need an index on schedule_room.scheduleid, and on studentrecord_daily.student_id, at the very least. And of course, fix the column types.

I'm getting to this rather late -- but why can't you simply enumerate the rows and use HAVING to pull out the ones mod 120? Yes, the "end" is a boundary case, but it's easy to find the "last" one.

In fact, don't use any fancy editor at all -- it's just text.

Don't start a new thread for questions on the same query.

What did you expect? You have a FULLTEXT index on multiple columns. You're asking MySQL to decide which words matter. Of course, you could have searched the "phrase".

Or, if you don't want to have annoying problems later, save each "side" of the score as a separate row, and tie them together with game ID, and flag as "home" or "away".

Also, I want an ON clause for each and every table being JOIN'ed.

If your hosting provider won't tell you how to connect to your database, get a new host.

It's a really bad idea to mix commas and JOINs.

Sorry, I don't follow.

Perhaps with a COUNT DISTINCT.

Why do you want to combine them?

Yeah, that's not what a database engine is for.

If you include this expression in your SELECT column list, you'll see why.

Actually, that's what an INNER JOIN would do.

ORDER BY FIELD(sort, sort) ASC. Bizarre casting.

This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=352056.0

Then you get to decide...

I don't believe it should be in the php section. I believe that you should post SQL statements, not PHP that produces mysql statements, with variables that need to be interpolated. For all we know, your $query could have started with a dollar sign.

You just need to have your unique key span both columns.

The only problem was that, still, you have NOT posted a single mysql statement.

There's a sticky that covers all of the rules.

Amazing that you posted a mysql question with so much as a mysql query.

You need to alias after END, not before.