Re: help with my stored procedure

[Peter Brawley]

> i need build an stored procedure

What problem do you hope to solve by tutting this code in a stored procedure?

As for the code, max(id) is not a reliable indicator of the id assigned on your insert. Another insert by another user may have intervened. Read about last_insert_id(), and use it instead.

And, keeping a comma-separated list of userIDs in a column is a terrible idea. It breaks a cardinal rule, in fact the first rule of relational databases: one cell, one value.

So before you go any further, read about relational databases, and about database design.