--- Jochem Maas <[EMAIL PROTECTED]> wrote:
> > if (count($inds) > 0 AND is_array($inds)) { > > $ind = "'".implode("','", $inds)."'"; > > } > > looks like you want to do a select statement with > $ind in the form of > "SELECT * FROM yourtable WHERE yourfield IN ($inds)" > Adding the IN clause did not help in any way. What I've been able to get so far is only the first record returned from the database (even though 2 exists) Using this result set it is picking up the correct user records: $query_rsLPINDS = sprintf("SELECT LurkProfiles_Industries.ProfileID, LurkProfiles_Industries.IndID, LurkerProfiles.ProfileID FROM LurkProfiles_Industries INNER JOIN LurkerProfiles ON (LurkProfiles_Industries.ProfileID = LurkerProfiles.ProfileID) INNER JOIN SignUp ON (LurkerProfiles.LurkID = SignUp.SignUpID) INNER JOIN StaIndTypes ON LurkProfiles_Industries.IndID = StaIndTypes.CareerIDs) WHERE LurkerProfiles.ProfileID = %s and LurkID = %s and hash = '%s'", $colname__rsLPINDS,$colname2__rsLPINDS,$colname3__rsLPINDS); I've created the variable for IndID like this : $IndID = $rsLPINDS->Fields('IndID'); which when I do a print_r($IndID), prints out the first record. So at this point I'm trying to figure out what I need to make $IndID an array. Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php