Furthermore, instead of the for-next loop, I would use while ($row = mysql_fetch_row($this->result).
Edwin
Foong wrote:
i guess the problem is the last line of your Query function: $this->ligne = @mysql_fetch_row($this->result);
this line fetch the first row of the result.
therefore, when you call afficheResultatRequete(...) you start from the second row of the result.
Foong
"F.Collineau" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi,
I try to display the result of a mysql request but first element misses ! here is my code:
$sql->Query("select marque, reference from base ); $sql->afficheResultatRequete($sql->result,$sql->nbreChamps);
function Query ($query) { $this->result = @mysql_query($query, $this->id) or MySQL_ErrorMsg ("Impossible de lancer la requete: $query"); $this->rows = @mysql_num_rows($this->result); $this->nbreChamps = @mysql_num_fields($this->result); $this->ligne = @mysql_fetch_row($this->result); }
function afficheResultatRequete($result,$nbChamps) { for($i=0 ; $row=mysql_fetch_row($result);++$i) { print("<tr>"); $this->color_tab($i); for($j=0;$j<$nbChamps;$j++) { print "<td>"; print((string)$row[$j]); "</td>\n"; } print "</tr>"; }
}
Whet is the problem ?
Thanks
Franck ------------------------------------------
Faites un voeu et puis Voila ! www.voila.fr
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php