A little Confused

[jamesojackson]

need a little newbie help...

I have retrieved several rows from a query and echo'ed the data into a several rows of text fields..

for example:

Name City State Country

Ken Camden Md USA
Mike Trenton NJ USA
Dave Berlin NJ USA
etc....
etc...
etc...

my goal is to edit these fields and update the database accordingly...

I have no problem updating the database for a SPECIFIC ROW, but can't figure out how to update ALL rows returned from the SELECT query once edited..
how would i cycle through all the rows to have all the rows updated in the database?

could find anything specific to this question on the web

any help would be appreciated ....

[Scriptmaker]

To update all of the rows of the database, you don't have to run a SELECT statement first to get $row[] arrays. Instead, just use the UPDATE feature with a set of data and the same WHERE that you would have used with the SELECT statement:

<?php
$query="UPDATE table 
SET column1='var1',
column2 = 'var2',
columnetc='varetc' 
WHERE id='idnumber'";
mysql_query($query);
?>

Sorry if this isn't what you were looking for. Maybe post a little bit of the code you know and we can go from there.