output times 23?? Mysql and php

[porco]

Here is a query I am running. For some reason it outputs each find 23 times. So find 1 is 23 times, find 2 is 23 times etc... long page.

Has anyone got any idea here? I can't see how it could be doing this? and why this number?

$result = mysql_query("select TBTree.CategoryName, TBArticle.ArticleSubject, TBArticle.ArticleDateTime from TBTree, TBArticle where TBTree.CategoryName='Technology'");

		 $rows = mysql_num_rows($result);

		 for ($i = 0; $i < $rows; $i++)
		 {
		     $data = mysql_fetch_row($result);

		    echo "$data[1], $data[2]<br>\n";
	   }

[LordShryku]

You're fetching the same row over and over. Try this instead.

$sql = "SELECT TBTree.CategoryName AS cat, 
               TBArticle.ArticleSubject AS sub, 
               TBArticle.ArticleDateTime AS art
          FROM TBTree, TBArticle 
         WHERE TBTree.CategoryName='Technology'";
$result = mysql_query($sql);
while($data = mysql_fetch_array($result)) {
    echo $data['cat'].", ".$data['sub'].", ".$data['art']."<br>\n"; 
}

[porco]

I cut and pasted it straight into the page and it still pulled the same 23 times every match.

Thanks anyway, am still learning php as I go.

[porco]

Is ok I have tracked it to the msql table involved. Legacy database. Anyway hopefully a bit or remodelling or lateral thinking will solver the problem.

Thanks again for any help or advice.