[thelist] SELECTing and auto_increment field

[Andrew Forsberg]

Hi all

There's got to be a really simple solution that I'm overlooking here. 
I'd like to know what the auto_incremented field of an insert into a 
mysql table is, but preferably without having to run a hokey select 
after the insert. At the moment I'm doing this:

INSERT INTO applications
	(
	  id
	, timestamp
	, customer_name
	...etc...
	)
VALUES
	(
	  ''
	, '" . $goofy_array[timestamp] ."'
	, '" . $goofy_array[customer_name] ."'
	...etc...
	);

and then, to get the id, I'm doing this:

SELECT id
FROM applications
WHERE timestamp = '" . $goofy_array[timestamp] . "'
AND customer_email = '" . $goofy_array[customer_email] . "';

I'm fairly confident there couldn't be a duplicate timestamp/email 
combination here, but it looks like way to round-about an approach. 
Can anyone please suggest a way to return the id with the insert 
statement (in mysql), or anything more elegant than the above?

Thanks again,
Andrew


-- 
Andrew Forsberg
---
the pander - http://thepander.co.nz/
uberNET - http://uber.net.nz/