Close   

Admin and announcement forums

    30 Mar 2008
Mysql transactions  
kumar rakesh
create and manage free online surveys with unlimited responses
Online surveys are now basic requirement of everyone who want to review there products or to make studies about anything. But finding a solution who can provide esurveys efficiently is really a big pain. creating an online survey with inefficient tool as irritating and getting survey conducted with limitations on responses is even worse.
cont..
    30 Mar 2008
Mysql transactions  
kumar rakesh
practice interviews and prepare for interviews
in todays changing world every one want to increase there salaries very quickly.
Changes your employer is an very efficient solution for this. But changing employer and company is not so easy.
cont..

Viewed 41 times
Total posts : 1

    23 Aug 2008
Mysql transactions  
kumar rakesh
His other forums
Mysql transactions
Hello everybody.

I'm trying to use transactions provided by mysql in my scripts. but no success.
i've tried to run updates with transactions from mysql command prompt. Commands i've used are as follows

delimiter $
start transactions;
update address_book set name = 'trial'  where address_id = 2;
rollback;
$
delimiter ;

By my logics this update should be rollback without affecting database entries.
But it always fails, updating the data set.

i hope if it is not running in command prompt then it will definitely not run from my scripts ( php scripts)

Can anybody help me doing this. Where i'm making the mistake............

Thanks.
27 Aug 2008
 
kumar rakesh
His other forums
Hi

I didn't find the problem in above code, but i found how to write transaction in php.



actually it's too easy to write transaction in php.



It's as easy as writing simple queries.

 for example



myqsl_query("start transaction");

mysql_query("write your query here");

mysql_query("write your query here");



.............................



mysql_query("rollback or commit");



that's it.



enjoy.
Login to participate in forums

Login to participate in forums
jump to :
Post reply on this forum

1

Comment on this forum
Name :
Email :
Comments :
Legends
Mysql transactions Forums tagged Mysql transactions Forums tagged. But locked for further reply
="Mysql Forums locked. can not accept further replies Mysql transactions General forum