...

View Full Version : retrieve information into table.



airy
07-23-2012, 01:39 PM
I want to list out everything from database to a proper table. However , there are only header but no details/information come out. Could anyone please help me

<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=$cat_id\">$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">&nbsp;</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>&nbsp;</p>
</form>

Keleth
07-23-2012, 03:07 PM
You need to show the relevant portions of your code, like the query itself, and tell us what framework/system you're using, as the database functions there are non-standard. We cant debug your code if we don't know what its doing.

Have you tried feeding your query through a command line like phpMyAdmin?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum