Stumbling across some posts online, I noticed [some of] my messages were
being sent as evil ugly HTML - so I'm going to do my best to post from
Thunderbird for the list. Gotta keep OE configured as is for all the
lovely meeting scheduling.
Stuart Felenstein wrote:
--- Jochem Maas <[EMAIL PROTE
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> > if (count($inds) > 0 AND is_array($inds)) {
> > $ind = "'".implode("','", $inds)."'";
> > }
>
> looks like you want to do a select statement with
> $ind in the form of
> "SELECT * FROM yourtable WHERE yourfield IN ($inds)"
>
Adding the IN cla
Stuart Felenstein wrote:
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
don't be sorry, be pro-active and rewrite it until
its idiot proof. its
in your own best interest - the clearer you state
your problem the
greater the chance someone will/can help you.
I don't know about anyone else, but I hav
Norland, Martin wrote:
-Original Message-
From: Jochem Maas [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 11:59 AM
Subject: Re: [PHP-DB] Update multiple records
...
That's what I get for troubleshooting before lunch!
My apologies to the list and to anyone unfortunate enou
--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> don't be sorry, be pro-active and rewrite it until
> its idiot proof. its
> in your own best interest - the clearer you state
> your problem the
> greater the chance someone will/can help you.
>
Well I've started with a clean slate. Meaning I
ditc
Stuart Felenstein wrote:
Having a problem here with updating multiple records
in a table.
as Martin Norland (a heavy hitter on this list AFAIKT) already stated
you don't seem to be at the stage of actually doing an update, no big
deal - only you are doing yourself an injustice by given a misle
> -Original Message-
> From: Jochem Maas [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 11:59 AM
> Subject: Re: [PHP-DB] Update multiple records
[snip]
> > This line in particular clearly warrants attention. Cookie to
whoever
> > guesses what&
Norland, Martin wrote:
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 10:40 AM
Subject: [PHP-DB] Update multiple records
Having a problem here with updating multiple records in a table.
[snip]
Lets see - where to begin...
SELECT
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 10:40 AM
> Subject: [PHP-DB] Update multiple records
>
> Having a problem here with updating multiple records in a table.
[snip]
Lets see - where to begin..
Having a problem here with updating multiple records
in a table.
First the table is like such:
+-+--+
| RecordID [int] | IndID [int] |
+-+--+
There is no auto inc column. User has a record number
and then can have multiple rows in tabl
I think , You should do following :
update weld_details set parent = '1' where db_uid = '1' or db_uid = '2'
Ben Cairns wrote:
> I want to update a MySQL db table, but I want to update multiple records,
>
> Like this:
>
> I want to run a statement like this:
> update weld_details set parent = '
> From: Ben Cairns [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 17, 2001 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update Multiple records
>
>
> I want to update a MySQL db table, but I want to update
> multiple records,
>
> Like this:
>
> I want to
I want to update a MySQL db table, but I want to update multiple records,
Like this:
I want to run a statement like this:
update weld_details set parent = '1' where db_uid = '1','2'
Now, it dont work, and I cant see why, I think it has something to do with the
numbers at the end of the stateme
13 matches
Mail list logo