Incrementing a number

[phprooky]

Hello everybody,
I have a code where I have 2 inserts and a select before the 2 inserts to bring the higher number from my first table and then increment that number to be inserted in both tables. The field where I insert that number is called id_tour, but the select always brings a number 3, so is not working. Can you please help me with this?
This is the code I have:

// connect to the db 
$con = mysql_connect ('host', 'username', 'password');
if (!$con)
  { 
  die ('Could not connect: ' .mysql_error()); 
  }
mysql_select_db('myDB', $con);

// HERE IS WHERE I BRING THE VALUE OF THE FIELD id_tour TO HAVE IT INCREMENTED
$sql1 = "SELECT id_tour  FROM table";
$contador = mysql_query($sql1)+1;
// HERE IS WHERE I BRING THE VALUE OF THE FIELD id_tour TO HAVE IT INCREMENTED
$descrip_tour = $_POST['descrip_tour'];
$fecha = $_POST['fecha'];
$guia = $_POST['guia'];
if (($descrip_tour !='') && (fecha != '') && ($guia != '')) {
  $sql2 = "INSERT INTO table (id_tour, descrip_tour, fecha, guia) VALUES ( 
    '$contador', '$descrip_tour', '$fecha', '$guia')"; 
  $result = mysql_query($sql2);
  }


foreach($_POST['records'] as $record) {
$prueba = $contador;
$language = $record['language'];
$room = $record['room'];
$name = $record['name'];
$voucher = $record['voucher'];
if (($language != '') && ($room !='') && (name != '') && ($voucher != '')) {
  $sql = "INSERT INTO table (id_tour, language, room, name, voucher) VALUES ( '$prueba', '$language', '$room', '$name', '$voucher')"; 
  $result = mysql_query($sql);
  }
  echo "1 record added";
} 
//EndForEach segment
//echo "1 record added";

[laserlight]

It would be easier to have id_tour in the first table auto-incremented, and then after you do an insertion into the first table, just use the appropriate function ([man]mysql_insert_id/man, in this case) to insert the same value into the second table.

[phprooky]

Hi laserlight,
Where should I add that function? I have never use that function, can you please help me to fix my code?

[phprooky]

Hi again,
This what I did, but is inserting the id only in the first line of my second table. What can I do, can you help me please?

foreach($_POST['records'] as $record) {
$prueba = mysql_insert_id();
$language = $record['language'];
$room = $record['room'];
$name = $record['name'];
$voucher = $record['voucher'];
if (($language != '') && ($room !='') && (name != '') && ($voucher != '')) {
  $sql = "INSERT INTO prueba (id, language, room, name, voucher) VALUES ( '$prueba', '$language', '$room', '$name', '$voucher')"; 
  $result = mysql_query($sql);
  }
  echo "1 record added";
}

[phprooky]

Hi again laserlight,
I already have the solution. I added a $_session to store the value of the id after the first insert so I can used every time I need it and is working pretty well.
Thanks for your help, but if you have a better solution, please send it to me as soon as you can.