[SOLVED] dynamic SQL statement

[dennismonsewicz]

Is there a way to create a SQL statement that will insert into a database and the next SQL entry will grab the rowid of the first statement entered?

[gevans]

$query = "INSERT INTO `table` (`field`) VALUE ('something')";
$result = mysql_query($query) or die(mysql_error());
$insertid = mysql_insert_id();

[timmah1]

mysql_insert_id()

[timmah1]

oops, sorry gevans

[dennismonsewicz]

hmm thanks for the help...

 

i am writing a SQL file can you use this in the file?

 

like:

 

INSERT INTO `table` (`field1`) VALUE ('something');

INSERT INTO `table` (`field1`) VALUE ('something') WHERE mysql_insert_id();

[gevans]

You don't need a WHERE clause in an INSERT statement

[dennismonsewicz]

so my SQL could look like this

 

INSERT INTO `table` (`field1`) VALUE ('something', 'somethingelse');

INSERT INTO `table` (`field1`) VALUE ('something', mysql_insert_id);

[gevans]

mysql_insert_id is php, so its easier to write this in php

 

$query = "INSERT INTO `table` (`field1`) VALUE ('something', 'somethingelse')";
$result = mysql_query($query) or die(mysql_error());
$returnid = mysql_insert_id();
$query = "INSERT INTO `table` (`field1`, `field2`) VALUE ('something', '$returnid')";
$result = mysql_query($query) or die(mysql_error());

[dennismonsewicz]

ah gotcha... i am writing a Joomla (BOOOO) component and to install the file you have to write a sql file to install of the content and menu structure and its a pain in the butt. And the Joomla Forums suck! You can never get any help!

 

Thanks for your help here man!

[gevans]

no worries, hit resolved