Jump to content

Protected files website


vchris
 Share

Recommended Posts

You need three tables:documentdoc_IDdoc_namedoc_description...categorycat_IDcat_namecat_description...document_x_categorydxc_IDdxc_doc_IDdxc_cat_ID...

<cfquery name="qryGetDocs" datasource="#dbname#" username="#dbuser#" password="#dbpw#">SELECT doc_id, doc_name, doc_description, cat_nameFROM documentJOIN document_x_category ON dxc_doc_ID = doc_IDJOIN category ON cat_id = dxc_cat_idWHERE doc_id = #val(url.doc_ID)#ORDER BY cat_name</cfquery>...<hr><cfoutput query="qryGetDocs" group="cat_name"><strong>#cat_name#</strong><br /><cfoutput>#doc_name# <em>(#doc_ID#)</em><br />#doc_description#<br /><br /></cfoutput><hr></cfoutput>

That should do it . . .

Link to comment
Share on other sites

  • Replies 55
  • Created
  • Last Reply

Top Posters In This Topic

I'm done with the app! They're just gonna review it. I might have to add or change a couple things here and there but the hard work is done.I'm pretty happy about it.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×
×
  • Create New...