Hi, I've got the following tables set up:
tbdPages:
- ID
- fldTitle
- fldContent
tbdLookupVersion
- ID
- fldVersionID
tbdVersion
- ID
- fldPageID
- fldVersionID
Basically the pages table is the content for the website and the version table stores information on which page is for which version. This allows me to create a whole set of new pages for a different version. I have setup a global file with a variable vbgvntVersionID which is the id of the current version running on the site. I have the admin panel setup perfectly but what I need to do is setup an sql query so that if you pass a page id in via the querystring (on the front end of the site) it returns a page (if it exists - ie applies to the current version of the website and has the same id as the one passed in).
I'd appreciate if someone could help. Thanks
tbdPages:
- ID
- fldTitle
- fldContent
tbdLookupVersion
- ID
- fldVersionID
tbdVersion
- ID
- fldPageID
- fldVersionID
Basically the pages table is the content for the website and the version table stores information on which page is for which version. This allows me to create a whole set of new pages for a different version. I have setup a global file with a variable vbgvntVersionID which is the id of the current version running on the site. I have the admin panel setup perfectly but what I need to do is setup an sql query so that if you pass a page id in via the querystring (on the front end of the site) it returns a page (if it exists - ie applies to the current version of the website and has the same id as the one passed in).
I'd appreciate if someone could help. Thanks