q. Getting Multipart Form to move to the next form

**Willoughby Bridge** · Jul 17 '05, 12:22 PM

Hi -

Having trouble getting a multipart series of forms to move to the next form.
The problem line is:
<form method="post" enctype="multip art/form-data" action="Data_Fo rm1.php">

If the "action" parameter is set to the current form (Data_Form1.php ) then
the data posts to the table correctly, but it does not move to the next form
If the "action" parameter is set to the next form in the series then by
clicking "submit" it moves to the next form, but the data does not post to
the table.

I appreciate any suggestions - Maybe need a separate command is needed to
make it post

TIA

David

Whole sheet is listed below and located at

http://www.teachercards.org/Data_Form.php

<html>

<body>

<?php

if ($submit) {

$conn = mysql_connect(" mysql", "TeacherCar ds", "164333") or die("Cannot
connect to server");

mysql_select_db ("Teachercards" ,$conn) or die("Cannot find database");

$sql = "INSERT INTO Teachers
(School,Email,N ame,Subject,Col lege,Motto,Stor y,Food,Color,Ho bby,Place,Anima l
,Movie,Song,Boo k,Comment)
VALUES('$School ','$Email','$Na me','$Subject', '$College','$Mo tto','$Story',' $
Food','$Color', '$Hobby','$Plac e','$Animal','$ Movie','$Song', '$Book','$Comme n
t')";

$result = mysql_query($sq l);

}

Else

{

// display form

?>

<form method="post" enctype="multip art/form-data" action="Data_Fo rm1.php">

<BODY LINK="#0000ff" VLINK="#800080" BACKGROUND="./wall.jpg">

<br>

  &nb sp; <Font Size =5/><B/>Enter information to build your
own Teacher Card: <br></Font Size =5>

<br><br>

  &nb sp; School
Name: &nbs p;  & nbsp; &nbs p;  & nbsp; &nbs p
;  &n bsp; <inpu t type="Text" name="School", size=30,
maxlength=20>

<br><br>

  &nb sp; Email
Address: & nbsp; &nbs p;  & nbsp; &nbs p;  & n
bsp; &nbsp ;<input type="Text" name="Email", size=30, maxlength=20>

<br><br>

  &nb sp; Name  (e.g. Mr. Lue): &nbs p; <input
type="Text" name="Name", size=30, maxlength=28>

<br><br>

  &nb sp; Subjec t (main subject):   <input
type="Text" name="Subject", size=30, maxlength=11>

<br><br>

  &nb sp; Colleg e
Attended:    &nb sp;     &nb sp;<input
type="Text" name="College", size=30, maxlength=16>

<br><br>

  &nb sp; Motto:   &nb sp;     &nb s
p;  & nbsp; &nbs p;  & nbsp; &nbs p;  & n
bsp; &nbsp ;  &n bsp; &nbsp ;<input type="Text"
name="Motto", size=30, maxlength=28>

<br><br>

  &nb sp; Favori te
Food: &nbs p;  & nbsp; &nbs p;  & nbsp; &nbs p
;  &n bsp;<input type="Text" name="Food", size=30, maxlength=16>

<br><br>

  &nb sp; Favori te
Color: &nb sp;     &nb sp;     &nb s
p;  < input type="Text" name="Color", size=30, maxlength=25>

<br><br>

  &nb sp; Favori te
Hobby: &nb sp;     &nb sp;     &nb s
p;<input type="Text" name="Hobby", size=30, maxlength=15>

<br><br>

  &nb sp; Favori te
Place: &nb sp;     &nb sp;     &nb s
p;  < input type="Text" name="Place", size=30, maxlength=25>

<br><br>

  &nb sp; Favori te
Animal: &n bsp; &nbsp ;  &n bsp; &nbsp ;  <i n
put type="Text" name="Animal", size=30, maxlength=25>

<br><br>

  &nb sp; Favori te
Movie: &nb sp;     &nb sp;     &nb s
p;<input type="Text" name="Movie", size=30, maxlength=25>

<br><br>

  &nb sp; Favori te
Song: &nbs p;  & nbsp; &nbs p;  & nbsp; &nbs p
;  &n bsp;<input type="Text" name="Song", size=30, maxlength=25>

<br><br>

  &nb sp; Favori te
Book: &nbs p;  & nbsp; &nbs p;  & nbsp; &nbs p
;  <i nput type="Text" name="Book", size=30, maxlength=25>

<br><br>

  &nb sp; Untold
Story: &nb sp;     &nb sp; 
  &nb sp;     &nb sp;<textarea name="Story",
cols=30, rows=3,wrap=vir tual, maxlength=148></textarea>

<br><br>

  &nb sp; Commen t/Suggestion:&nbs p;  < textarea
name="Comment", cols=30, rows=3,wrap=vir tual,maxlength= 148></textarea>

</B>

<br>

  &nb sp; e.g. Can Favorite Food be replaced with Favorite
Sport which is football

<br><br>

  &nb sp;   <input type="submit" name="submit"
value="Upload Information">

</form>

<?php

}

// end if

?>

</body>

</html>