I am building a page where I am allowing users to add other users to a friends list.

What is the best way to go about this?

Is there a way to append a single database field like a list

friend1, friend2, friend3 etc

when a user is added and then be able to get back at the values? It needs to act like an array where one field can contain many values!

Any other suggestions are greatly welcomed.

Thanks




Edited by - rawveg on 07/23/2001 15:38:54

There's no reason at all why you can't do this. I quite often do it myself as it is a very flexible method. However, one caveat is that you will probably need to define the database field in question as a BLOB (or Binary Large Object) otherwise if the friends list of only one person is huge you'll soon find that it won't work !

There are various ways to turn an array into a comma separated list of values and back again. It really depends on the language that you are using to develop in.

For example in PHP you could do the following :-

To convert an array to a comma-separated list :-

$commaList=implode(",",$friendsArray);

and to convert it back :-

$friendsArray=explode(",",$commaList);

Hope this helps

Tim Green
Webmaster
www.rawveg.org (Coming Soon)

Edited by - rawveg on 07/20/2001 12:17:30

Edited by - rawveg on 07/20/2001 12:18:45

Thanks for the reply.

I am coding the page in VB Script - do you know how I would convert a comma list?

Thanks

Thread moved back to UltraDev forum

Tim Green
Webmaster
www.rawveg.org (Coming Soon)