Re: Nested foreach ?

Stuart Felenstein wrote:

John, Sorry, I'm not trying to be unclear. There are 3 columns in the table. In the user form. there are 30 fields, 10 text and 20 dropdown. The 10 text are: $_SESSION['skills'] = $_POST['skill']; The first dropdown is : $_SESSION['skys'] = $_POST['sky']; The second dropdown is: $_SESSION['slus'] = $_POST['slu']; So I need to grab the input and enter into database where each set of skill, sky , slu is a new record. I hope this is clearer.

Did you read the answer I gave?

foreach($skills as $key => $skill) { echo "$skill - {$skys[$key]} - {$slus[$key]}\n"; }

Now adapt that to your session variables and query: foreach($_SESSION['skills'] as $key => $skill) { $query = "INSERT INTO table (skill, sky, sku) VALUES ('$skill', {$_SESSION['skys'][$key]},{$_SESSION['slus'][$key]})"; //run query } or, if you can use extended inserts: $insert = array(); foreach($_SESSION['skills'] as $key => $skill) { $insert[] = "('$skill',{$_SESSION['skys'][$key]},{$_SESSION['skus'][$key]})"; } $query = 'INSERT INTO table (skill,sky,sku) VALUES ' . implode(',',$insert); //run query -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com