fenway

You can simply count(*) or use the f table fields...

You need to add this to your column list, not JOIN it in.

Unlikely... besides, it's one per friend, not one per point.

<SHUDDER> Use "- INTERVAL 20 MINUTE"... don't use PHP for date math. </SHUDDER>

What format is $today?

DATE_FORMAT() is your friend.

This is a double-post....topic locked.

I wish I did... but I don't know anything about php functions. However, I'm sure I've seen the problem addressed before, you might want to search this forum.

I see inserts with missing values.....

What's "both"? Why not just drop the where clause?

Add ( SELECT sum( dist * 0.485 ) AS mileagefee FROM `mileage` WHERE id = <the outer table id> and work_id = <the outer table work id ) ) AS mileageSum To the first query.

That's because COUNT() doesn't count nulls... and the p table can be nullified by the left join...

I'm not sure what you're trying to do.. way too much code, not enough explanation.

Maybe... but the above won't work.

I don't see how that's possible... missing quotes?

What queries are you using?

Life's been busy... I'll try and do this tonight.

Don't do this... now you see why ti's bad.

Add another table, called downloads... store the user id, the file id, and the date/time. Don't store delmited values in the database! You may want to read up on DB normalization, see the board stickies.

You're running PHP on an intranet?

The only annoyance is not posting said solution.

You mean like this?

In case anyone's wondering, it was the trailing comma....

There are a bunch of stickes that cover intro topics like joins.

Sounds like you need to join the table... though your syntax with AND is incorrect.