Hello all. I'm hoping to be able to get some help in solving a problem with query/rowcount output. I've been learning PHP and mySQL for about 7 months now and have several successful Mods written/modified for PHP-Fusion CMS version7.00.05. My host is running PHP-5 and MySQL-5. I am converting a Mod from Fusion-ver6 to work on ver-7, called Classified Ads. It has turned out to be a MONSTER to modify and I have run into a snag. There is code that selects ALL the categories and divides them in half displaying half in a table TD and the other half in another TD beside it for a 2 column display. This works just great. What I have is 22 categories and approx. 220 sub-categories. What I am trying to do is display the number of sub-categories below each main category. Here is a pic of the current display with annotations:
I tried using the same code (which works for the main cats), to display the # of sub-cats. It works fine for the first TD but fails in the second TD. I will show the pertinent code rather than posting the entire script, unless requested to do so. Here is the code that produces what you see in the pic:
Code: echo "<table width='100%' border='0' cellspacing='0' cellpadding='3'><tr>n";
$result = dbquery("SELECT * FROM ".DB_CLASSIFIED_CATEGORIES." WHERE status='1' AND parentid=0");
$numrows = dbrows($result);
if($numrows > 0) {
$numrows % 2 ? $numrows += 1 : $numrows;
$rows = $numrows / 2;
echo "<td valign='top' width='50%'>";
$result = dbquery("SELECT cid, title, description, image, parentid FROM ".DB_CLASSIFIED_CATEGORIES." WHERE status='1' AND parentid='0' ORDER BY title LIMIT $rows");
while(list($cid, $title, $description, $image, $parentid) = dbarraynum($result))
{
$count1=dbcount("(*)", $db_prefix."classified", " cid='$cid' AND status='1'");
echo "<table cellspacing='2' cellpadding='1' width='100%' border='0'><tr>n";
echo "<td valign='top' width='100%'>";
if($image) {
echo "<a href='".FUSION_SELF."?op=view_ad&cid=".$cid."'><img src='".INFUSIONS."classified_ads_panel/images/cat/".$image."' alt='".$title."' border='0'></a>(<strong>".$count1." ";
if($count1>1 || $count1<1) {
echo $locale['CLS_0120'];
} else {
echo $locale['CLS_0119'];
}
echo "</strong>)";
} else {
echo "<a href='".FUSION_SELF."?op=view_ad&cid=".$cid."'><strong>".$title."</strong></a>(<strong>".$count1." ";
if($count1>1 || $count1<1) {
echo $locale['CLS_0120'];
} else {
echo $locale['CLS_0119'];
}
echo "</strong>)<br />";
// start here
$subresult = dbquery("SELECT * FROM ".DB_CLASSIFIED_CATEGORIES." WHERE status='1' AND parentid >0");
$myrows = dbrows($subresult);
if($myrows > 0) {
$myrows % 2 ? $myrows += 1 : $myrows;
$subrows = $myrows / 2;
$subresult = dbquery("SELECT cid, title, description, image, parentid FROM ".DB_CLASSIFIED_CATEGORIES." WHERE parentid >0 AND parentid=$cid ORDER BY parentid LIMIT $subrows");
$myrows = dbrows($subresult);
$subrows = $myrows;
}
echo $subrows." sub-categories<br />";
// end here
}
echo "</td>n";
echo "</tr><tr>n";
echo "<td>".$description."</td>n";
echo "</tr></table>n";
}
echo "</td><td valign='top' width='50%'>";
$result1 = dbquery("SELECT cid, title, description, image, parentid FROM ".DB_CLASSIFIED_CATEGORIES." WHERE status='1' AND parentid='0' ORDER BY title LIMIT $rows, $rows");
while(list($cid, $title, $description, $image, $parentid) = dbarraynum($result1))
{
$count1=dbcount("(*)", $db_prefix."classified", " cid='$cid' AND status='1'");
echo "<table cellspacing='2' cellpadding='1' width='100%' border='0'><tr>n";
echo "<td valign='top' width='100%'>";
if($image) {
echo "<a href='".FUSION_SELF."?op=view_ad&cid=".$cid."'><img src='".INFUSIONS."classified_ads_panel/images/cat/".$image."' alt='".$title."' border='0'></a>(<strong>".$count1." ";
if($count1>1 || $count1<1) {
echo $locale['CLS_0120'];
} else {
echo $locale['CLS_0119'];
}
echo "</strong>)";
} else {
echo "<a href='".FUSION_SELF."?op=view_ad&cid=".$cid."'><strong>".$title."</strong></a>(<strong>".$count1." ";
if($count1>1 || $count1<1) {
echo $locale['CLS_0120'];
} else {
echo $locale['CLS_0119'];
}
echo "</strong>)<br />";
// start here
$subresult = dbquery("SELECT cid, title, description, image, parentid FROM ".DB_CLASSIFIED_CATEGORIES." WHERE parentid >0 AND parentid=$cid ORDER BY parentid LIMIT $subrows, $subrows");
$myrows = dbrows($subresult);
$subrows = $myrows;
echo $subrows." sub-categories<br />";
// end here
}
echo "</td>n";
echo "</tr><tr>n";
echo "<td>".$description."</td>n";
echo "</tr></table>n";
}
echo "</td>n";
}
I'm wondering why my added code works OK for the first part but not the second part. Any and all help/suggestions would be GREATLY appreciated
Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listings and associated photographs. The output is using two MySQL querys and WHILE statements. The outer
Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first step. Any suggestions are greatly appreciated.
Forum tutorial
Im a beginner in PHP. Im making a forum(previous questbook, counter and few others) to learn. For now I know something. I started making the forum from this
Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built right but I am having some problems when debugging. I do not have PHP Designer 2008 and I am using
Dynamically allocating the number of rows in a table based on a variable value
Hi, I have situation here which i cannot resolve, I have a variable temp which stores the number of rows in a array for example temp=5 which is calculated based on other values in my table( so temp
writing a screen scraper
Hello,I'm writing a screen scraper application and want to be able to get absolute addresses for images from relative links.So a link like this: Code: <img
query help
Hi experts.
DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at various times.
Redistributing dependent dlls
Hai all ,I have created an application in VC++ using VS2008 in a development machine which runs on Vista, now i need to run that application in a target machine which runs on windows XP SP2 which does
Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but for some reason it's not working...My HTML Form:Code: <form action="script.php"