$fields='';
$values='';
foreach ($_POST as $field -> $value) {
$fields .= $field.", ";
$values .=$value.", ";
}
$fields = substr ($fields, -2); // strip off last comma and space
$values = substr ($values , -2); // strip off last comma and space
$query = "INSERT INTO $_GET[table_name] (".$fields.") Values (".$values.")";
"St" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Is it possible to scroll through values posted from a form using PHP? Here
> is my problem: I have a form on a page which is created dynamically from
the
> number of fields in a particular table, so when I POST the data how do I
> create the INSERT statement? I feel this will be awkward due to the
> construction of the INSERT statement and I would be very grateful for
> anyone's input. The form names are the same as the field alues in the
> table...
>
> It will need to be something like
>
> $query = "
>
> while (more Form Fields){
> $query = $query + "'form fieldname'";
> }
>
> $query = $query + ") VALUES (";
>
> while (more POST Values){
> $query = $query + "POST Value";
> }
>
> $query = $query + ")";
>
> I hope this makes sense to the reader!
>
> Thanks
>
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
