Hello everyone!
I've been thinking to design a web-based database (in DB2 and PHP) for my father's company, but I need some help because I don't know where to start.


  • The database will be used to store Microsoft Office's files (Word, Excel, Powerpoint, Publisher) and Adobe files (Indesign, PageMaker, and Photoshop).
  • The table will contain these fields:
    1. ProductCode (Example: IPS50LM) - This is used for the recognize the type of product
    2. FileName (Example: IPS50LM_Brochure) - Self Explanatory
    3. Size - Self Explanatory
    4. Type (Example: Microsoft Word)- Self Explanatory
    5. Date Created - Self Explanatory
    6. Last Modified - Self Explanatory
    7. File Path (Example: C:\MyDoc\IPS50LM\IPS50LM_Brochure.doc) - The path for the file.
    8. FileNotes (Example: Brochure for Client no.1) - Self-Notes

[*] The Features:

  1. Insert
  2. Delete
  3. Update
  4. Search
  5. Open Files (By double-clicking on the entry and it will open the appropriate program for the file type.)

Now the biggest problem is: How am I supposed to make the Windows OS opens the appropriate program for the double-clicked file?
Can anyone help me?

Thank you in advance!

Best Regards,

PS: I am a complete newbie on Database.

10 Years
Discussion Span
Last Post by fatihpiristine

design your database first and structure
primary keys, foreign keys, ids, relations between tables,
then user interface "web forms"...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.