snippetsmania.com
Post and share your code snippets

#get a single value
$link=$db->GetOne("SELECT link FROM table WHERE id = 1);

#additional, push to smarty
$smarty->assign("link", $link);

source