Dang thing won't loop!

[TWTCommish]

I'm working on a hack, and I am using code with the below format (in my main vB directory)...however, the query only produces one row, even though running it manually produces more than that. It seems as if it's not running through the loop more than once...any idea on what might be wrong with it? Thanks in advance.

PHP Code:

<?php
require("./global.php");

$forumlist = $DB_site->query("SELECT * FROM forum WHERE displayorder != '0' AND active = '1' ORDER BY parentid, displayorder");
  while ($forum = $DB_site->fetch_array($forumlist)) {
    // do stuff
  }
$DB_site->free_result($forumlist);
unset($forum);

Could it be that those variables ($forumlist, $forum) are conflicting with some others in use in the global.php file?

[JamesUS]

Quite possibly. Try unsetting them both before your code:

PHP Code:

<?php
require("./global.php");

unset($forumlist);
unset($forum);
//your code here

[TWTCommish]

Good idea. Just tried it, but still no loopage.

[TWTCommish]

Alright, if someone can help me figure out what's wrong with this (seemingly) simple block of code, I'll give 'em a link in the footer of every page on my site (MovieForums.com) for 2 weeks (probably more...I'm lazy about taking stuff like that down). The site gets 150-200 posts a day on average.

Any assistance is appreciated!

[Admin]

Will you put *another* link to Israel.com if I help you?

j/k, I can't really understand why it won't loop.

[TWTCommish]

LOL...sure I would! Hehe. Yeah, I'm stumped to. It's really a very simple block of code. I ran the query elsewhere and it does indeed produce more than one record...the one that the script does spit out (by itself) each time is the last one returned when I run the query in phpMyAdmin...dunno if that's useful, though.

[Dolby]

I have a script that lists stuff... Look at this and insert your stuff and it should work for you.

PHP Code:

// echo "html that doesnt repeat";
$result=mysql_query("SELECT * FROM user where (usergroupid = '6' OR usergroupid ='8' OR usergroupid ='9') AND r_class = 'bard' order by username") or die ("Query Failed:".mysql_error());
while ($row = mysql_fetch_row($result)) {
    echo "//html that repeats... <tr><td width=200><a href=rprofile.php?ruser=$row[2]>$row[2] $row[42]</a></td><td>Lvl:$row[43]</td><td>$row[44]</td><td width=100>$row[46]</td></tr>
<tr><td colspan=4><hr size=1 width=100%></td></tr>";
}
// echo "html that doesnt repeat"; 


[TWTCommish]

Well, I have no problem grabbing data...I'm just sticking with vB's functions, because it's cleaner that way. I'm wondering if there is some quirk in the DB_site class that's preventing this loop from running properly.

[JamesUS]

Which version are you on Chris?

[TWTCommish]

Nope...this is with 2.0.3.