Holes in mysql primary key and other db issues...

Hi, I'm currently on a server using mysql 4.x and I'm having a few small issues that I can't seem to find a decent solution to. I would appreciate any help. First, I have an ID field as my primary key, but whenever I delete a row, that ID is not filled. This is a major problem for random calls, organization, etc. I don't understand what the point of all that extra indexing memory is for if it doesn't keep track of itself. Second, in part of my code, I build an array of ID values and would like to call them all from the mysql at once, instead of a foreach(~~) {database call here} loop. Any ideas? Lastly, I'd like to be able to call data from different (not joined) tables in a database. Aside from not being able to find info to do it, I'm wondering if any such solution would be worth it. What do you think? Thanks! -- Mike Shanley ~you are almost there~