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 PROTE

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 cla

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 hav

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 enou

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 ditc

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 misle

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&

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: 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..

[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 tabl

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 = '

RE: [PHP-DB] Update Multiple records

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

[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 stateme