Re: How do you update multiple rows at the same time?
| From: | Max Tappenden | Date: | Mon, 27 Jan 2003 07:24:51 +0000 |
| Subject: | Re: How do you update multiple rows at the same time? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-133223@lists.php.net to get a copy of this message | ||
You on MySQL?
If so do this
UPDATE tblName SET firstcol = '$var41stcol', $secondcol = '$var42ndcol'
and so on
"Steve Jackson" <stephen.jackson@violasystems.com> wrote in message
news:000001c2c3a0$27591b50$07c810ac@upponetti.upponetti.com...
> I am having trouble with this.
> I need to update 1column in a variable number of rows depending on how
> many categories are in my database at a given time.
>
> Can anyone provide any pointers or example code
>
>
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> <http://www.violasystems.com/>
> http://www.violasystems.com
> stephen.jackson@violasystems.com
> Mobile +358 50 343 5159
>
>
>
>
>