On Wed, 2008-11-19 at 18:51 +0000, Alice Wei wrote: > Hi, > > I am inquiring on this list to see if it is possible to create a script that takes multiple update statements without my having to write one "SQL" statement for each of the updates. > > I have a scenario of which I create a table of some sort with some existing information using Flex, and what I am told by my client is that no matter how many records there are on the screen, the users should be able to update any up to all the entries by simply pushing a button. I use Microsoft SQL, which I think that it does allow multiple update query execution. The problem is that I might have to come up with some method to accept all the "POST" variables the user provides into the script. > > Could anyone please give me some guidance on what kind of function I might use, or whether or not it is possible I can create a script that accepts as many "POST" variables as the users POST? > > Thanks a lot for your help. > > Alice > > _________________________________________________________________ > Check the weather nationwide with MSN Search: Try it now! > http://search.msn.com/results.aspx?q=weather&FORM=WLMTAG When I'm stuck on queries I always fall back to see how phpMyAdmin would treat it. Do a dummy run in there by updating a few rows of information at once, and then see what the SQL it produces looks like. You can perform multiple queries by using semicolons. Bear in mind that the queries are still treated as separate, so you may want to do them as a transaction if you need to fall back in-case of a problem. Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
