Stut wrote:
I'm not sure what you mean by "extra indexing memory". The autonumber
feature is simple in that MySQL just keeps track of the last ID used
and increments it to get the next one. However, I don't think there is
any overhead caused by deleted records. If you can cite a source for
that statement then I'd be interested to hear about it.
I mean the extra space used up to set /any/ row as a key, not overhead
for deleting. But you're right that the auto-increment is separate from
indexing. Even still, I need a simple way to fill those holes.
select * from tablename where id in (1,2,3,4,5,6,7)
So essentially, you're telling me not to store the ID numbers I want to
call in an array then, eh?
If you can't join the tables together then they're not related, so
you'll need to do separate DB calls. I'm not sure where the problem is
here.
I'm just wondering if there's a way to combine calls to 5 different
tables down to 1 query, as though all the info needs to be organized
separately, it's going to the same place.
--
Mike Shanley
~you are almost there~
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
