if (isset($_GET['catId']) && (int) $_GET['catId'] > 0) { $catId = (int) $_GET['catId']; $sql2 = " AND p.cat_id = {$catId}"; $queryString = "catId={$catId}"; } else { $catId = 0; $sql2 = ''; $queryString = ''; } // for paging // how many rows to show per page $rowsPerPage = 5; $sql = "SELECT pd_id, c.cat_id, cat_name, pd_name, pd_thumbnail\r\n FROM tbl_product p, tbl_category c\r\n\t\tWHERE p.cat_id = c.cat_id {$sql2}\r\n\t\tORDER BY pd_name"; $result = dbQuery(getPagingQuery($sql, $rowsPerPage)); $pagingLink = getPagingLink($sql, $rowsPerPage, $queryString); $categoryList = buildCategoryOptions($catId); ?> <p> </p> <form action="processProduct.php?action=addProduct" method="post" name="frmListProduct" id="frmListProduct"> <table width="100%" border="0" cellspacing="0" cellpadding="2" class="text"> <tr> <td align="right">View products in : <select name="cboCategory" class="box" id="cboCategory" onChange="viewProduct();"> <option selected>All Category</option> <?php echo $categoryList; ?> </select> </td> </tr>
if (!defined('WEB_ROOT')) { exit; } // make sure a Course id exists if (isset($_GET['CourseId']) && $_GET['CourseId'] > 0) { $CourseId = $_GET['CourseId']; } else { // redirect to index.php if Course id is not present header('Location: index.php'); } // get Course info $sql = "SELECT name, description FROM courses WHERE course_id = {$detailCourseId}"; $result = mysql_query($sql) or die('Cannot get Course. ' . mysql_error()); $row = mysql_fetch_assoc($result); extract($row); $list = buildCategoryOptions($cat_id); ?> <form action="processCourse.php?action=modifyCourse&CourseId=<?php echo $CourseId; ?> " method="post" enctype="multipart/form-data" name="frmAddCourse" id="frmAddCourse"> <p align="center" class="formTitle">Modify Course</p> <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable"> <tr> <td width="150" class="label">Category</td> <td class="content"> <select name="cboCategory" id="cboCategory" class="box"> <option value="" selected>-- Choose Category --</option> <?php echo $list;