Resolved php auto increment doesn't work when showing rows

[Krentenbol]

This is my code:

PHP Code:

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die(mysql_error());
  }
$i=1;
mysql_select_db("list", $con);

$result = mysql_query("SELECT * FROM users
WHERE id='$i'");

while($row = mysql_fetch_array($result))
  {
  echo $row['id'] . " " . $row['name'];
  echo "<br />";
  
  echo $row['id'] . " " . $row['name'];

  echo "<br />";
  $i++;

  }
?>

For some reason it just doesn't increases so I get:

1 John
1 John

[oracleguy]

You are only pulling one row from your users table, the row with the ID of 1 so that is why you'll only see that one printed out in your while loop.