result from mysql_query

$result = mysql_query($sql) or die('Error, query'.$sql.'failed'.mysql_error());
while($row = mysql_fetch_assoc($result)){..}

$sql = "SELECT NOW() AS current_now, TIME_TO_SEC(TIMEDIFF(NOW(), :line)) AS different";
$stmt = $dbc->prepare($sql);
$stmt->execute(array(':line' => $line));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as $row){
    extract($row);
}