note 8700 added to mysql_fetch_array

From: Date: Mon, 25 Sep 2000 07:30:49 +0000
Subject: note 8700 added to mysql_fetch_array
Groups: php.notes 
Request: Send a blank email to php-notes+get-5406@lists.php.net to get a copy of this message
I`m a newbie in PHP and I am having some trouble with mysql_fetch_array, but maybe my problem evolves beyond the boundries of mysql_fetch_array, but anyway: I want to display data that is presented in "portal" 1... check it out: $sql = "SELECT artikler.dato as date, artikler.tittel as title, artikler.navn as name FROM artikler, nyhetsportaler WHERE artikler.artikkelid = nyhetsportaler.artikkelid AND nyhetsportaler.portalid = '1'" ; $result = mysql_query($sql,$link) ; while ($row = mysql_fetch_array($result)) { echo " $row[date] , $row[title], $row[name]" ; Ideally, this would output 8 rows of data from artikler, but instead it returns 18 * 8 rows of data... Any suggestions??? http://www.php.net/manual/function.mysql-fetch-array.php

« previous php.notes (#5406) next »