Where do u have to insert the data, to a MySQL table?, or to an array?
It can be done assuming that the tables or arrays in which you want to insert the data have a common key.

Hi, well it's fairly easy, assuming that you use MySQL, this would be done using SQL queries according to the number of tables that needs to be updated, in this particular example we're updating two tables so two queries are executed the queries should be wrapped in a single function so that they're executed as a block.

TABLE "nutrition"

SQL Syntax (Toggle Plain Text)

CREATE TABLE nutrition
(
   n_id INT NOT NULL AUTO_INCREMENT,
   nutrition VARCHAR(30), 
   PRIMARY KEY(n_id) /* Set the primary key   */
)

CREATE TABLE nutrition ( n_id int NOT NULL AUTO_INCREMENT, nutrition varchar(30), PRIMARY KEY(n_id) /* Set the primary key */ )

TABLE "category"

SQL Syntax (Toggle Plain Text)

CREATE TABLE nutrition
(
   n_id INT NOT NULL AUTO_INCREMENT,
   category VARCHAR(30),
   PRIMARY KEY(n_id) /* Set the primary key   */
)

CREATE TABLE nutrition ( n_id int NOT NULL AUTO_INCREMENT, category VARCHAR(30), PRIMARY KEY(n_id) /* Set the primary key */ )

Now the PHP function that inserts records, I also assume that the MySQL Connection has been made, to make it clearer I've omitted the MySQL connection code.

PHP Syntax (Toggle Plain Text)

<?php
   function addFood($nutrition_val,$category_val)
   {
      $q_nutrition="INSERT INTO nutrition (nutrition) VALUES ($nutrition_val)";
      $q_category="INSERT INTO category (category) VALUES ($category_val)";
 
      mysql_query($q_nutrition); /* For table Nutrition */
      mysql_query($q_category); /* For table category*/
   }
?>

<?php function addFood($nutrition_val,$category_val) { $q_nutrition="INSERT INTO nutrition (nutrition) VALUES ($nutrition_val)"; $q_category="INSERT INTO category (category) VALUES ($category_val)"; mysql_query($q_nutrition); /* For table Nutrition */ mysql_query($q_category); /* For table category*/ } ?>

Hope it helps.

Regards, Triztian

hi stanley87
there is way in php to get the primary key of the insert/update done look example
mysql_query("insert into table1 values .........");
$myquery = "SELECT LAST_INSERT_ID() as new_id";
$myres = mysql_query($myquery);
$myrow = mysql_fetch_array($myres);
//// now $myrow[0] contain the primary key of the last insert done
//// now you can use this var in another statement

mysql_query("insert into table2(x) values ($myrow[0])");


thanks