fenway

DISTINCT is *NOT* a function.

There are plenty of excellent tutorials on this site, and in this board's stickies. As for the "daily" part, use a cron job.

I'm so very confused... how can your group by be getting any people with no votes? There wouldn't be any records in the table???

Wait, so now there is no error?

Yes, of course, because aliasing is done at the last step.

Sorry, joining in late here... where do things stand?

That's nice... please post the revised query.

Next time, please share your solution -- in this case, you where using a reserved keyword, so backticks was the answer.

You can use IF() or IFNULL() as appropraite.

So is this "solved"?

That's not what NULL is for.

AGAIN, that's because you're not retrieving the value from the recordset correctly -- see my earlier post.

Perhaps some error output would help?

You'll need to combine the results either before or after.

The only other option is a stored procedure.

LOAD INFILE can handle optinally enclosed fields... did you try this?

I'm not sure what you mean.

Not expensive with a proper index... you don't need distinct, group by will take care of that. And note that not using '*' in the count() treats NULLs different.

That's in fact the only legible way to do it.

Unless you index silly columns, particular ENUMs with poor distribution.

Hope this will be marked solved, or it's in danger of being moved to the more appropriate PHP thread.

Unless you're actually running queries without WHERE clauses, or using indexes with poor cardinality.

You can start by using DECIMAL and not FLOAT.

That's not a mysql error.

Wait, the select doesn't work either? Post that query first... left join should allow this.