newbie - edit mulitiple rows at a time?

[Anon]

I not seeing an easy way to edit multiple rows of data from an mysql database at a time. I have problem pulling up one record @ a time updating it.

I can get to the data from the database, create the multiple form/text boxes populated with the data, but I can't my head around how send it all back @ one time.

HELLLPPPPP!!!!!

Adam

[sepodati]

Use multiple INSERTS...

For example...if you want your user to update their name and address, name your form elements like this.

<input type=text name=name[]>
<input type=text name=address[]>

Put as many of those as you need, all named the same. Use a loop to create them if you can...

Then, in your processing page, to do the update, use this:

for($count=0;$count<count($name);$count++)
{
$result = mysql_query("INSERT INTO your_table (name,address) VALUES ('$name[$count]','$address[$count]')");
}

That's with no error checking, but it's that easy...Depending if your using PHP3 or PHP4, you might have to create your query as a string, if you can't have the array values directly in the string...

$query = "INSERT INTO your_table (name,address) VALUES ('" . $name[$count] . "','" . $address[$count] . "')";
$result = mysql_query($query);

---John Holmes...

[Anon]

Arrays ...
thanks I ran into an article using the same syntax 'name=variable[]' right after I posted.
Your examples helped clarify the usage.
Appreciate the timely response.

I will let you know if anything blows up :>

Adam