query sometimes returns ghost data

[zathrus]

I haven\'t been able to find this answer on the web, so here\'s what\'s happening.

 

A fairly simple php script is calling a mysql database, and putting the results into an array.

 

This database stores information on products, so there may be multiple rows with the same name, but they\'ll have a different topic type (category) and they all have a unique id of course.

 

Here\'s a chunk from the file (this script calls another database, and generates links to information in that database)

 

while($row = mysql_fetch_row($topic_result))

{ 

//row[0]=Topic_id

$test = $row[0];

$items++;

$topic_types_query = "SELECT Name, `Order` FROM `Topic_Types` WHERE Topic_Type = \'$test\'";

$topic_type_result = mysql_query($topic_types_query);

$topic_type_row = mysql_fetch_array($topic_type_result);



     $link_list[] = array(\'order\' => $topic_type_row[1],

         \'id\' => $row_id[0],

                           \'type\' => $row[0],

                      \'type_name\' => $topic_type_row[0]);



}



$counter=0;

$items +=5;  //shouldn\'t have to do this, but if I don\'t add at least one to

//this value, 1 less result gets printed, than there should be, in all cases

while($counter <= $items)

{

  $i=0;

  while($i <= $items)

  {

     if ($link_list[$i][\'order\'] == $counter)

{

//print $items;

print $link_list[$i][`order`];

           $info_box_contents[] = array(\'text\' => "<tr><td><a href=http://somewebsite.com/Topics/somefile.cgi?ZType=" . $link_list[$i][type] . "&ZID=" . $link_list[$i][id] . ">" . $link_list[$i][\'type_name\'] . "</a></td></tr>");

}

$i++;

  }



  $counter++;

}

 

(some of the values used come from further up)

 

So, the results are simply

 

some link

another link

another link (as many as there is information in the database on that item)

 

However with 2 items specifically, you get

some link

<-- blank line

some link

another link

etc

 

Anyone know where this ghost data is originating from?

(that is my entire question)

 

I\'ve also tried checking if the elements are empty before I print but mysql didn\'t agree with me on that.

 

Thanks in advance, Jonathan.