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.
If you want to reuse the same SQL query by just changing the parameters
you may consider using the PDO's driver for mssql an make prepared
statements.
Never used MsSQL so I am not sure that prepared statements work the same
as with other PDO drivers.
check this on the manual:
http://www.php.net/manual/en/pdo.prepare.php
You may also find instructions on how to install and use PDO and the
drivers it support on the manual as well.
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.
You can do that by using the $_POST array which stores all the posted data.
check this:
http://www.php.net/manual/en/reserved.variables.post.php
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
Those two elementary howtos may be of some help:
http://www.w3schools.com/php/php_post.asp
http://www.tizag.com/phpT/postget.php
If all these seem too elementary for you then try to describe your
problem in a more detailed manner. Better questions get better answers.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
