Thread

Does anyone know of a supporters module that will store a list of peoples names for a project that I can display in EE?

If there is nothing I was thinking of writing my first module that would create a table with an index on a project name that I can use to pull back search results quickly…

Cheers

Hi Tabboy,

Can you please share some more details. it seems something interesting to me.

Thanks,

Basically I am trying to replicate what they have on this site. The following page just displays a list of supporters names

http://www.pozible.com/index.php/archive/index/6118/supports/0/0#info

There is a list of supporters for a project.  I need to find a plugin or write something that creates a database table with a list of supporters that is indexed on the project name for fast searching.

Hi Tabboy,

I thinks, supporters would be website members supporting one or more than one projects. There will already be a database table managing project’s data.

So you need to create another table like :

“project_supporter”
| id (autoincrement) | project_id | member_id |

with this table you can find supporters on a particular project and number of projects supported by a member.

Thanks,

Yes I know how to create tables and so forth in mySQL my question is does a module or plugin already exist to do a similar thing to what I am proposing.  I don’t want to reinvent the wheel 😉

Ok I have been successful in storing the data in a table called project_supporters.  My next question is how do I display this data in a formatted way similar to using the channel tag {exp:channel:entries} ?

Ok I am answering my own questions here I just found this in the documentation

{exp:query sql="SELECT screen_name, email, location FROM exp_members WHERE group_id = '1'"}

{screen_name}
{email}
{location}

{/exp:query}