fenway

You can derive tables on the fly, yes

I'm confused by your call to fetch_array() outsdie the while loop. But regardless, it sounds like you want GROUP_CONCAT().

Well, since ASCII characters are one byte each....

I don't undersatnd.

Fulltext indexing.

That's basically all a normal user would need... unelss you use replace, which requires delete too

STrictly speaking, you shouldn't have the name field in there....

And what error do you get from runnign that insert statement?

Why the correlated subquery? Why not just join in a dervied table of max update times?

Says who?

How about: SELECT e.emp_name FROM employee AS e INNER JOIN ( SELECT employee_no, COUNT(*) AS cnt FROM sales GROUP BY employee_no HAVING cnt = ( SELECT MAX(cnt) FROM ( SELECT COUNT(*) AS cnt FROM sales GROUP BY employee_no ) ) ) s ON ( s.employee_no=s.employee_no )

Don't you mean UPDATE?

Hmmm... what does the database field contains for such values with HTML entities?

And you've used "SET NAMES" in your mysql connection from php, and defined everything else correctly w.r.t encoding/

Is the database correct and the output wrong? or are both wrong?

I'm not sure I understand... you have to specify the encoding of the connection, too.

Apparently so.

You still have to deal with the year issue... hence the previous thread.

Maybe one block at a time?

What kinds of "trouble"?

Don't double-post -- I already deleted a third thread of exactly the same topic.

Does this help? You might as well use multiple queries... or subqueries if you prefer. SELECT COUNT(*) FROM .... WHERE serviceJob.dateReceived < CURDATE() - INTERVAL 10 DAY SELECT COUNT(*) FROM .... WHERE serviceJob.dateReceived BETWEEN CURDATE() - INTERVAL 10 DAY AND CURDATE() - INTERVAL 7 DAY SELECT COUNT(*) FROM .... WHERE serviceJob.dateReceived >= CURDATE() - INTERVAL 7 DAY

There is an EXISTS query, too.

Still not helpful... format that query nicely, please.... like on multiple lines.

Shouldn't you be using: DELIMITER || CREATE FUNCTION calculaMedia (m1 FLOAT(2,6),m2 FLOAT(2,6)) RETURNS FLOAT(2,6) BEGIN DECLARE media FLOAT(2,6); SET media = (m1+m2)/2; RETURN media; END; || DELIMITER ;