fenway

Of course you can run multiple statements.

Try here.

Sounds like you want to group by some arbitrary time period....

How about table structure and some queries?

I don't follow.

Or double-post. Topic locked.

You're talking about php syntax errors, not mysql problems.

Wait.. what doesn't work?

MySQL has plenty of data types -- use the right ones.

What's a "user field"?

So? Use * or specify the fields you want... what doesn't work?

If you're talking about php syntax, this is the wrong place.

Yikes... you're missing a ON condition for your JOIN.

I only see a single statement, so I don't see where you're getting back anything from a second table.

You mean with MIN() and mAX()?

Show us the actual query, and tell us what doesn't work.

I don't follow -- you're asking why you're getting duplicate exhibitionname fields/

Conditions can't be set up as anything -- it's your table that needs to support many-to-many

And next time, don't post entire scripts unless you're asked to.

Of course, %term% covers all 4 cases.

First problem -- that's not a valid mysql date format -- use STR_TO_DATE().

If you'd like to rank partial substring matches by distances from string position 0, that's not hard to do in application code.

If it's encrypted, you'll need to decrypt it to get it back -- how you choose to encrypt is entirely up to you.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.