-
A little help
Hey all
Just a quick question
My site www.musicxq.com well if you look at the Navagation you will se it has lots of [][][][][] at the end for some reason. I was wondering why this is and if you could help. The code in the Navagation file is:
PHP Code:
<?
include "config.php";
$sql = mysql_query("SELECT * FROM `nav` ORDER BY `id` ASC");
while ($disp = mysql_fetch_array($sql)) {
echo ("
<a href=\"$disp[url]\">[$disp[name]]</a> |
");
}
?>
So, if you could help me and get that sorted it would be great
Thanks in advance
-
Like I said, its your SQL im sure...
-
Its your SQL.
I think you might be calling a column name that isnt there.
[$disp[name]]
Its running through it correctly but it cannot pull $disp[name] out of the DB.
hence why its showing all the []'s
;)
-
Kevin I think the column is there, as he has SOME navigation links.
I think he just has some empty rows?
-
Maybe he does..
His domain doesn't even work for me so im going off the top of my head..
Im thinking its either empty rows or the column is undefined
-
perhaps there is empty stuff in the db
-
Proablem Solved.... Thread Closed ;]