I've been working on this thing for the past few days
and thought i'd share it all with you.

i've posted a demo up:  you cannot delete rows,
but you can add and edit them
http://furt.com/php/dbedit/

to get the code: http://furt.com/php/dbedit_b1.zip
(please read specs.php for lots of information on how
the thing is layed out and how it all fits together)

------ 

The key thing that separates my script from the other
database manager scripts is that mine supports a sort
of "foreign key" referencing between tables.

for example:
if you have two tables, main_table and tid_table

assume main_table looks like this:
id  tid  description
--  ---  -----------------
1   2,3  "This is something"

and tid_table looks like this:
id  Foo
--  ---
1   "Bar"
2   "Baz"
3   "Bone"

after putting a few options into the specs file, 
when you view the main_table, in place of the tid "2,3"
the script will look up the "real" value of "2,3" and
replace it with "Baz, Bone".


Basically, i needed something like this becuase the
company i work for wants to store porfolio information
in a large database... a single entry can have multiple
authours, multiple clients, etc. etc... and so i 
figured instead of having to keep typing in "Scott"
for all the things that i authour, why not have the
script put a drop-down combo box with a list of all
authours, when i add a record to main_table??

enough of me babbling.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to