fenway

I disagree -- the DOM reference has already been looked up for you in the form's element collection! Why look it up again? That's slower.

This is really a php question (i.e. the layout and the parsing, and what you're searching)...

Why not have a full-text index across all these columns?

Go in stages: 3.23 - > 4.1 -> 5.0. Remember to read up on the incompatible changes between versions, and backup your data (dump and files).

That's not valid syntax... what's CHECK? And what's the PK?

Add them whre? when?

UPDATE yourTableName SET expire = NULL WHERE expire = '0000-00-00'

SELECT SUM(`count`) FROM totalrequest But I wouldn't use function names for column names.

There is a way, but I'm not going to tell you how, because you can always format the output with LPAD().

You mean a SUM() function?

Blank? How do you know, you're not getting it back?

Yes, you don't need the individual indexes if you already included them as the first key for a multi-column index -- which you have.

Well, they're two totally different queries... why run them together?

You asked for *, it's going to give you everything...?

ORDER BY RAND LIMIT 1... but read the sticky first.

Well, let's try the join you have first... why all the group by columns, isn't ID enough?

I'm not sure you really want a three-table join here....

Well, there are certainly ways you can't using it... since the name of the expression is only generated *after* the query is run, you can using it order by / having statements. If you want to use it, you can either (a) use the underlying expression (not the named version), or (b) join it.

There was a recent post on planet mysql about memcached integration with mysql....

That's because you're using distinct instead of group by... but aren't all the other columns going to be different? Why do you have dupes?

Please post your solution... I assume you used `date` > CURDATE() - INTERVAL 40 DAY?

Not really... if you aggregate the group of five, you can't then ask mysql to un-aggregate them.

You can do this from the CLI or from phpMyAdmin... post your current table structure.

SQLylog, Navicat....

What makes you think you can't use it directly?