RE: [PHP] SQL SERVER - Can't apply changes to database
| From: | John W. Holmes | Date: | Fri, 11 Apr 2003 02:50:34 +0000 |
| Subject: | RE: [PHP] SQL SERVER - Can't apply changes to database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143431@lists.php.net to get a copy of this message | ||
> I'm using (for test purposes) Windows 98 / Apache 1.3.14 / PHP 4.3.1 /
SQL
> SERVER 7.0
> The script below makes a change on the the Northwind Database. This is
the
> sequence:
>
> 1 - UPDATE Employees table
> 2 - SELECT Employees table
> 3- SHOW the results
>
> When I run the script, the SELECT part shows that my update was ok.
> But If I call the php script again, my changes were not saved. If I
use
> query analyzer, I make changes normally. The SQL Profiler registers
the
> instructions... but no change is applied to my database.
Is it maybe some transaction issue? Like the change is not committed, so
it's not actually kept once the script ends? I'm grasping at straws
here... :)
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/