PHP Page Reloading

[akamol]

Hi all ,

I am using php,apache,nysql on red hat 7.3
Using php Script i am updating serial number field for each record in a tble which has abou 0.5 million records , in the script i have set kounter to 1 which i am increasing for each record but when my script starts it starts updating the records say upto 0.2 million records or about 3-4 minutes ...after that the kounter gets reset to 1 which i have reseted before the query and again it starts updating upto 0.2 million records and this goes on ....what could be the problem how can the counter which i set before the query starts reset to 1 ...which means the script has started afresh. In php.ini the max_execution_time is set to 600 seconds i.e. 10 minutes.

please help.

[cosminb]

maybe you could show us the code so we can see what you're talking about

[akamol]

hi cosminb
actually we are using three tables using left join

following the query which was we are using
so what is wrong on this query

$qry0="select if(c.reg_no!=\"\",c.reg_no, c.fil_no) as filno, if(c.reg_no!=\"\"
,'R','S') as flag, substring(if(c.reg_no!=\"\", c.reg_no, c.fil_no),6,5) as case
no, substring(if(c.reg_no!=\"\", c.reg_no,c.fil_no),11,4) as caseyr, purpose, ne
xt_dt,lst_case,lst_conn,lst_appl, b.srno from main as c, heardt as a left join p
riority as b on a.purpose=b.stage where a.fil_no=c.fil_no and a.next_dt='$m_curd
ate' and a.jud1=$m_jud1 and a.jud2=$m_jud2 and a.jud3=$m_jud3 and b.jud1=$m_jud
1 and b.jud2=$m_jud2 and b.jud3=$m_jud3 and side='$m_sideflg' and b.brdstat='A'
order by b.srno, caseyr, caseno "

please tell or send any information about same one.

[cosminb]

it's not properly indented😕
....
please post the human readable form of your code