Revision 6757394c-afdc-42a6-96f3-677fa1087058 - Stack Overflow

[**From documentation**](https://www.php.net/manual/en/function.mysql-fetch-array.php)

 >Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined. By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. Using MYSQL_ASSOC, you only get associative indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works).

That's actually the way it works, if you need more rows to be returned you will need to loop throw the records

 while($rnat = mysql_fetch_array($nats))
 {
 //print here
 }