fenway

Well, you're trying to make the same view over and over again.

Have you consulted the refman page on fulltext indexing?

I don't know how many times you've posted the exact same question. LOCKED.

Show exactly the command you're using.

Show a table structure.

It is so very much NOT an alternative -- they mean completely different things unless there's only a single field.

Seriously? You just posted about 20K of code. Please identify the 15-line code snippet that's not working.

Sounds like you need a jon.

Yeah, I see that now... obviously, you can tell that csc.header can only be one value at a time! You'll need to join in the header table once per header row entry value with the name in the on clause -- let me know if I've lost you.

That's a php issue, now, isn't it?

Just use a DATETIME field.

And before/after each query would be waste of time.

Sounds lke you're looking for an exact match...?

You can't... one insert req'd per table.

Don't mark a thread "solved" without posting the solution.

Read the sticky on hierarchical data -- it's not trivial to recurse it the way you've stored it.

It's like no one's ever heard of code tags.... yeesh.

Looks fine, but echo the query.

Until replication becomes a factor.

Then use the last query and switch 7 to 60.

Yikes... why do you have 5 left joins for the same base query?

Not sure if you can use env vars from linux like that... did you try using --tmpdir? But 127 is still record-table is crashed. Bah! Did you say earlier that you could run some select statements at some point?

Try: select o.offerid , o.name, o.incent, o.type, o.reporting, o.category , IFNULL( e.pay_value, o.pay_value ) AS pay_value from offers as o left join exceptions as e using (pay_value,offerid) where o.status = 'On' order by o.pay_value $orderx LIMIT $from, $max_results

What not try the simple case to prove it? Use a basic string on both server.

Strictly speaking, whenever you CONCAT, I would probably recommend CONCAT_WS(), and use a separator that is unlikely to appear in your data. Otherwise, if you have teams like: team1 = me team2 = another and team1 = mean team2 = other then CONCAT() with return the same string for both! Case insensitivity can also wreak havoc. I would recommend: SELECT team1, team2, COUNT(*) AS count FROM matchups GROUP BY CONCAT_WS( '~',team1,team2) Just to be safe. You'll get burned eventually.