[thelist] PHP arrays

[Andrew Maynes]

I hope this come sput right... I have:

$result=mysql("$DBName","SELECT * FROM Items WHERE ItemID='$II'");
fontFace("Arial","Select an item:<br><br>");
echo "<ul>";
while ($row  =  mysql_fetch_row($result)) {
$IS=$row[0];
$IN=$row[1];
$ID=$row[2];
$IC=$row[3];
$Ca=$row[4];
$SC=$row[5];
$II=$row[6];
}

and I want to present $Ca=$row[4]; as the page title but I dont want the number
1 appearing!  The $Ca=$row[4]; is also Category in another table (Category) but
$Ca=$row[4]; s displaying the number not the description for the chosen
$Ca=$row[4];

Presumably I will have to write an array?  Is there anything I should watch out
for that may cause problems with this?  As I am also going to (hopefully)
writing a for loop to pull all the records for the chosen category and not just
one as this query is doing?

Andrew