Simon wrote:
>>What do you mean with "update more "same" fields at the same time"?Can
>>you give us an example?
>>
>>Gvre
>>
>
>
> <form name="form1" method="post" action="">
>
> <?
>
> $query1 = "SELECT * FROM table where subcat = $_GET[a]";
>
> $result1 = mysql_query($query1);
>
> while($row = mysql_fetch_object($result1))
>
> {
>
> ?>
>
> <p>
>
> <input name="textfield" type="text" value="<? echo $row->oid; ?>">
>
> <input name="textfield1" type="text" value="<? echo $row->url; ?>">
>
> </p>
>
> <?
>
> }
>
> ?>
>
> <p>
>
> <input type="submit" name="Submit" value="Submit">
>
> </p>
>
> </form>
>
> now i want to change values of texfields and update them back to mysql.
>
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 don 't know if this query will execute correctly because i don 't know
the datatypes of your table fields.
I prefer writing update and insert php scripts independed from select
pages.It 's easier to read.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
