No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master … 
|
|
|
Hi I am trying to get my dreamweaver cs3 to get connected to mysql. But I got this error "your php server doesn't have the mysql module loaded or you can't use the mysql(p)connect functions" I have configure php.ini and the environment setting. extension....mysql.dll extension...mysqli.dll Previously I have install xampp …
|