Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Top Download Block Table , Please HELPPPP

Well iam trying to put 3 or 4 Top list on this block, but i cant, becouse it need somekind of Html tag to make table, so i have try to make it so there will be 3 Top Download on 1 Row and another 3 Top Download under it, but i cant cant get it to work. i dont know what to change on the $content.="<, and i dont know what to add to it, please help me out before this coming feb 10 becouse i will be going to college and i have not have no computer to work on the site no more. please help me out, here is the privew of the block at. [ Register or login to view links on this board. ] Pluz if you have any block that will list alot of Top 10 OT Newest in a nice organize fasion please let me know about it. i have a due date to finish this

<?php
// Title of Top Downloads section
$titlenewdocuments = "New 10 Documents";
// Title of New Downloads section
$titlenewdownloads = "New 10 Downloads";

if (eregi("block-Download_Links.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $dbi;
$content="";
$content.="<center><a href=\"modules.php?name=Downloads\"><img src=\"modules/Downloads/images/down-logo.gif\" border=\"0\" width=\"221\" height=\"42\"></a></center>";
$content.="<table border=\"0\" cellspacing=\"0\" cellpadding=\"4\" align=\"center\" width=\"90%\"><tr>";
$result = sql_query("select cid, title, cdescription from ".$prefix."_downloads_categories where parentid=0 order by title", $dbi);
$count = 0;
while(list($cid, $title, $cdescription) = sql_fetch_row($result, $dbi)) {
$content.="<td align=\"left\" valign=\"top\" width=\"50%\"> \n"
 ."• ;;<a href=\"modules.php?name=Downloads&d_op=viewdownload&cid=$cid\">$title</a>";
if ($cdescription) {
 $content.=" $cdescription ";
} else {
$content.=" ";
}
$result2 = sql_query("select cid, title from ".$prefix."_downloads_categories where parentid=$cid order by title limit 0,3", $dbi);
$space = 0;
while(list($cid, $stitle) = sql_fetch_row($result2, $dbi)) {
 if ($space>0) {
 $content.=", ;;";
 }
 $content.="<a href=\"modules.php?name=Downloads&d_op=viewdownload&cid=$cid\">$stitle</a>";
 $space++;
}
if ($count<1) {
 $content.="</td><td> ;; ;;</td>";
 $dum = 1;
}
$count++;
if ($count==2) {
 $content.="</td></tr><tr>";
 $count = 0;
 $dum = 0;
}
}
if ($dum == 1) {

$result = sql_query("select * from ".$prefix."_downloads_downloads", $dbi);
$numrows = sql_num_rows($result, $dbi);
$result = sql_query("select * from ".$prefix."_downloads_categories", $dbi);
$catnum = sql_num_rows($result, $dbi);

$content.="</tr><tr><td align=\"center\" valign=\"top\" colspan=\"3\">There are $numrows downloads and $catnum Categories in our database</td></tr></table>";
} elseif ($dum == 0) {
$content.="<td></td></tr></table>";

}

$content .= "<hr noshade size=\"2\" color=\"#333333\">";
$content.="<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\" align=\"center\" width=\"100%\" bgcolor=\"\"><tr><td valign=\"top\" width=\"49%\">";
$content .= "$titlenewdocuments: ";

$a = 1;
$result = sql_query("select artid, title, counter from ".$prefix."_seccont order by secid DESC limit 0,10", $dbi);
while(list($artid, $title, $secid) = sql_fetch_row($result, $dbi)) {
$title2 = ereg_replace("_", " ", $title);
if(strlen($title) > 21) {
$title2 = substr($title,0,21);
$title2 .= "..";
}
$content .= "$a: <a href=\"modules.php?name=Sections&op=viewarticle&artid=$artid\" target=\"_self\">$title2</a> ;;($secid hits) ";
$a++;
}

 $content.="</td><td valign=\"middle\" width=\"2%\"> ;;</td><td valign=\"top\" width=\"49%\">";
$content .= "$titlenewdownloads: ";

$a = 1;
$result = sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by date DESC limit 0,10", $dbi);
while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {
$title2 = ereg_replace("_", " ", $title);
if(strlen($title) > 27) {
$title2 = substr($title,0,25);
$title2 .= "..";
}
$content .= "$a: <a href=\"modules.php?name=Downloads&d_op=viewdownloaddetails&lid=$lid&ttitle=$utitle\" target=\"_self\">$title2</a> ;;($hits hits) ";
$a++;
}

$content.="</td></tr></table>";

?>

Well i was playing around with this block and i just could get it, i almost did, but it just don't look rigth, any idea of how todo this?

I am really not sure what you mean but i think you want it to show 3 downloads in a row then another 3 so forth so on..

Mess with the

if ($count==2) {
$content.="</td></tr><tr>";
$count = 0;
$dum = 0;

Make the first set start the table and the last end the tr.

Well i want it to look like this

Check tihs website , i made this using html. but i want it to work with phpnuke block,

[ Register or login to view links on this board.]

You guys just ignore people here, if you guys dont want to help please just say so, becouse i want to ask if i could get help here or now, thanks

Originally posted by Telli:

I am really not sure what you mean but i think you want it to show 3 downloads in a row then another 3 so forth so on..

Mess with the

if ($count==2) {
$content.="</td></tr><tr>";
$count = 0;
$dum = 0;

Make the first set start the table and the last end the tr.

Looks like someone already tried to help you at least once. Doesn't look like you're being ignored to me. Try having a little patience. This is a help forum, not an instant messenger. When someone comes online that is able to help you, I'm sure they will.

Kelly

I did do that bro, i create it on html and convert it to php with the php. but it still does work . it work but it nots rigth, its all wack up..

and i use HTML to AnyCode Converter

thats what i use to conver it

if ($count==2) {
$content.="</td></tr><tr>";
$count = 0;
$dum = 0;

Hello, can anyone help me?

when you messed around with the code given to you...did you change the vaiables? to say 3 and then change the 0 to say 3, etc?

if nothing changed then we prolly did not understand exactly what you wanted to say or achieve?

taut