Tagging Notes

[Pedestrian]

I'm very new to php/mysql so I apologize if this question is not top-notch:

 

I'm working on a computer conferencing environment, and so far, I can let users post notes. But I want them to be able to tag notes.

 

Do you have any resources I could look into? I want to read up on how I could do something like that - tag notes that is.

 

I'm sorry for asking such a primitive question! But I thought this forum might help me get started.

~P

[nbarone]

store it in the database 

[p2grace]

Are you familiar with mysql?

[vineld]

I suppose the notes are already stored in a database?

 

This is one way to do it:

 

1. Create two new tables in the database, one containing the tags themselves and one containing the relations between tags and notes.

 

2. Add for example a text area to the note form where the users can enter the tags separated by new row, comma or whatever you choose.

 

3. Collect and separate the tags and insert them into the database. You will probably want to add some validation here (max length, max number of tags etc.).