rawr... mysql_error() "PHP Problem"

[fuzic]

I have a piece of code, which is supposed to return a result from a database where the field "fid" is equivilent to the value of the variable $forum. Instead, when the script is called, it endlessly prints "PHP Problem". Thanks in advance.

$i = 0;
$forum = 1;
$query2 = "SELECT * FROM guide WHERE fid = '".$forum."'";
$result2 = mysql_query($query2) or die(mysql_error());
$num = mysql_numrows($result2);
while ($i < $num) {
$title=mysql_result($result2,$i,"name");
echo $title;
}

[LordShryku]

Is this the whole script? And does is say "PHP Problem" verbatim? That's not a usual error message....

Also, somewhere in your while loop, you should probably increment $i...

[TTT]

$query2 = "SELECT * FROM guide WHERE fid = '".$forum."'";

i think forum field is "int"??

=>

$query2 = "SELECT * FROM guide WHERE fid = ".$forum;

[fuzic]

here is the whole script, I tried the int thing, but it still returns the same message.

<?
$i = 0;
$forum = 1;
$arr = array(1 => "lounge", "school", "religion", "stupidity", "good stuff");
$db2 = mysql_connect(localhost, "usr", "pw");
mysql_select_db('markar_nu-forum',$db2);
$query2 = "SELECT * FROM guide WHERE fid = ".$forum;

$result2 = mysql_query($query2) or die(mysql_error());
$num = mysql_numrows($result2);
while ($i < $num) {
$title=mysql_result($result2,$i,"name");
$fid=mysql_result($result2,$i,"fid");

$id=mysql_result($result2,$i,"id");
$strt=mysql_result($result2,$i,"thread_start");
$rply=mysql_result($result2,$i,"thread_recent");

$crtn=mysql_result($result2,$i,"creation");

$mod=mysql_result($result2,$i,"modification");
$posts=mysql_result($result2,$i,"postcount");
echo $title;
}
?>