Data entry screen input

[kids4966]

I'm developing a small web app to keep track of monthly charges for cell phones for my company. I have all the cell phones in the database. The question I have is how do I have multiple records to be update all at once. For example

I have a data input screen like the following

Month -> Drop down box

Telephone# Input box
555-5555 5.00
555-5556 5.00
555-5557 5.00
555-5558 5.00

update button

When I press the update button I want to right to the database Month, telephoneID, amount

I'm not looking for someone to give me the code just a direction to start looking. I'm new to PHP and need some advice.

Thanks in advance.

[bpat1434]

Well, given a form of:

<form name="CellCharges" action="update.php" method="post">
<select name="Month">
<!-- Month Options here.
Each value is the numerical month -->
</select>

<!-- A loop.  If getting from a database, $row is an array of info from current row -->
$row['telehponeNumber'] <input type="text" name="charges[$row['telephoneID']]">
<!-- each item would have that type of syntax -->
<input type="submit" value="Update">
</form>

Then, just loop through the array "charges" and for each $key => $val pair, tac on a new INSERT statement:

<?php
$charges = $_POST['charges'];
$query = "INSERT INTO `table` (Month, telephoneID, amount) VALUES";
foreach($charges as $telID => $charge)
{
  if(!empty($charge))
  {
    $query .= "\n('".mysql_real_escape_string($_POST['Month'])."', '".$telID."', '".$charge."'),";
  }
}
$query = substr($query, 0, -1); // Removes final ",".  Otherwise, syntax error

Then, just run the query using the [man]mysql[/man] functions.

~Brett