Re: [PHP-DB] Update multiple records

2005-01-11 Thread Stuart Felenstein
--- 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

Re: [PHP-DB] Update multiple records

2005-01-11 Thread Martin Norland
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

[PHP-DB] Update multiple records

2005-01-10 Thread Stuart Felenstein
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

RE: [PHP-DB] Update multiple records

2005-01-10 Thread Norland, Martin
-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

Re: [PHP-DB] Update multiple records

2005-01-10 Thread Jochem Maas
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

RE: [PHP-DB] Update multiple records

2005-01-10 Thread Norland, Martin
-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

Re: [PHP-DB] Update multiple records

2005-01-10 Thread Jochem Maas
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

Re: [PHP-DB] Update multiple records

2005-01-10 Thread Stuart Felenstein
--- 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

Re: [PHP-DB] Update multiple records

2005-01-10 Thread Jochem Maas
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

Re: [PHP-DB] Update multiple records

2005-01-10 Thread Jochem Maas
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

[PHP-DB] Update Multiple records

2001-05-17 Thread Ben Cairns
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

RE: [PHP-DB] Update Multiple records

2001-05-17 Thread Michael Rudel
]] 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

Re: [PHP-DB] Update Multiple records

2001-05-17 Thread Ariunbold Gerelt-Od
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'