Getting array specific data from mysql

Question

I'm trying to get data from a mysql database... but I only need results specified by an array... for example I have a database which is populated with member data: username, email etc... and another table where I store per member their contact list like... So I'm looking on a way to display member their contact list... I'm just not clear on whats the best way... any tips are welcome... for example:

$result = mysql_query("select contact_id from member_contact_list");

$contacts = array();

while ($row = mysql_fetch_array($result)){  
   $c_array[] = $row[ 'username' ];
}

$c_array = implode( ',', $existing_users );

$sql = "SELECT * FROM members WHERE id="c_array[]"";

Its a little hard to explain... I hope someone gets what I mean.

GautamD31 · Accepted Answer · 2014-03-05 06:46:56Z

2

IN will help you like

$sql = "SELECT * FROM members WHERE id IN (".$c_array.")";

Consider that $c_array is an string that consists member id imploded with ,.

edited Mar 5, 2014 at 6:46

answered Mar 4, 2014 at 12:29

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

Comments

Ravikumar Sharma · Accepted Answer · 2014-03-04 12:29:52Z

0

Use In

$sql = "SELECT * FROM members WHERE id in (".$c_array.")";

answered Mar 4, 2014 at 12:29

Ravikumar Sharma

3,7505 gold badges39 silver badges61 bronze badges

Comments

Deepak Rai · Accepted Answer · 2014-03-04 12:32:57Z

0

Using JOIN you can get the contact list of a given member:

SELECT * FROM members AS m
LEFT JOIN
contacts AS c ON (m.user_id = c.user_id)
WHERE m.user_id = 1;

JOINS are efficient then sub-queries

answered Mar 4, 2014 at 12:32

Deepak Rai

2,2113 gold badges24 silver badges39 bronze badges

Comments

Ashalynd · Accepted Answer · 2014-03-04 12:33:41Z

Strange program.

$result = mysql_query("select contact_id from member_contact_list");

$contacts = array(); //**not used anywhere else in the given code**

while ($row = mysql_fetch_array($result)){  
   $c_array[] = $row[ 'username' ]; //**was that supposed to be $contacts?**
   //** also was this the right version: $contacts = $row['id']; ??? **//
}

$c_array = implode( ',', $existing_users ); 
//** where was $existing_users defined? Was that supposed to be $contacts, too?**

$sql = "SELECT * FROM members WHERE id="c_array[]"";
//** correct version is indeed with the clause "WHERE id IN (".$c_array.")" **;

//** last but not least, the $c_array seems to be the collection of user names, not user ids. **//

Collectives™ on Stack Overflow

Getting array specific data from mysql

4 Answers 4

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Related