Re: [PHP] update more "same" fields at the same time

2003-01-15 Thread Giannis Vrentzos
Simon wrote: >>with the same data or not? >> > > not with the same data > You can put your data and the primary keys in arrays and exec a loop but the data[0] must be the data for the id[0], data[1] must be the data for id[1] etc. The loop should be something like this: for (int $i=0; $i<=total_

Re: [PHP] update more "same" fields at the same time

2003-01-15 Thread Giannis Vrentzos
Simon wrote: If you want to update all the records that have subcat = $_GET[a] with the same values then you can do somethink like this: $subcat = $_POST['a']; $qsubcat = $_POST['subcat']; "update tables set field1=$_POST['textfield'],field2='$_POST['textfield1']' where subcat='$qsubcat'" I do

Re: [PHP] update more "same" fields at the same time

2003-01-15 Thread Giannis Vrentzos
Simon wrote: >>What do you mean with "update more "same" fields at the same time"?Can >>you give us an example? >> >>Gvre >> > > > > > > $query1 = "SELECT * FROM table where subcat = $_GET[a]"; > > $result1 = mysql_query($query1); > > while($row = mysql_fetch_object($result1)) >

Re: [PHP] update more "same" fields at the same time

2003-01-15 Thread Giannis Vrentzos
Simon wrote: >>What do you mean with "update more "same" fields at the same time"?Can >>you give us an example? >> >>Gvre >> > > > > > > $query1 = "SELECT * FROM table where subcat = $_GET[a]"; > > $result1 = mysql_query($query1); > > while($row = mysql_fetch_object($result1)) > > { > > ?> > > >

Re: [PHP] update more "same" fields at the same time

2003-01-15 Thread Giannis Vrentzos
Simon wrote: Hi, I have table with six records in it. I can use "while" to display them all, but in form. Is there any way I can edit all six records, and update them all with one submit. TNX What do you mean with "update more "same" fields at the same time"?Can you give us an example? Gvre