fenway

Yup, it's a JOIn.

Assuming your DB design is reasonable, 28 is nowhere near a problem.

Always use an auto-increment, especially if not innodb.

That sounds like an entire script that you're asking for.

I don't think you understood the OP's question.

There are hundreds of posts on this forum explaining how to sort this out -- why not search for some of them? And a sticky, too.

What version?

I have no idea what you're talking about.

I thought it was obvious.... you need to join on both the employee and the most recent date to make sure you're just getting a single record per employee.

This is a common question. First, write a query to get the most recent for each employee -- then, join this derived table back to the original table, and voila.

Yes, but you should probably use the administrative commands to do this, since playing with the mysql internal database it just a bad idea.

No, you need to alias your columns.

The schema is the actual database -- the ERD is just a diagram indicating abstract concepts.

Next time, read the rules about posting questions on this forum.

You mean UPDATE a record...

What error?

Why?

What working queries to do you have so far/

Something's unstable.

True, as long as you're careful... unexpected variable interpolation has caused many a bug.

Sound like you need LAST_INSERT_ID() -- there's a php function for this in mysqli, I believe.

Has nothing to do with ON DELETE / ON UPDATE, especially for an INSERT. It just means that you don't have a matching id in the other references table. And when I ask for a query, I don't mean php code.

You didn't do as I said. you're still using multi-query. So don't.

No, not a multi-query -- once per page.

That's a bad idea -- but feel free to ignore me, it's your product, not mine.