fenway

I don't know what "other things" you are talking about .... Are you in control of all of the queries being run on the DB? If so, run EXPLAINs on the frequent ones.

I'd be surprised if someone hasn't already written out...

Then "SELECT p.*, c.city_name FROM players AS p INNER JOIN cities AS c ON ( c.City_ID = p.City_ID ) WHERE.... " will work.

It's not trivial to do substr_count() in mysql (at least without a UDF).

No, it doesn't... forget it. You can add a JOIN on the city table... could you at least post the structure of both tables?

Why not just a simple UNION?

"ignore blank entires'/

Well, you're using a prepared statement, and I'm trying to figure out what ends up in the "?"... and it's $values, the array.

You can use "ldd" to figure out where it's supposed to be... but I sounds like the install failed.

You can use TIME_FORMAT() as a MySQL function.

You should simply do the comparison on a trimmed field value -- e.g. with replace().

Nope... I want to know what's in $values when you execute the query.

Assuming it's a proper DATE field, ordering by that field will order by year/month/day, correctly. You can use DATE_FORMAT() to extract whatever format you'd like.

DB schema?

SELECT * FROM table WHERE MATCH(...) AGAINST(...) ORDER BY MATCH(...) AGAINST(...)

And $values is?

Echo it _before_ you run db_execute().

How about posting the syntax error?

Hmmm... then I suppose CONCAT_WS() will work.

I don't know what that means... you mean to say your CMS can only handle unnormalized tables?

Yup... the slow query log.

How?

You don't need the parens.

You order by the MATCH..AGAINST... simply repeat it.

How was this defined (creater vs invokier)?