rendered paste body<?phperror_reporting(E_ALL & ~E_NOTICE);define('THIS_SCRIPT', 'showpoem');require_once './global.php';if(empty($_REQUEST['poemid'])){ /* Send user to a different page */ header('Location: index.php');}$sql = "SELECT * FROM poems AS p, users AS u WHERE p.user_id = u.user_id AND p.poem_id = ?";$sth = $db->prepare($sql, array('integer'), MDB2_PREPARE_RESULT);$data = array($_REQUEST['poemid']);$results = $sth->execute($data);if(!MDB2::isError($results)){ /* Display Poem */ $rows = $results->fetchRow(MDB2_FETCHMODE_ASSOC); $smarty->assign('poem_title', $rows['title']); $smarty->assign('poem_id', $rows['poem_id']); $smarty->assign('poem_description', $rows['description']); $smarty->assign('poem_body', $rows['body']); $smarty->assign('poem_added', $rows['added']); $smarty->assign('poem_user_id', $rows['user_id']); $smarty->assign('poem_user_email', $rows['email']); $smarty->display('showpoem.tpl');}else{ /* Error */}?>