[puppy]

hi,
i am having trouble inserting from a form to multiple mysql tables, i know it can be done with asp but my dev environment is:

php 4.3.4
mysql 4.13nt
dreamweaver mx

i am new to php, have been cramming but i'm only half way through the book and my brain is fried !

any suggestions would be greatly appreciated.

rob

[NeverMind]

this can be achived with loops or with normal method ..
if you want to insert the exact data in more than one table then a loop is good for that ..
example:

PHP Code:

//I will assume that the form is sending username, comments and email ..

//and they are being posted via POST method..

$user = trim(addslahes($_POST['username']));

$email = trim($_POST['email']);

$comment = trim(addslashes($_POST['comment']));



//add as many as you want of tables to this array

$tables[] = 'Table_1';

$tables[] = 'Table_2';

$tables[] = 'Table_3';

//if you want to add more just type:

//$tables[] = 'TABLE_NAME';



//ESTABLISH CONNECTION HERE..



//we start the loop here 

for ($i=0; $i<count($tables); $i++) {

   $insert = mysql_query("INSERT INTO $tables[$i] (name, email, comment) VALUES ('$username', '$email', '$comment')")or

  die(mysql_error());

} 

note that this method can be only used if tables are identicales in structure

but if you want to insert e.g. $username to a table and $comment to another table then use the regular method

PHP Code:

$user = trim(addslahes($_POST['username']));

$email = trim($_POST['email']);

$comment = trim(addslashes($_POST['comment']));



//here we insert username and comment only..

$insert = mysql_query("INSERT INTO table_1 (name, comment) VALUES ('$username', '$comment')")or

die(mysql_error());



//here we insert username and email

$insert = mysql_query("INSERT INTO table_2 (name, email) VALUES ('$username', '$email')")or

die(mysql_error());



//and so on .. 

hope that helps

[puppy]

thanks, your time is much appreciated,

i'm going to need a couple of days to digest & "attempt deployment" oddly enough, it was loops that i had got to in the book when my brain "hung".

whilst the syntax seems logical, i'm not seeing the whole picture. It is hard to place all these concepts in a real practical context.

thanks again

yours "newbie" ly

rob

[puppy]

$user = trim(addslahes($_POST['username']));

so, in the above variable the $user is variable name, the ['username'] is the variable value, what if i'm using an array of values, how would you construct for that ?

would you concatenate ?

$game = trim(addslashes($_POST['pacman', 'defender','space invaders']));

rob

[puppy]

..........cont

and what if in the case of a normalised database such as:

users (user_id, address & so on)
game table (game_id, game) (1, pacman, 2, defender, 3 space invaders)
user_rel_game (user_id, game_id)

i would want to enter values 1, 2 or 3 via the variable directly in to the user_rel_game table, how would i specifically script that ?

hope thats not asking too much, beginning to understand this now.

your help is much appreciated.

rob