add/remove table data

[svoeric]

OK, I've made up a mod that has a few lines of info stored in a DB table, 4 columns, and variable rows.

I've got a VB options page setup for other options of the hack, but I can't seem to find a way to add/remove lines from this table. With all the hackability in VB, I'd be surprised if there's not a way to do it, short of writing another php script, which I can do, not a big deal, just wondering if there's a better, more 'integrated' way to do it.

Thanks

[Lynne]

I'm not sure I understand you. If you want to add or remove lines from a table, you need to use a query of some sort.

[svoeric]

I know how to add and remove myself...
What I'm asking is there some interface already built, to all an moderator to add a row, or delete a row...
or do I need to build my own? I was hoping there was something already built in VB

Basically show the data that is already there, with a delete/edit button
and a blank line (4 fields) to allow the user to add a new row.

[svoeric]

naaa -- you're not getting what I'm saying...

I've added a box at the top of my form, that has links to other pages on my website.
Instead of a template mod, that has to be re-done every time there's an upgrade, I decided to create a table, and add those links into it (VERY similar to the social bookmarking setup)
the table has name,link,order, and active columns. might add a spot for a image later, but that's later....

My vb options page I created for this has options like where to put the box on the page, how many links to put per line, what the name in the top left of the box is......

What I need is a way for someone other than me (as in non-technical mods, cause I'll just lot into mysql and add them) to have an interface where they can see each link in the table, and be able to add new ones, or delete/edit existing ones. I can probably mod the bookmarking.php file to do this in about 5 minutes, BUT, I was wondering if there's a way to do this without adding an additional php page.

Just seems like VB would have something built in for this already ?

[Lynne]

Ack! I must have mixed up my tabs cuz that was supposed to be a reply to another thread. (I deleted it since it's totally unrelated to this thread.)

I don't know of any built-in vb way to do what you want. I think you just need to modify the page to do what you want.

[Dismounted]

There is no "common interface" to do this, that is because every script will be different and it is impractical to do so.