Hi, Thanks for the replies, guys. I could finally come up with the actual code to do multiple updates. Just like some of you said, I had to name my index variables for it to distinguish between different elements. for($i = 1;$i <= $total; $i++){ $a = $_POST['a'.$i]; $b = $_POST['b'.$i]; $c = $_POST['c'.$i]; $d = $_POST['d'.$i]; $e = $_POST['e'.$i]; $sql = "UPDATE table SET market='$a',IM_accept='$b', IM_defer='$c', CR_accept='$d', FC_accept='$e' WHERE scenario_id='$scenario_id'"; echo "<update_$i>$sql</update_$i>"; $result2=mssql_query($sql) or die ("Can't execute $sql"); }
However, this might be out of the question I have been asking here. Has anyone tried to do this type of stuff using Flex and PHP? Alice > Date: Wed, 19 Nov 2008 12:23:33 -0800 > From: [EMAIL PROTECTED] > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Multiple Update SQL Statements Execution > > On Wed, Nov 19, 2008 at 5:55 AM, Alice Wei <[EMAIL PROTECTED]> wrote: > > 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'm not sure I understand your question. It is certainly possible to > write one query that updates multiple rows at once. In other cases, > you can use prepared statements and bound variables. If all you need > to do is repeat a query of the same structure with different values, a > prepared statement would be faster and mean cleaner code than sending > repeated queries. > > Without more specific info from you, I don't think I can give a better > answer than this. I've never worked with Microsoft SQL Server, so I > doubt there's anything I can tell you about that in particular. > > > > 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. > > Let's see. If your POST includes the IDs of the rows you want to > change and the value you want to update, it could go something like > this. Note that I haven't tested it, so it might contain an error. > I'm just trying to provide an illustration of the approach. > > <?php > > /* > > SKIPPED: connect to your database as appropriate. Below I show using > the PDO extension to escape the incoming data using the quote() > method. If you are using the mssql extension instead, there is no > escape function (!) so you'll have to decide how best to escape the > data. That's reason enough for me to prefer PDO. > > If you don't know what I'm talking about here, you should study SQL > injection until you're sure you fully understand. Otherwise you will > produce very vulnerable code. > > */ > > $sql = "UPDATE sometable SET somecolumn = '" . > $pdo->quote($_POST['field']) . "' WHERE id IN (" > . implode(',' $_POST['id']) . ")"; > > /* > > Send this query to your database as appropriate. It will set > 'somecolumn' to the value of $_POST['field'] where the ID is in the > list. In this case the form should submit the $_POST['id'] value as > an array, which can be done by using setting the HTML name attribute > to id[] (e.g. name="id[]"). > > */ > > ?> > > Does this help? > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > _________________________________________________________________ Check the weather nationwide with MSN Search: Try it now! http://search.msn.com/results.aspx?q=weather&FORM=WLMTAG