Jump to content


Photo

query sometimes returns ghost data


  • Please log in to reply
No replies to this topic

#1 zathrus

zathrus
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 24 June 2003 - 06:25 PM

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 caseswhile($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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users