List all usernames from database from id

Question

I want to list all username from database if the id exists. That code works fine in database select * from users where id IN (1,2,3,4,5).

But in php it doesn't work. My php code is

$sql = "select * from users where id IN (1,2,3,4,5)"; 
$result = mysql_query($sql); 
if ( mysql_num_rows($result) > 0 ) { 
  $row = mysql_fetch_assoc( $result );
  echo $row["username"]; 
}

This php code only list one user name. I want to list all usernames. Sorry for my bad English. Thanks.

you only fetch one row. you have to loop over your rows...... — Franz Gleichmann, Oct 19 '16 at 14:41

score 1 · Accepted Answer · answered Oct 19 '16 at 14:42

1

<?php
$sql = "select * from users where id IN (1,2,3,4,5)"; 
$result = mysql_query($sql); 
if ( mysql_num_rows($result) > 0 ) {
    while($row = mysql_fetch_assoc( $result )) {
        echo $row["username"]."\n";
    } 
}

if you only fetch once, you will only get one row - obviously. so if you want all rows, you have to fetch as long as there are rows to fetch.

answered Oct 19 '16 at 14:42

Franz Gleichmann

3,420
4
20
30

At least this one is less contentious – RiggsFolly Oct 19 '16 at 14:43
3

`mysql_*` is deprecated and closed in php 7 – devpro Oct 19 '16 at 14:44
Its a good idea to add some sort of _Stop using the `mysql_` API_ comment to your answer when the code is using `mysql_` to reduce the risk of a downvote – RiggsFolly Oct 19 '16 at 14:45
@RiggsFolly [You did...](http://stackoverflow.com/questions/40134597/list-all-username-from-database-from-id?noredirect=1#comment67539092_40134597) haha! Unless you plan on deleting it *lol* – Funk Forty Niner Oct 19 '16 at 14:46
@Fred-ii- I ment in the answer, but yea, just call me ___Mister Helpful___ – RiggsFolly Oct 19 '16 at 14:50
@RiggsFolly Fair enough *"Mister Helpful"* ;-) – Funk Forty Niner Oct 19 '16 at 14:52
Thank you guys. @franz-gleichmann your code works fine thank you. I understand I need to use mysqli. How can I change Franz's code to mysqli. sorry for my bad. – Joe J. Oct 19 '16 at 15:00

List all usernames from database from id

1 Answers1