Re: php-db Digest: Sending multiple values from a form having same field names.

Your line : <input type="hidden" name="field_id" value="<?php echo $field_id;?>" /> Should probably be: <input type="hidden" name="<?php echo $field_id; ?>" value="<?php echo $field_id;?>" /> So that each field's name isn't the string "field_id", but rather is each field's unique ID.

Hi, How can I send multiple values from a form to be stored in a database, as name of the fields is the same? For example: <?php foreach ($field_data as $field) {

         $field_name=$field["field_name"];
         $field_id=$field["field_id"];
         $datatype=$field["datatype_name"];

?> <input type="hidden" name="field_id" value="<?php echo $field_id;?>" /> <tr> <td><strong><?php echo $field_name;?><strong></td> <?php

     if ($datatype=="text" || $datatype=="integer") {
            echo "<td><input type=\"text\" name=\"field_data\"></td>";
     }
     elseif ($datatype=="textarea") {
          echo "<td><textarea rows=\"10\" cols=\"100\"

name=\"field_data\"></textarea><br></td>";

      }
      echo "</tr>";

} ?> This creates a form with field names and text box or textarea box next to each field name depending on the datatype. After the user enters the values in the text or textarea and clicks submit, the values should get stored in a database. But what is happening is that only the value entered in the last field of the form is getting entered into the database. This code is embedded in an application which is having an inbuilt structure of taking the values from a form in a hash. Since key is the same (i.e. field_id) everytime, the value gets overwritten and only the last value gets stored in db. But I am not able to work out a solution for this. I hope I am able to make my problem clear enough. Thanks, Suamya. ----------------------------------------------------------------------------- DISCLAIMER:-

          "The information in this e-mail is confidential, and is intended solely for the addressee or addressees. If you are not the intended recipient,
 please delete the mail and kindly notify the sender of misdelivery. Any unauthorised use or disclosure of the contents of the mail is not permitted and may be unlawful."

-----------------------------------------------------------------------------

                         "Scanned By MailScanner"

------------------------------------------------------------------------ Subject: Re: [PHP] Fastest way to get table records' number From: "Daniel Brown" <parasane@gmail.com> Date: Wed, 19 Mar 2008 09:42:07 -0400 To: Shelley <myphplist@gmail.com> To: Shelley <myphplist@gmail.com> CC: php-general@lists.php.net, "PHP DB" <php-db@lists.php.net> On Tue, Mar 18, 2008 at 11:43 PM, Shelley <myphplist@gmail.com> wrote:

Hi all, What do you think is the FASTEST sql to get the total number of a table with millions of records?

That question would be better on the PHP-DB list, so for archive's sake, I'm CC'ing that list.

    $sql = "SELECT COUNT(*) FROM your_table";