Next record. PHP + Mysql

If I understand correctly, you need to look up several different ids in a table, so you need a loop of repetition (do not necessarily have to be a while), with a for example would look like this:

for ($i=0; $i<=9; $i++){
  $sql = mysql_query("SELECT * FROM card WHERE id=".$id);
  $row = mysql_fetch_array($sql);

  //aqui vai toda a sua logica com o $row
}

But beware , this is a super simple example with security holes. I only meant you to understand the necessary logic. I recommend you give a read in the php documentation that tells how to make queries in the bank in the best way. I hope I have helped.

As you've been told in the previous quote, these are not the best ways to do this. The above example does what you asked in addition to it, as you commented on while:

$i = 1;
while ($i <= 10){
  $sql = mysql_query("SELECT * FROM card WHERE id=".$id.");
  $row = mysql_fetch_array($sql);

  //aqui vai toda a sua logica com o $row
  $i++;
}

Note that a loop from 1 to 10 using SELECT * FROM card WHERE id = {$id++} does not guarantee that it will return 10 records! If there is a limit of 10 within the limit of 10, then you will have less than what you want.

As an example I will use a smaller amount to not lengthen the response. My suggestion is based on the use of only 2 queries with the IDs available sequentially. :

That way you get N records with sequential IDs, notice that ID-3 and ID-6 have been removed and even then returns 5 IDs , in the case of the query within a loop 3 records would be returned:

SQL: select id from tabela limit 5

Array
(
    [0] => Array
            [id] => 1

    [1] => Array
            [id] => 2

    [2] => Array
            [id] => 4

    [3] => Array
            [id] => 5

    [4] => Array
            [id] => 7

)

Using a foreach to create a list of IDs found:

foreach( mysql_fetch_array($sql) as $rows )
{
    $ids[] = $rows['id'];
}

Now using implode to mount a query with where id in to return all records with the IDs found above: where id in( 1,2,4,5,7)

SQL: select id , nome from tabela where id in( ' . implode( ',' , $ids ) . ' )

Final result

Array
(
    [0] => Array
        (
            [id] => 1
            [nome] => nome 1
        )

    [1] => Array
        (
            [id] => 2
            [nome] => nome 2
        )

    [2] => Array
        (
            [id] => 4
            [nome] => nome 4
        )

    [3] => Array
        (
            [id] => 5
            [nome] => nome 5
        )

    [4] => Array
        (
            [id] => 7
            [nome] => nome 7
        )
)

Good morning, try it this way:

$sql = mysql_query("SELECT * FROM card");
while($dado = mysql_fetch_array($sql)){
   $id = $dado['id'];
}

In this way the variable $id , will receive all the ID's of the table while there is data