fenway

OMG... can you actually understand any of your own code? No offense, but that's brutal.

You almost never want DISTINCT... it's just lazy, and 99.999% of the time it's completely wrong, and returned seemingly correct results by accident. I also ever use it in "UNION DISTINCT", where it actually makes sense.

Well, I assume your got this calendar from somewhere... they obviously have docs for login config.

So, what was it?

I already gave you the answer... you need to get the names of the columns first.

You can't use column aliases *during* a query... SELECT CC.num1 AS mytotal1, CD.num2 AS mytotal2, c.id, c.name, (mytotal1-mytotal2) AS difference needs to be SELECT CC.num1 AS mytotal1, CD.num2 AS mytotal2, c.id, c.name, (CC.num1-CD.num2) AS difference

Yes, OR is slow.. maybe index_merge will help.

Then use DATE_FORMAT(). And CURDATE()+1 is pure evil, use CURDATE()+INTERVAL 1 DAY.

This seems awfully similar to your other topic... what's different here

A derived table would work too.

I assumed your already tried a blank password....

Why not SELECT topic_id, ( 6 - poll_option_id ) AS score, poll_option_total AS num_votes FROM phpbb_poll_options

Mysql doesn't support capturing parens like php. I suppose you could be sneaky like this: UPDATE _testing set id = IF( LOCATE( REVERSE(', THE'), REVERSE(yourField) ) = 1 ,CONCAT( 'THE ', REVERSE( SUBSTRING( REVERSE(yourField), LOCATE( REVERSE(', THE'), REVERSE(yourField) )+length(', THE') ) ) ) ,yourField )

First you need to get "each" employee -- then you can find the last row.

Actually, I think you mean: SELECT o.offerid , o.name, o.incent, o.type, o.reporting, o.category , IFNULL( e.pay_value, o.pay_value ) AS payValue FROM offers as o JOIN exceptions as e USING (pay_value,offerid) WHERE o.status = 'On' ORDER BY payValue $orderx LIMIT $from, $max_results

Then replace "DELETE FROM" with "SELECT *", or something equivalent.

I prefer: SELECT e_ticketbuyer.* , events.title, events.date, events.city, events.country FROM e_ticketbuyer INNER JOIN events USING ( e_id ) About the "differ" question, the e_id values are the same, by definition, so I'm not sure I understand. The table prefixes do not make it into the field names.

What does "CHECK TABLES" say?

That's why it's not working -- redirection on the command-line will not deal with UTF8 properly; use the -r filename option instead.

The link I posted earlier has all of the details.

Do your echo statements produce the expected tuples in the outptu?

So you don't want the actual results of the search?

There are fields in your example output that don't show up from your query. First hint -- drop DISTINCT.

Please share the details of your solution before marking it "solved".

Well, it has to be somehwere.