Extracting values from SELECT WHERE IN query MySQL

Question

This is a follow up on minimize select queries on the same table Mysql. I did not get a full answer on how to extract the individual array values returned by the following query:

$result = mysqli_query("SELECT * FROM u_settings WHERE setting IN
 ('username', 'password','email','tag','active','version','time','warn','dis')");

How do I extract any value I want from the $result array since many rows having the same columns will be returned?

Dejan Marjanović · Accepted Answer · 2012-06-03 20:48:31Z

1

$result = mysql_query("SELECT * FROM u_settings WHERE setting IN
 ('username', 'password','email','tag','active','version','time','warn','dis')");

while($row = mysql_fetch_assoc($result))
    $settings[$row['setting']] = $row['u_settings'];

print_r($settings);

answered Jun 3, 2012 at 20:48

Dejan Marjanović

19.4k7 gold badges54 silver badges67 bronze badges

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

Comments

Jason McCreary · Accepted Answer · 2012-06-03 20:48:51Z

1

Use mysql_fetch_assoc() or mysql_fetch_array() on $result.

Note: I would encourage you to upgrade to MySQLi or PDO, instead of the now deprecated mysql_* functions.

answered Jun 3, 2012 at 20:48

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

Collectives™ on Stack Overflow

Extracting values from SELECT WHERE IN query MySQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related