Hello varmadba,

Thanks for giving your query, its works for me.

Hello R0bb0b,

Your query doesn't works for me.

The problem solved, its because of my processor fan and heat sink is full of dust, i cleared all those dust, now the pc is not shuts down while playing any games for long time.

Hi friends,

I think the MySql is not case sensitive for selecting values. for example I am having a table called dept,

Id | Depart

1 | BTECH
11 | it
12 | ibt
2 | BE

Hi tesuji,

the problem solved for me with your old query idea, that is with the help of

(SELECT transaction, credit, debit, credit+coalesce((SELECT sum(credit)

FROM act b WHERE...

How to check the CPU Temperature in BIOS, first how to go to BIOS settings.

Hai tesuji,

Thank U for your reply. sorry i have missed to mention one thing.....
that is ,
In My ACT table credit and debit fields are not a field name . it is a alias name of...

hello tesuji please help me.

I am sure the heat is the main problem, is that using two cd drives make over heating of cpu?
how to increase the temperature limit of my pc?

Hi all,

I am vinodh, my system configurations are as follows.

Intel D845GVSR chipset
Pentium 4 prcessor with 2.4G.Hz speed
2 rams i.e 1gb ddr and 256mb ddr. total is 1.25 gb
one samsung cd...

Hai, Let me give some sample , for example..

I need the Mysql query to find the Balance calculations from credit and debit amount
of below noted table.But in the ACT table there is no field...

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?

select @rownum:=@rownum+1 "sl.no",

...

for me also same problem plz tell

Logfile of HijackThis v1.99.1
Scan saved at 6:29:03 AM, on 11/10/2006
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:...