IN query

[nikko50]

Did I do the below right. I get successful query but no records come up?
$string="1,2,3,4";
$get=SELECT corpAddress.id
from corpAddress
WHERE corpAddress.id IN ($string);

[maxpup979]

you probably want to put get in quotes...ie:

$get="select corpaddress.id  from corpAddress WHERE corpAddress.id IN ($string)";

but the code seems to work for me, assuming that I have matching values for 1,2,3 or 4 in the table