hello, need some help with php vs. vb

[maoreactor]

hey.

i'm using vb 3.6.8.

i'm struggling with this code:

maor.php:

<?php

$query="SELECT * FROM mst_forum";
$result=mysql_query($query);
$num=mysql_numrows($result);



$i=0;
while ($i > $num)
{

$forumid=mysql_result($result,$i,"forumid");
$title=mysql_result($result,$i,"title");
$lastpost=mysql_result($result,$i,"lastthread");
$lastposter=mysql_result($result,$i,"lastposter");
$lastpostid=mysql_result($result,$i,"lastpostid");

eval('$home["$mods[modid]"][\'content\'] = "' . fetch_template('adv_portal_hehe') . '";');


$i++;

}

?>



template adv_portal_hehe:

<a href=forumdisplay.php?f=$forumid><strong>$title</a><br>
<small>lastpost: <a href=showthread.php?goto=newpost&t=$lastpostid><strong>$lastpost</strong></a> by: <strong>$lastposter</strong></small><BR><BR>


on vBa CMPS i added it as a PHP module integrated with the template above.
as you can guess it does not work. it show that:

http://www.kts.co.il/bah.JPG

if i dont use a template and put an "echo" on the PHP file, it shows what it is supposed to but on the top of my page above the logo, so that's not good either...

thanks for your help ;)

[Opserty]

Are you using the global.php file from vBulletin forum root?

If so:

<?php

$forums = $db->query_read("SELECT * FROM mst_forum");

while ($row = $db->fetch_array($forums))
{
eval('$home["$mods[modid]"][\'content\'] .= "' . fetch_template('adv_portal_hehe') . '";');

}

?>

and in your template:

<a href=forumdisplay.php?f=$row[forumid]><strong>$row[title]</a><br>
<small>lastpost: <a href=showthread.php?goto=newpost&t=$row[lastpostid]><strong>$row[lastpost]</strong></a> by: <strong>$row[lastposter]</strong></small><BR><BR>

[maoreactor]

yep, that works.

thanks alot :)

[maoreactor]

hmm another question, as i see, in order to recognize a catagory, it looks like this:

childlist: 1-,10,4,5
as i dont know what 1- says, the 2nd parameter is the current forumid and 4 and 5 is the child forums of this catagory.

now, how do i make the script know that this forumid has child forums? like,
if ($row['childlist] ?HAS MORE THEN 2 PARAMS?)
{
$num=number of childforums;
$parentid = forumdid of parent;
$childforum[1] = forumid;
$childforum[2] = forumid;
...
}

i have read $array guide at php.net and dont seem to get it...

my main idea is that it will look like this:

CATAGORY: CATAGORY:
forum1 forum1
forum2 forum2
forum3 forum3

CATAGORY: CATAGORY:
forum1 forum1
forum2 forum2
forum3 forum3

thanks for your help :)