urtrivedi
-
Content Count
2 -
Joined
-
Last visited
-
Concurrency Problem? update together in the same time
urtrivedi replied to .hack//GU's topic in Programming
Actually You can build Transactions before update or inserting data into database. also don't work with out proper primary and foreign keys in you tables. Try to use autogenerate option for primary keys. I suppose you are using mysql database, I dont know about mysql transactions, but I use oracle 10g. If I have to execute set of 2 query in the manner that 2 should succeed or no query should execute. $query1="some insert";$statement1 = oci_parse($connection, $query1);if ((oci_execute($statement1,OCI_DEFAULT))){[indent] $query2="some more insert"; $statement2 = oci_parse($connection, $query2); if ((oci_execute($statement2,OCI_DEFAULT))) [indent] oci_commit($connection)); [/indent] else[indent] oci_rollback($connection)); [/indent][/indent]}else{ oci_rollback($connection)) ;} You please specify what problem exactly you are facing. Why you feel that you data is not concurrent. Notice from rvalkass: Code needs to go inside Code BBTags. List of BBCodes -
I think work on cache and meta tag will not help much, if you want to reload previous page when back is clicked.I tried many things. Every browser has it own objects so it is difficult to implement. One little and less effective solution is that you keep one button on your page say "Back"<script lang='javascript'> function btnback_click()//go back to previous { window.location.href="previous_page.php"; }</script><body> <input type=button name=btnback id=btnback value=Back onclick='java script:btnback_click()/></body>