quick mysql question

pld

i am not sure if this is an appropriate place for this, so i am sorry if this is ot,

i am basically trying to insert a row into a mysql db, but i want one value from the row to be equal to whatever is being set in another value from the same input.

or, i have an auto-incremented value (a primary id) in my entry, but i want the same value generated to be input to another place in the same entry.

INSERT INTO mydb (primaryID, another_value_equal_to_primaryID) NULL, ????

anyone know a way to do this?

TIA

pld

bump

abman

why not try to create 2 tables and just do

$sql ="INSERT INTO mydb VALUES($yourvariables)";
$result = mysql_query($sql,$db);

// then insert again but in your other table using same variables.

$sql ="INSERT INTO mydb2 VALUES($yourvariables)";
$result = mysql_query($sql,$db);

that way both tables will be auto incrementing with the same value at the same time.

GreyBoy

Im not sure if this will work, but bare with me. You will need one table with id auto_increment(table1) and one table with just id(table2).

First enter the values into table1:

$sql = 'INSERT INTO table1 VALUES(......)';
$result = mysql_query($sql,$db);

Then, get the the results of the ids from the table1, put them into an array, and do individual queries:

$sql = "SELECT * FROM table1";
$result = mysql_query($sql,$db);

while($row = mysql_fetch_array($result))
{
      $id = $row['id'];
      $content = $row['content'];
      //ect...
     $sql = 'INSERT INTO table2 VALUES ('$id', '$conetent')";
     $results = mysql_query($sql,$db);
}

Like I said, Im not sure if that will work. The way abman said it is probably easier and more efficient, if you had a large num of rows to add, you would be running a whole lot of queries.

abman

there is no need for you to select table1 at all.... just insert the same variables in table2 as you would with table1, it's alot less hassle, selecting table1 again is jus making it harder for you and wasteing codeing.

rcmehta_14

Why don't you use one insert and one update to do the above mentioned task. This way you will not need two different tables.

I assume that the other_field_value is declared not null. OR if declared should be made zero once.

$query = "INSERT INTO table1(other_value) VALUES(0)";
mysql_query($query);
$currid = mysql_insert_id();

and then
$query = "UPDATE table1 SET other_value = $currid WHERE primary_key_value = $currid";

It should work.

pld

I actually ended up doing the same thing rcmehta suggested, but i really appreciate all the responses. the update directly after the insert was perfect. i guess i was just hoping there might be a way to pull it off without querying the database a second time.

thanks for all the suggestions!