manniru
10/27/2014 - 6:53 PM

convert old results table to new results

convert old results table to new results

<?php error_reporting(0);

$cn=mysqli_connect("localhost","root","","agp");

//$o = (object) mysqli_fetch_assoc(mysqli_query($cn,"SELECT * FROM _application WHERE uid='10'")); echo $o->fullname;



$result = mysqli_query($cn,"SELECT * FROM `_results_dont_del`");

while($row = mysqli_fetch_array($result)) {
	$courses = $row['courses'];
	$marks = $row['marks'];
	
	$cs = explode(",", $courses);
	$mk = explode(",", $marks);
	
	for($i=0; $i<count($cs)-1; $i++) {
	//foreach ($cs as $k=>$v) {
		$cw = $mk[$i*3];
		$ex = $mk[$i*3+1];
		$tt = $mk[$i*3+2];
		echo $cs[$i]."-$cw-$ex,";
	}
	echo '<br>';
}








?>