Hi,
if i wanted to convert and echo all the database results of "Petrol", "Gas", "Electricity" how would i do it?
<?php
mysql_connect("localhost","root","") or die("Unable to connect to SQL server");
mysql_select_db("test") or die("Unable to SELECT DB"); /////dont need
$query="SELECT Petrol, Gas, Electricity FROM country WHERE Country= 'England'";
$result=mysql_query($query);
$row = mysql_fetch_assoc($result);
echo $row['Petrol'];
?>