Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory :  /var/www/html/mmishra/indem/webbioexam/biomedical/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
include "header.inc";
$tbl = 'remaining_alloted_2';

//$rno = 1;
//last rollno was 401; on 31052012
//$rno =402; 
//last rollno was 804; on 31052012
//$rno=805;
//last rollno was 1006 on 01062012
//$rno=1007;
//last rollno was 1238 on 01062012
//$rno=1239;
//last rollno was 1666 on 01062012
$rno=1667;

        $rs = mysql_query("select * from $tbl where rollno is NULL and flag!=2");
        while ($o = mysql_fetch_object($rs)) {
		$ps = mysql_query ("update remaining_alloted_2 set rollno=$rno where id = $o->id");
		if ($ps) { echo "$id updated with rollno = $rno"; }
		  else   { echo mysql_error(); }
                $rno = $rno + 1;
        }
include "footer.inc";
?>