DBI indexing question

[Greenhalgh David]

Hi all,

I just came across this list's archives getting the answer to a 
problem. Now I have my own questions to ask!

This is more of a MySQL question than a cgi one, with luck someone will 
know the answer. I am managing a database from a set of cgi's, each 
entry in the database has an ID defined as TINY INT AUTO_INCREMENT. 
Now, from time to time entries will be deleted. My question is this, 
say my list has 10 entries and I delete number 5. Are there any 
circumstances in which that vacant ID "5" will be re-used, or will the 
ID continue to count up to 255 and then generate errors?

Second question. If I use the following:

my $query="CURDATE()";
my $sth->prepare($query);
$sth->execute;
I understand that $sth now just contains the reference to the result of 
the query. Where is the value of the query (which should be today's 
date.) It doesn't seem to be in $_.

Thanks people!

Dave

--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]