--- 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 clause did not help in
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
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
-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 * FROM `Profiles
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: 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 the' problem` might
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
--- 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
ditched
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 enough
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
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
]]
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 run a statement like this:
update weld_details set parent = '1' where db_uid = '1','2'
Now
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 = '1'
13 matches
Mail list logo