Problem regarding MySQL Query using PHP

[mahendrakalkura]

hi guys

this is my code

when i run this i get nothing as output

absolutely nothing

just blank

<?php

$query = "SELECT name , page FROM navigation WHERE id > 0 AND weight > 0 ORDER BY weight";
$result = mysql_query($query,$connect);
while($row = mysql_fetch_row($result)) {     
    print("<a href=\"".$PHP_SELF."?page=".$row['page']."\" target=\"_self\">".$row['name']."</a><BR>");	
}

?>

but if i put $row[0] and $row[1] in the print statement i get desired output

please tell me where i am going wrong

thanks

[diego25]

Please read these following two pages:
http://www.php.net/manual/en/function.mysql-fetch-row.php
and compare it with other mysql_fetch functions (e.g. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object, etc) and see which one is better for you.

Diego

[mahendrakalkura]

thanks diego

i think i must use this

mysql_fetch_array($resultset,MYSQL_ASSOC);

i will try it

thanks

😃 😃 😃