PHP mysql survey

[arty]

I must build a survey with many question (around 50), so i cannot have the survey in just one page, i would like to have it on many pages so one user will hit submit many times, how can i make so in the database there's always one Row per user and not many rows as many submit per user?

[Atli]

Hey.

You can use the UPDATE command to do that.
Use INSERT on the first page and just UPDATE the row on the proceeding pages.

[arty]

hi, yes but the action attribute of the form is another form so it wont complete the MSQL command:
<form method="post" action="Q2.php">
looks like i need to use sessions so i do all the SQL command on the last form/page

[Atli]

What do you mean?

You just use a different SQL query on each page...

page1.php

<form action="page2.php" method="post">
    <input type="text" name="first_info" />
    <input type="submit" />
</form>
 

page2.php

<?php
// Get the data from the last form
$first_info = mysql_real_escape_string($_POST['first_info']);
 
// Insert a new row into the database
$sql = "INSERT INTO tbl(first_info) VALUES('{$first_info}')";
mysql_query($sql) or trigger_error(mysql_error(), U_USER_ERROR);
 
// Get the ID of the row that was just created.
$row_id = mysql_insert_id();
?>
<form action="page3.php" method="post">
    <input type="hidden" name="row_id" value="<?php echo $row_id; ?>" />
    <input type="text" name="second_info" />
    <input type="submit" />
</form>
 

page3.php

<?php
// Get the data from the last form
$second_info = mysql_real_escape_string($_POST['second_info']);
$row_id = mysql_real_escape_string($_POST['row_id'])
 
// Update the row in the database with the new info
$sql = "UPDATE tbl 
        SET second_info='{$second_info}' 
        WHERE row_id={$row_id}
        LIMIT 1";
mysql_query($sql) or trigger_error(mysql_error(), U_USER_ERROR);
?>
<form action="page4.php" method="post">
    <input type="hidden" name="row_id" value="<?php echo $row_id; ?>" />
    <input type="text" name="third_info" />
    <input type="submit" />
</form>
 

etc...

[arty]

thanks , i have just made something with session,i will check your version.
thanks again.