I believe I would need to use unlink() but I'm not sure how this function works. I read the manual. Would it be:
$qry = "select pic from db where user='1'";
$result = mysql_query($qry);
$resultset = mysql_fetch_array($result);
$dir = "/home/website/public_html/images/$resultset[pic]";
//Not sure of the next part and how to delete it from the actual server
unlink($dir);
Would that do the trick?