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 = 'tbl_paid_300512';

$up = 1;
//last rollno for UP was 585; on 31052012
 
        $rs = mysql_query("select * from $tbl where state = 'Uttar Pradesh'");
        while ($o = mysql_fetch_object($rs)) {
		$ps = mysql_query ("update $tbl set rollno=$up where id = $o->id");
		if ($ps) { echo "$id updated with rollno = $up"; }
		  else   { echo mysql_error(); }
                $up = $up + 2;
        }
include "footer.inc";
?>