MySQL query not returning all results

[Cobby]

Hi,

 

I have a user table in the DB, for example:

 

+---------+----------------+-------------------+

|    uid    |    username    |      firstname      |

|----------+----------------+------------------+

|      1    |      cobby        |      Andrew          |

|      2    |      admini        |    test-account    |

+---------+-----------------+------------------+

 

If, in phpMyAdmin, I query:

  SELECT `username` FROM `users`;

 

It will return results correctly (cobby and admini, respectively).

But if I make a simple PHP script, such as:

 

<?php

mysql_connect('localhost', 'cobby', 'dbpass');
mysql_select_db('testdb');

$query  = mysql_query('SELECT `username` FROM `users`');
print_r(mysql_fetch_assoc($query));

?>

 

It only returns:

Array ( [username] => admini )

 

Why does it only return the second result?

I have a feeling I'm doing something really silly, but I looked over this test script and its got me stumped.

 

Cheers,

Cobby

 

[adam291086]

try this. I am new to php but i have done this before and it works.

 

 

$query = mysql_query("SELECT username FROM users");
while($row = mysql_fetch_array($query))
  {
  echo $row['username'] 
  echo "<br />";
  }

 

[Cobby]

Ah, I see what is going on now, its trying to return two identical indexes, and because admini is the last row, its value are set into the array. It was something silly, lol  :-\

[adam291086]

Yep, so just add the while loop to say

 

while there is info in the query results echo the username