grabphp

<?php
$servername="localhost";
$username="id399211_teamgbz";
$password="killerz";
$dbNAme="id399211_test123";
$conn=new mysqli($servername,$username,$password,$dbNAme);
if(!$conn){
echo "Done";
die("connection faild.".mysqli_connect_error());
}
$sql="select * from table1 order by score desc";
$result=mysqli_query($conn,$sql);
if(mysqli_num_rows($result) > 0){
		//show data for each row
		while($row = mysqli_fetch_assoc($result)){
			echo "ID:".$row['id'] . "|Name:".$row['name']. "|Score:".$row['score'].";";
		}
	}
if(!result) echo "There was an error";


?>