Help,

I have a data input form which collects information from users, and then
transmits to a page for user to view. How do I pass the input date into
the table. Have tried the following:

input.php3
   <form name='frmAttyApp' method=post action="app.php3">

        Please enter your last name (<i>required</i>):
        <input name="last_name" type="text">
        <br>
</form>

This then displays to user through app.php3:
<?php
echo (
 "<b>Thank You for submitting the following:</b><br>Please double check
your answers.<br>Please click back and fix any errors prior to
submitting." . NL . NL . // new line constant.
 "Last Name: $last_name" . NL
)

<form  method=post action="attydb.phtml">
<?php
"$last_name,
</form>

This then hits the attdb.phtml and phtml does connect to the database as
follows:
--attydb.phtml--

<?php
       mysql_connect(localhost, test);
           @mysql_select_db(trial) or die("Unable to select database");
                $query="INSERT INTO table values('$last_name)";
  $result=mysql_query($query);
            mysql_close();

?>

>From my logs, I am connecting fine to the database. But the information
in the last_name is not being passed to the database. The app.php3
displays only as follows when brought into the browser:

Last Name: Bragg<br>

How do I retain the $last_name information so it passes to the database
and at the same time displays in the browser so user can be sure entry
is correct? Or, how do i pass the input to the database in the first
place?

Thanx




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to