fenway

Then you'll need to order this in script with a regex to extract the pieces.

You need to write a query, separately that return the max value for a given value, and then you can easily join that in, and then easily use 1000 or the other value.

Then your PHP headers aren't correct.

You can UNION the table if you use NULLs wherever the gaps are.

Your full-text index must match your MATCH..AGAINST exactly.

Sorry, I don't follow.

Why not order the results in mysql?

You'll need to convert those strings into accent-free values when you search -- mysql only provides case-insenstivity.

Either 51 or 50? What does that mean?

Why not filter on date?

You'll have to do this mostly in php -- first select the tickers, then go back and craft a fancy sql statement.

Use code tags next time.

And why didn't HAVING work?

This topic has been moved to PHP Freelancing. http://www.phpfreaks.com/forums/index.php?topic=328526.0

Then please post the solution.

I'm trying to understand why you can't simply use a derived table, get the max for each possible item, and then restrict by your desired date range.

I'm sorry -- do you want one row or two?

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=328388.0

Show us the table definitions.... quotes shouldn't matter.

Update_time isn't robust -- doesn't work on all platforms.

I prefer the simpler "yourField + INTERVAL N DAY".

I don't see a mysql question here -- next time, use code tags.

If you want to pay, donate to the forums.

Just be careful, it works differently based on where it appears in the statement.

Yeah, but you can't use *.