php mysql multiple result

Question

My php code:

$sql = mysql_query("SELECT * FROM users WHERE user_id IN (1,3)");
    while($row = mysql_fetch_array($sql)) {
    echo $row['name'];
    }

It returns as last result set, which is from user_id = 3 and does not include the result of user_id = 1 but when i print_r($row) all the result is there, is there anything amiss?

Thanks

several examples of looping exist on stack: here's one stackoverflow.com/questions/3931219/… — xQbert
– xQbert, Commented Jan 1, 2012 at 13:11
Does user_id=1 actually have a name set? Are you sure its not printing an empty string. — Toby Allen
– Toby Allen, Commented Jan 1, 2012 at 13:40
@tereško - Many would not consider that a valid reason for a downvote. — Toby Allen
– Toby Allen, Commented Jan 1, 2012 at 13:41
@tereško Allow me to politely disagree. mysql_ functions are still widely used, and as far as I know, most of them are not even close to being deprecated. Not only is your downvote absurd, considering the approach is valid, you are giving misleading information. I had to +1 this. Happy new year to you and your loved ones, cheers. — Stephane Gosselin
– Stephane Gosselin, Commented Jan 1, 2012 at 13:46

KingCrunch · Accepted Answer · 2012-01-01 13:30:08Z

3

If you want to access elements of array by attribute names use this:

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
   printf("ID: %s  Name: %s", $row["id"], $row["name"]);
}

else just use numeric instead of associative keys

as

echo $row[0]

edited Jan 1, 2012 at 13:30

KingCrunch

133k22 gold badges158 silver badges174 bronze badges

answered Jan 1, 2012 at 13:12

Rajat Singhal

11.3k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Mior Over a year ago

Note you can also use mysql_fetch_assoc instead.

Collectives™ on Stack Overflow

php mysql multiple result

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related