mysql - first element missing
| From: | f.collineau | Date: | Thu, 06 Mar 2003 10:36:38 +0000 |
| Subject: | mysql - first element missing | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26115@lists.php.net to get a copy of this message | ||
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