trouble with forumdisplay.php

I hope someone can help me. I am trying to to figure out a way to pull a variable from a table seoperate from the threads table and have a value show in the forumdisplaybit. I try to place a query right after this code in forumdisplay.php

PHP Code:

while ($thread=$DB_site->fetch_array($threads)) { // and $counter++<$perpage) { 


but it doesn't seem to get the info from the DB is there i think i am placing this code incorrectly hope i explained this well enough
and that someone can help me

Thnaks in advance

jsell

[Chris M]

How would I make a Query to pull just the ReplyCount, The Thread Title, and then link it to the thread id?

Ive tried loads of queries, but i cant get it to work...

Could those queries be adapted?

If so, would you mind telling how?

Satan

[NTLDR]

PHP Code:

$threadquery=$DB_site->query("SELECT threadid,title,replycount FROM thread"); 


Then use $threadquery[threadid] for the threadid. The above query will return the values for all threads.

[Chris M]

Cool thanks

You wouldnt happen to know how I could get that to display in a table would you?

Satan

[NTLDR]

Basicly have this PHP and then two templates, the bit, for each result and the mainone to house them all:

PHP Code:

$threadquery=$DB_site->query("SELECT threadid,title,replycount FROM thread");
while ($threadinfo = $DB_site->fetch_array($threadquery)) {

        $title = unhtmlspecialchars($threadinfo['title']);
        $replycount = $threadinfo['replycount'];
        $threadid = $threadinfo['threadid'];
        eval("\$threadbits .= \"".gettemplate('query_bit')."\";");
    }
eval("\$threads = \"".gettemplate('query')."\";"); 


Change query_bit and query in the eval statements to your template names

[Chris M]

Thanks

Satan

[jsell]

it doesn't work right i'm sure i'm doing something wrong

here is what i changed the $threads Query to

PHP Code:

$threads=$DB_site->query("
SELECT $dotuserid $votequery ".iif($foruminfo[allowicons],'icon.title as icontitle,icon.iconpath,','')."
    thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
    lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attach,reqdata.threadid,reqdata.filler AS reqfiller
    FROM thread
    LEFT JOIN reqdata USING (threadid)
    ".iif($foruminfo[allowicons],'LEFT JOIN icon ON (icon.iconid = thread.iconid)','')."
    $dotjoin
    WHERE $threadids
    ORDER BY sticky DESC, $sortfield $sqlsortorder
    "); 


then below inside the while loop

PHP Code:

while ($thread=$DB_site->fetch_array($threads)) { // and $counter++<$perpage) { 


i put

PHP Code:

 //request hack
   if ($threads[reqfiller]!='') {
       eval("\$filledby = \"".gettemplate('filledby')."\";");
   } else {
       $filledby='';
      }
   //request hack 


but it doesn't assign a value to the variable $threads[reqfiller]

any idea

Thanks

--jsell

[Chris M]

Thats because it would be :

PHP Code:

//request hack
   if ($thread[reqfiller]!='') {
       eval("\$filledby = \"".gettemplate('filledby')."\";");
   } else {
       $filledby='';
      }
   //request hack 


You assigned the variable $thread to fetch the array of $threads, so you use $thread not $threads

Try that code, and $thread[reqfiller]

Satan

[jsell]

Thanks i think my brain is fried

--jsell

[Erwin]

LOL! I see that you're getting support from the pros here. Sorry I didn't get back to this thread sooner, but it looks like things are under control.

[Xenon]

you're welcome jsell

@Erwin: That thread is a good example:
So sees a problem and many users jump to it and try to solve