sql into a variable

[adamhhh]

probably very simple to do but i cant quite figure it out. I have in my MySQL db an 'email' column, but i want to return this as a variable, so i can send an e-mail to an email address in the form of $email?

[thorpe]

<?php
  // make db connection
  $sql = "SELECT email FROM tbl";
  if ($result = mysql_query($sql)) {
    $record = mysql_fetch_row($result);
    $email = $record[0];
  }
?>