MySQL skipping first row

by

Remove the line:

$row = mysql_fetch_array($result);

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

Resulting code:

<?php
$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";  
    };
?>

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. How to execute raw queries with Laravel 5.1?
  3. Problame with files on SQL
  4. save user images in MYSQL database by which method? [closed]
  5. Im trying to create some temporary tables in mysql using php
  6. How can I prevent SQL injection in PHP?
  7. SQL injection that gets around mysql_real_escape_string()
  8. How to include a PHP variable inside a MySQL statement
  9. How to apply bindValue method in LIMIT clause?
  10. PDO get the last ID inserted
  11. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  12. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  13. Importing CSV data using PHP/MySQL
  14. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  15. I cannot get my login form to connect interact properly with mySQL database [closed]
  16. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  17. Increment value in MySQL update query
  18. PDO::PARAM for type decimal?
  19. Selecting a float in MySQL
  20. Get all child, grandchild etc nodes under parent using php with mysql query results
  21. MYSQL Select from tables based on multiple rows
  22. Saving images in database mysql
  23. Fatal error: Call to a member function query() on null
  24. How would I implement a simple site search with php and mySQL?
  25. mysql injection damages?
  26. how do I get month from date in mysql
  27. How do I save PHP session data to a database instead of in the file system?
  28. php/mysql zip code proximity search
  29. Mysqli multiple row insert, simple multi insert query [duplicate]
  30. Aggregated query without GROUP BY

Leave a Comment