getting a mysql value into a variable

[joebudden]

Hi guys, I know its really simple and i'm really lame for asking but whats the easiest way to get a mysql integer value into a variable?

[kykin]

are there any special operations you want to do to the integer, or do you just want to pull an integer out of your database?

[code]
$sql = "SELECT * FROM `tablename`";

$result = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
$integer = $row['fieldcontainingintegers'];

                echo $integer;
        }
[/code]

will get an integer out, but this is my super-long-roundabout way to do it...