Hello all!
I am having trouble with a mysql problem.
I'm trying to build a forum like WebX. It's sort of like the Prattle model, but I've got a scheme where I need to auto-create a table for each topic's posts in the database.
I've got a naming scheme in mind...each topic will get a table for their posts with a name like "zposts1". The problem I'm having is coming up with a way to create a table with this scheme and "auto-increment" the name so that the next table created will be named "zposts2".
I'm starting them with "z" so that these posts will be at the bottom of my list of tables in myphpadmin.
I'm sort of a newbie still. Any help from the gurus in this forum would be greatly appreciated.
Thanks in Advance.
Rich
I am having trouble with a mysql problem.
I'm trying to build a forum like WebX. It's sort of like the Prattle model, but I've got a scheme where I need to auto-create a table for each topic's posts in the database.
I've got a naming scheme in mind...each topic will get a table for their posts with a name like "zposts1". The problem I'm having is coming up with a way to create a table with this scheme and "auto-increment" the name so that the next table created will be named "zposts2".
I'm starting them with "z" so that these posts will be at the bottom of my list of tables in myphpadmin.
I'm sort of a newbie still. Any help from the gurus in this forum would be greatly appreciated.
Thanks in Advance.
Rich