prepare("
SELECT
`bookmarks`.*,
COUNT(`keywords`.`bookmarkid`) AS `num_keywords`
FROM `bookmarks`
LEFT JOIN `keywords` ON
(`bookmarks`.`bookmarkid` = `keywords`.`bookmarkid`)
WHERE
`username` = :username
GROUP BY
`bookmarks`.`bookmarkid`
");
$get_bookmarks->execute(array(
':username' => $_SESSION['username']
));
$get_keywords = $db->prepare("
SELECT * FROM `keywords`
WHERE `bookmarkid` = :bookmarkid
");
while ($row = $get_bookmarks->fetch())
{
echo '