[Jafo232]

Originally Posted by Boofo

I just noticed the line in the first post that says "the last version was put together rather poorly". I hope you weren't referring to Chen's version.

I was..

The last version as I recall was set up where each user had a row in the vbnotes table. All of the users messages were in ONE row, parsed by something like |||. In otherwords:

$usernotes = preg_split("/\|\|\|/",$row);

I cannot remember the exact delimiter but that was basically how it went. Sorry, but I think that is a poor design. Each note should have its own row. That is pretty much the point of using SQL. Chen was using the row as if it were a flat file.

It has been a bit since I worked on it, but I recall there were other issues as well.