Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Returning rows one by one

Status
Not open for further replies.

DaSe

Programmer
Feb 14, 2008
149
GB
Hi guys...
I have something to ask you if you don't mind. A bit of explanation: I have a table with 'friend_id' field and 2 other fields which stores an added user id. This added user id I am trying to match with users id of the 'members' FOLDER into which user keep their jpg photos. It's pretty difficult to me and I came up with this way: I am being returned a row from friend_id and this id I try to match with directory of the members folder. But the problem is that when I use concatenation it returns all ids in one go without any split. Something like: 20293190139 whereas what I need to is: 202 then 931 then 19 etc. I really don't know what would be the best way of doing it ? I mean matching users pics to their ids from the table. Regards.


 
Thank you. The problem has been sorted out already.

P.S. I didn't join the ids together. They get inserted separately - concatenation of this field makes them implode.

Regards.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top