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_
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
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))
>
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))
>
> {
>
> ?>
>
>
>
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
5 matches
Mail list logo