[RESOLVED] mysql query echo

[agulaid]

Hi havin probs with da following, dont know how to echo the database query.

<?php

mysql_connect("localhost","root","") or die("Unable to connect to SQL server"); 
mysql_select_db("database") or die("Unable to SELECT DB"); /////dont need



$query="SELECT Petrol FROM country WHERE Country= 'England'";
$result=mysql_query($query);



echo ($result);



?>

[laserlight]

Try:

$row = mysql_fetch_assoc($result);
echo $row['Petrol'];

or if there is really only one column selected:

echo mysql_result($result, 0);

[agulaid]

laserlight wrote:

Try:

$row = mysql_fetch_assoc($result);
echo $row['Petrol'];

or if there is really only one column selected:

echo mysql_result($result, 0);

Fantastic, thats done. Thanks.