Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
hi guys..need some help from you all..im creating an add category feature of our system..i have a problem because the i am encountering this error
Fatal error: Call to undefined function: getpagingquery() in D:\Server\xampp\htdocs\ieccTESTproj\admin\category\list.php on line 22
here's the list.php this displays all the category if there is, if not a prompt will show on the page that there is no category available.Code: Select all
<?php
if (!defined('WEB_ROOT')) {
exit;
}
if (isset($_GET['Categoryno']) && (int)$_GET['catId'] >= 0) {
$catId = (int)$_GET['catId'];
$queryString = "&catId=$catId";
} else {
$catId = 0;
$queryString = '';
}
// for paging
// how many rows to show per page
$rowsPerPage = 5;
$sql = "SELECT Categoryno, Cat_Parent_ID, Cat_Name, Cat_Description, Cat_Image
FROM tblcategory
WHERE Cat_Parent_ID = $catId
ORDER BY Cat_Name";
//THIS WHERE THE ERROR IS..
$result = dbQuery(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage);
?>
<p> </p>
<form action="processCategory.php?action=addCategory" method="post" name="frmListCategory" id="frmListCategory">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="text">
<tr align="center" id="listTableHeader">
<td>Category Name</td>
<td>Description</td>
<td width="75">Image</td>
<td width="75">Modify</td>
<td width="75">Delete</td>
</tr>
<?php
$Cat_Parent_ID = 0;
if (dbNumRows($result) > 0) {
$i = 0;
while($row = dbFetchAssoc($result)) {
extract($row);
if ($i%2) {
$class = 'row1';
} else {
$class = 'row2';
}
$i += 1;
if ($Cat_Parent_ID == 0) {
$Cat_Name = "<a href=\"index.php?catId=$Categoryno\">$Cat_Name</a>";
}
if ($Cat_Image) {
$Cat_Image = WEB_ROOT . 'images/category/' . $Cat_Image;
} else {
$Cat_Image = WEB_ROOT . 'images/no-image-small.png';
}
?>
<tr class="<?php echo $class; ?>">
<td><?php echo $Cat_Name; ?></td>
<td><?php echo nl2br($Cat_Description); ?></td>
<td width="75" align="center"><img src="<?php echo $Cat_Image; ?>"></td>
<td width="75" align="center"><a href="javascript:modifyCategory(<?php echo $Cat_ID; ?>);">Modify</a></td>
<td width="75" align="center"><a href="javascript:deleteCategory(<?php echo $Cat_ID; ?>);">Delete</a></td>
</tr>
<?php
} // end while
?>
<tr>
<td colspan="5" align="center">
<?php
echo $pagingLink;
?></td>
</tr>
<?php
} else {
?>
<tr>
<td colspan="5" align="center">No Categories Yet</td>
</tr>
<?php
}
?>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5" align="right"> <input name="btnAddCategory" type="button" id="btnAddCategory" value="Add Category" class="box" onClick="addCategory(<?php echo $catId; ?>)">
</td>
</tr>
</table>
<p> </p>
</form>feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]