Its syntax is: int mysql_result (int result_id, int row [, mixed field])
@mysql_connect("localhost", "root","") or die("Could not connect to MySQL server!");
@mysql_select_db("mydatabase") or die("Could not select database!");
$query = "SELECT * FROM mytable";
$result = mysql_query($query);
$x = 0;
print "";
print "ID Title MyValue
while ($x < mysql_numrows($result)) :
$id = mysql_result($result, $x, 'id');
$name = mysql_result($result, $x, 'title');
$price = mysql_result($result, $x, 'myvalue');
print "";
print "$id $title $myvalue ";
print " ";
$x++;
endwhile;
mysql_close();
?>