mysql 跳过一个事物_MySQL跳过第一行

I have seen other people with that problem but the solutions I've seen aren't helping me, or I don't know how to use them :P

$ordre = "nom";

$croissance = "ASC";

if(isset($_GET["ordre"])){

$ordre = $_GET["ordre"];

};

if(isset($_GET["croissance"])){

$croissance = $_GET["croissance"];

};

$con = mysql_connect('localhost','root','');

mysql_select_db('sdj_jeux', $con);

$sql = "SELECT * FROM jeux ORDER BY $ordre $croissance";

$result = mysql_query($sql, $con);

$row = mysql_fetch_array($result);

$couleurcompteur = 0;

while ($row = mysql_fetch_array($result)){

$couleurcompteur += 1;

if($couleurcompteur % 2){

$classe = "pale";

} else {

$classe = "fonce";

};

?>

My code is skipping the first row of my database and I don't understand why.

解决方案

Remove the line:

$row = mysql_fetch_array($result);

The while loop will grab the first row on the first iteration.

Resulting code:

$ordre = "nom";

$croissance = "ASC";

if(isset($_GET["ordre"])){

$ordre = $_GET["ordre"];

};

if(isset($_GET["croissance"])){

$croissance = $_GET["croissance"];

};

$con = mysql_connect('localhost','root','');

mysql_select_db('sdj_jeux', $con);

$sql = "SELECT * FROM jeux ORDER BY $ordre $croissance";

$result = mysql_query($sql, $con);

$couleurcompteur = 0;

while ($row = mysql_fetch_array($result)){

$couleurcompteur += 1;

if($couleurcompteur % 2){

$classe = "pale";

} else {

$classe = "fonce";

};

?>