[SOLVED] My sql select multiple multiple rows

[rcorlew]

Okay, I am having problems with querying my db by multiple id(s). To clarify more, I am trying to match the id of each row to an array that has been formatted into a string seperated by commas. Here is my code to see if anyone can help.

 

<?php
$str = "1,2,3,4";

$query = "SELECT * FROM table WHERE p_id = IN($str)";
?>

[sps]

What type of column is p_id?  If it is not an INT then you need each item in your in() clause enclosed in quotes.  If it is an INT column then it should work as written, does it give an error or just return no rows?

[rcorlew]

It is a tinint column, it returns only the first result, the result can be different based on the first number in the string, is there something like CHAR() or smething I can try

[jitesh]

$query = "SELECT * FROM table WHERE p_id  IN (".$str.")";

 

[rcorlew]

Mucho thanks, the '=' kept loosing me!