PHP Classes

Problem in Data Updation

Recommend this page to a friend!

      PHP Classes blog  >  2008 balance and 2009...  >  All threads  >  Problem in Data Updation  >  (Un) Subscribe thread alerts  
Subject:Problem in Data Updation
Summary:Problem in Data Updation
Messages:2
Author:Prashant Mehta
Date:2009-01-29 12:46:46
Update:2009-01-29 18:23:29
 

  1. Problem in Data Updation   Reply   Report abuse  
Picture of Prashant Mehta Prashant Mehta - 2009-01-29 18:01:17
Hi
i m Prashant Mehta
i am facing a problem in data updation through
PHP in mysql
i am opening a Database conenction in every page and closing that connection at end of that page
i am firing manually updation statements like this

$result=mysql_query("Update abc set abcStatusId=3,
ApprovedBy='".$ApprovedBy."',
ApprovedDate='".date("Y-m-d H:i:s")."',
LastUpdatedBy='".$ApprovedBy."',
LastUpdatedDate='".date("Y-m-d H:i:s")."'
where PageId='".$PageId."'");

and then i am committing it through this statement of PHP
mysql_query("COMMIT",$con);

but the problem occurs is many times update statement failes without any error and it does not updates any data in back end.

Please help me out from this problem

Thanks & Regards,
Prashant Mehta


  2. Re: Problem in Data Updation   Reply   Report abuse  
Picture of Manuel Lemos Manuel Lemos - 2009-01-29 18:23:29 - In reply to message 1 from Prashant Mehta
This forum is not for PHP support questions. Try using the PHP specialists forum instead:

phpclasses.org/discuss/topic/specia ...