[RESOLVED] How to select more than one id in a table?

Scooby_Doo

Ok, I'm rebuilding a site called PickOfTheLitterPuppies That my Uncle owns, and converting it to php. Any way back on subject how would I select multible ids in a table.

Here's a video of me trying to explain.
http://www.youtube.com/watch?v=6bEaVX5h7JY

I also wander is it possible to select all the ids except for (in this case) 14... so if my mom deletes a breed it won't display an error because that breed doesn't exist.

Here's an idea of my table.
(I don't want 14 because it is where the sold dogs go.)
It should be where the attached files go.

roscor

why not explode the array,

$pupies ="4,9,10,11,12,13,14"
$pupiesArray= explode(",", $pupies);
$total_pupies=count($pupiesArray);

for($item=0;$item<count($pupiesArray);$item++){
mysql_connect($host,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table WHERE id IN ('$pupiesArray[$item]')" ;
$result=mysql_query($query);
}

or something similar, untested

Scooby_Doo

Umm... Thanks for the code I played with it and changed it about 5 different ways but got nothing. Thanks for helping. If you have any other ideas it would be greatly appreciated.

laserlight

I noticed that you were working with:

$id = '4, 9, 10, 11, 12, 13,';

All you need to do is remove the trailing comma, then you can write:

$result = mysql_query("SELECT * FROM puppies WHERE breedid IN ($id)");

Scooby_Doo

Thank you so much Laserlight. Worked the first time. I didn't know about that IN piece. I'm surprised with something else every time I post a message here.