//get currency $currency_attributes = displayCurrencyType(); //get all product reviews $product_feedbacks = Userdashboard::listProductFeedbacks($userid); $totalrows = count($product_feedbacks); //get pagination results $limit = getPaginationLimit(); if ($limit == 0) { $limit = 10; } $page = isset($_GET['page']) ? trim($_GET['page']) : 1; if (empty($page)) { $page = 1; } $sql = " SELECT p.product_name ,f.*, u.user_name,u.email FROM " . $tableprefix . "Review f\n\t\tINNER JOIN " . $tableprefix . "users u ON f.nUserId = u.user_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id = f.nProdId\n WHERE f.nUserId = {$userid}\n AND f.vActive = '1' AND f.deleted = 0\n ORDER BY f.vDateAdded DESC "; $product_feedbacks_records = Userdashboard::getPaginationResult($sql, $limit, $page); /*display the active template*/ $active_template = displayTemplate(); include "includes/htmltop.php"; /* Top File Name */ include_once "includes/" . $active_template[0]; ?> <script language="JavaScript" type="text/JavaScript"> function confirmDelete(){ return confirm('Are you sure to delete this feedback?'); } </script> <!-- content area Right Column starts-------------------------------------------------------------- -->