can 2 form fields have same name and send data to same db field?

jarow

I need to create 3 separate text fields, the contents of which all need to be sent to one field in my mysql database...any ideas on how I may accomplish this in dreamweaver mx? and how I get the mysql database to accept three values?

Many thanks

Jim

feldon23

Be aware that Dreamweaver tends to "hose" PHP scripts, adding spaces and other nonsense that renders them unrunnable.

You should do 3 or however many separate form fields to keep things simple and then concatenate the information in your submittal script to shove it into the MySQL dbase.

Just a reminder that you can do the entire form including the submittal and the "thank you" note on a single PHP script!

<?php
$php_self=$_SERVER['PHP_SELF'];
$submit=$_POST['submit'];
.
.
.
if (!isset($submit)) {
?>

<form method=post action=<?php echo $php_self; ?>>
<!-- display form normally with HTML etc. -->
.
.
</form>

<?php
} else {

// php script to process the results of the form and stuff the results into MySQL.

echo "Your script has been successfully sent! Thanks.<br>\n";
echo "Click <a href=\"".$php_self."\">here</a> to return back to the empty form.";
}
?>

james2871

I'm actually not sure if this applies to Dreamweaver, but with PHP, you can append the value of multiple variables to one variable. Name your field names with different names, then append them into one variable after you post the form:

$field1
$field2
$field3

--Names of your input fields

$variable

--variable to append data to

$variable = $field1.$field2.$field3;

if you need to have spaces between the field variables:

$variable = $field1." ".$field2." ".$field3;

hope this helps

Jim_Madrid

thanks...that did it!