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: [email protected]
> 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
