Weird request - Pull Thread titles

[lasto]

sort of

its useing the colors of my board but the box for the title appears at the bottom while the thread titles appear at the top

[Deaths]

Ni, by some title I ment the title which you want to give it, like "Total threads in forum XXX"

[lasto]

yeah i know that

i gave it a title but what im saying is with the code you provided the title should appear in a box which it does,but it appears right at the bottom of the page and the titles from the threads appear before it.

No worries though i can quite easy fix this bit - cheers again death.

[Deaths]

Ok .

If you need any other help, just gimme a shout.

[lasto]

will do m8 cheers

ok everything i have asked for has been completed and is working really well but id like to expand upon this if someone wants to help.

So far it now pulls the threads titles and displays them in alphabet mode but id like the display to be made in boxes if possible to make it look more presentable.

At moment it just shows the titles so how about a seperate column to show the author of the post ?

[lasto]

is there anyway i can have the code tydied up - look in the post above for a pic of the display i see.I would like it to be in a sort of box or mouseover from when i go from one link to the next if possible.Anything but plain text on a white screen

[Deaths]

Add this above your query:

PHP Code:

$alt=1; 


Now, INSIDE the foreach tag, add this:

PHP Code:

$alt++;
   if ($alt>2) $alt=1; 


Example:

PHP Code:

foreach (XXX as YYY)
{
eval....
$alt++;
   if ($alt>2) $alt=1;
} 


Now, in the bit template, to your td tag, add:

class="alt$alt"

So, like this:

<td class="alt$alt">.....

That should color up the links' backgrounds

[lasto]

ok another thing - is there a way to get it to pull the date of the thread title with it so can see when it was made and very last thing to actually pull the size of the attachment so when viewing all the maps on a seperate page it will show the following info :

mapname1 05/05 127KB

etc

[lasto]

Fatal error: Call to a member function on a non-object in /home/custom/vb3/maps.php on line 4

does the above query work on vb3.5.4 as ive just upgraded the board and this no longer works.

Here is the code in my php file

<?php
require_once('./global.php');

$results = $DB_site->query("
SELECT threadid, title FROM " . TABLE_PREFIX . " thread WHERE (forumid=82 OR forumid=83) ORDER BY title ASC
");

while ($row = $DB_site->fetch_Array($results))
{
$id = $row['threadid'];
$title = $row['title'];
eval('$threadbits .= "' . fetch_template('mypage_threadbits') . '";');
}
$mapcount = $DB_site->query_first("SELECT count(threadid) AS maps FROM " . TABLE_PREFIX . "thread WHERE (orumid=82

OR forumid=83)");

$nummaps = $mapcount['maps'];
eval('print_output("' . fetch_template('mypage_main') . '");');
?>