Posted by David Gillen on 06/02/06 15:46
An noise sounding like monomaniac21 said:
> Hi all
>
> Using MySQL can anyone tell me how to most efficiently insert a collumn
> in 'table1' retrieve the id from this record and insert mutliple
> records into 'table2' with a collumn for the id in 'table1' which links
> the two recordsets
>
$id = mysql_insert_id();
From the manual: Retrieves the ID generated for an AUTO_INCREMENT column by
the previous INSERT query.
D.
--
/(bb|[^b]{2})/
Trees with square roots don't have very natural logs.
What's the difference between ignorance and apathy? Who knows? Who cares?
Navigation:
[Reply to this message]
|