Get Count (total)

[kpowning]

I have a table in my database that uses the field 'members' here when a member subscribes to a certain event their name is added to this field and is seperated from others in this same field using a comma thus looking like this in the database:

members

bob,mikey,jack

How can I make an sql command to count the total of members listed in this field. So for this instance the output for the count of field members = 3

PLEASE HELP ME.

[kpowning]

IS THERE NO WAY THIS CAN BE DONE??
PLEASE HELP

[devinemke]

this is bad design. you should have 3 tables:
members
events
links (links together members and events using primary key fields from the other 2 tables).
you should do a google serach for many-to-many data relationships.

but anyway. if you must do this the old way:

$string = 'bob,mikey,jack';
$count = count(explode(',', $string));
echo $count; // outputs 3