advice needed for project please.

[4thstar]

Hello all.
I hope everyone had a great easter :)

ok i find myself at a loss as to where to start on an idea i have had, i have AMP6 and know the basics, i also have the datagrid plugin which seems to me a sutable tool to use for my needs..

anyone thats used Arelis will know what i am after creating, Arelis is a links management system that has loads of features, for my needs i require a much more simple version.

i create websites for people, some ask for links management systems where by they can add and remove their own links.

i would like to create an application where they can manage their own links, for some reason i am sitting here and cant think where to start.........

the aim / feature list as i see it is this.....

to create categories.
to create sub-categories of possibly unlimited depth.
to be able to add links by selecting a category, entering a title, link and description.

creating a set of html pages based on the category structure that contains the link details.

ftp the pages to the server..

Creating a datagrid for the links is ok i think..but i cant get my head around how to manage the category section alowing easy adding or removing of categories..

I am a basic AMP6 user looking for ideas or suggestions on how i can proceed in this project.

if anyone has the time to help and advise it would be great, i am sitting looking at a blank project and looking very confused :)

Many thanks in advance.
Kind Regards
Carl

[holtgrewe]

Personally I'd store the information in a SQLite database, using a coding structure for the sub-categories. (similar to versioning) giving yourself plenty of room for expansion (unlimited depth...?)

The gui presentation using datagrid or anything else with unlimited depth is going to be a fairly daunting task.

I think a database indexing structure would definately be the correct approach. Maybe one of the db gurus that frequent this forum can give you some pointers.

[4thstar]

Many thanks..

yep i thought i could use the datagrid plugin for this, it also seemed that some kind of database was needed, i know nothing as yet about the use of sql so i will read up on it and try and grab a few examples.

i sat here for a while and played with the tree object adding and removing, renaming entries, it looked like it was a possible way of creating the categories..

i did say unlimited depth for categories but think that going 3 deep would be plenty, i suppose though that creating a program that goes 3 deep and one that goes 6 or 10 deep isnt going to be that different.

I am past the "Hello world" coding but way off some of the people on this forum so i think my idea may well take a long long time to happen..

Many thanks again for your input and your time.

Kind Regards
Carl