Ad:

PHP Discussion Thread
Marked Solved
Views: 2090

May 25th, 2008

Select where clause with "IN"

Expand Post »

Hi

I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.

I am not having any success getting this to work.
Any suggestions?

Note:I am using Mysql database, apache, linux/Windows

PHP Syntax (Toggle Plain Text)
[php]
<?
//array with list of friends to display
$friend = array('1','2','3','4');
 
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN '$friend'";
$result = mysqli_query($mysqli, $query);
[php]
<?
//array with list of friends to display
$friend = array('1','2','3','4');

$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN '$friend'";
$result = mysqli_query($mysqli, $query);

[/php]

Similar Threads

Can someone help me with a complicated search parameters in ASP.NET
PHP Mysql "Where" statement in PHP
Syntax error in "like" in sql statement in ASP.NET

assgar

Reputation Points: 24

Solved Threads: 0

Junior Poster in Training

Offline

89 posts
since Oct 2006

Permalink

May 26th, 2008

Re: Select where clause with "IN"

I'm pretty sure it has to be surrounded with quotes, ie.,

sql Syntax (Toggle Plain Text)
SELECT first,last, number FROM friend WHERE id IN ('1','2','3','4')
SELECT first,last, number from friend WHERE id IN ('1','2','3','4')

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

Permalink

May 26th, 2008

Re: Select where clause with "IN"

Click to Expand / Collapse Quote originally posted by assgar ...

Hi

I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.

I am not having any success getting this to work.
Any suggestions?

Note:I am using Mysql database, apache, linux/Windows
PHP Syntax (Toggle Plain Text)
[php]
<?
//array with list of friends to display
$friend = array('1','2','3','4');
 
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN '$friend'";
$result = mysqli_query($mysqli, $query);
[php] <? //array with list of friends to display $friend = array('1','2','3','4'); $query = "SELECT first, last, number FROM friend WHERE id IN '$friend'"; $result = mysqli_query($mysqli, $query);
[/php]

You can't do it this way because $friend is an array. So, when you execute the query, it will be,

php Syntax (Toggle Plain Text)
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN 'array'";
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN 'array'";

which is wrong. You can use implode function to join the array.
$friend_implode = implode(",",$friend); Then use it in your query.

php Syntax (Toggle Plain Text)
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN (".$friend_implode.")";
$query = "SELECT first, last, number
	  FROM friend
	  WHERE id IN (".$friend_implode.")";

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

May 30th, 2008

Re: Select where clause with "IN"

Thanks it worked.

assgar

Reputation Points: 24

Solved Threads: 0

Junior Poster in Training

Offline

89 posts
since Oct 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: how to reset md5 encrypted password

Next Thread in PHP Forum Timeline: i am trying to attach a file with mail and getting following error.how can i solve?

DaniWeb Message

Cancel Changes

User Name
Password