RE: [PHP-WIN] Is this possible

Trevor, I think I have this one licked. Not tested yet, but a little bit of javascript and it should work like a dream. Ta for helping me focus. George > -----Original Message----- > From: Gryffyn, Trevor [mailto:TGryffyn@air-cargo-inc.com] > Sent: 7 May 2004 6:22 pm > To: php-windows@lists.php.net > Cc: George Pitcher > Subject: RE: [PHP-WIN] Is this possible > > > That's sort of what I thought you were getting at George. > > How's this scenario work for you: > > 1. User pulls up initial screen, either showing all data or no data at > all > --- SELECT recordid,projectid,title,genre,author,whatever FROM > sometable > 2. User enters parameters for recordset (ie. All records after January > 1st, All records matching a certain ID # or other criteria). This > returns your recordset which is a subset of everything you have in the > database (say 5 out of 100 records all with something in common) > --- SELECT recordid,projectid,title,genre,author,whatever FROM > sometable WHERE readytodeliver = 'Yes' > 3. User changes or sets the item "Delivery Date: 5/4/04" for instance > and clicks the "Submit" button. If you ALWAYS want to change this item > in everything in the recordset you're viewing, then pass the parameters > for the recordset along with the changed data. > --- UPDATE sometable SET deliverydate = '$formdeliverydate' > WHERE readytodeliver = 'Yes' > > > Of course adapting to use mysql functions in PHP and/or whatever the > proper syntax is for your database system (forgive me, I work with > Oracle and SQL Server and use the ADODB functions so I usually deal in > straight SQL instead of PHP built-in database functions). > > > I know you said it gets a little more complicated, but whatever your > "WHERE" criteria are, you should be able to pass back along with the > DeliveryDate data even if you have to hide the WHERE criteria in a > hidden form field or a SESSION variable. Essentially this ends up > saying "That data I just requested and looked at.. Change this field all > to the same thing I just entered". > > Am I missing something or is this what you were looking for? > > -TG > > > > George Pitcher said: > > The Filemaker function I'm attempting to replicate is called > > 'Replace' and it basically takes the data from the field that > > the user has 'in focus' and sets each recordset.record's > > equivalent field to that value, regardless of data type, so > > it works on strings, numbers and dates. > > > > A typical use would be where we have searched for everything > > that is ready to deliver to the customer and enter a delivery > > date into each record. They aren't usually that simple, else > > I would script it differently (as I will for the actual delivery > > date), but I'm sure you've got my drift by now. > > > > Cheers > > > > George >