PHP+MySQL=Baffled

[dolphinsnot]

i'm puzzled. here's some simple code that pulls from a db. following the code is a problem description.

---

<?
$db = mysql_pconnect("host", "user", "pass");
mysql_select_db("DBNAME", $db);
$result = @($statement, $db);
$num_of_rows = @mysql_num_rows($result);

if($num_of_rows > 0) {

    while($row = mysql_fetch_row($result)){
            echo $row[4];
            echo $row[0];
    }
}

?>

in the while statement, $row[0] is echoed, but $row[4] is not. if i try all of them from $row[0] - $row[8], all but $row[4] echo.

$row[4] contains either:

NOINDEX,NOFOLLOW
or
INDEX,FOLLOW

anyone? please?

-dolphinsnot

[hawleyj]

What is the value of $statement?

[cordex]

do var_dump() or print_r() of $row where you are echoing the values out and find out what it contains.

[dolphinsnot]

the question you just asked pointed me directly to the solution.

my silly self wasn't even selecting the field i was trying to display.

my brain hurts. the php-based website i've worked 7 months on is about to go live. these tiny details are driving me bonkers.

Thanks So Much!

-dolphinsnot