[mr_atom]

Hi I have a database called CARS within it is a table called FORD which contains a field called SPEED. All I want to do is write some simple php code to retrieve the first entry in the field SPEED and print it to the screen. Can anyone help? I a

More...

[binary8383]

hope this help

<?php

$conn = mysql_connect("localhost", "*****", "**********");
mysql_select_db("car");

$sql = "select speed from ford limit 1";

$res = mysql_query($sql, $conn) or die(mysql_error());

if($res && mysql_num_rows($res))
{
while ($rows = mysql_fetch_array($res))
{
echo "speed is ".$rows['speed'];
}

}

mysql_free_result($res);
?>