just get one entry from table

[android6011]

I know it seems like im flooding these forums with terrible questions, but I am going through some of my code and realizing that the coding is terrible :/ . If I want to get one field, like say age for a certain id number, what is the best method?

[soycharliente]

<?php
$sql = "SELECT `age` FROM `table` WHERE `id`='$id'";
$result = mysql_query($sql) OR DIE (mysql_error());
if (mysql_num_rows($result))
{
$row = mysql_fetch_assoc($result)
{
	echo "<p>Your age is {$row['age']}!</p>";
}
}
else
{
// no rows returned but valid query
}
?>