$sql = mysql_query("SELECT link_id,link_date FROM " . table_links . " ORDER BY link_date DESC LIMIT 1"); while ($rows = mysql_fetch_array($sql)) { $link_date = txt_time_diff(unixtimestamp($rows['link_date'])); $main_smarty->assign('link_date', $link_date); $main_smarty->assign('link_id', $rows['link_id']); }