This content has been marked as final. Show 5 replies
> What would be the best way to display results like this from a database?
Why would you need Word or PDF files? Just store the text in the DB and the
pictures on the server.
This page is all driven from a database:
It is not really a "Three Column" newspaper type layout, but since each part
is in a table cell, each cell could contain as much information as you
wanted. It could easily be three columns instead of four.
That site is all Cold Fusion driven, but something similar could be done
with any data driven site.
I can provide the CF code if it would be of use.
Thanks for the replies guys, one more question if I may - What would be the best way to store the Detail information ie the content which people will read? should I do it with a sinlge database field called "Details" or have two or three detail fields - one for each column? Im just trying to work out the best method to enter and display the details.
Generally, it is almost always better to follow the rule of normalization
for any database design at least to the third normal form. There are
sometimes very good reasons to break the normalization rules, but it is
better to know why you are breaking the rules when you do, and have a good
I don't know exactly what you are doing, but would recommend you only have
one detail field per row of data in your database table.
If you tell us more about the nature of all the data you are keeping track
of, someone can help you with your structure and layout.
What are your current data structures?
"~Billy~" <email@example.com> wrote in message
> Thanks for the replies guys, one more question if I may - What would be
> best way to store the Detail information ie the content which people will
> should I do it with a sinlge database field called "Details" or have two
> three detail fields - one for each column? ust trying to work out the best
> method to enter and display the details.
Im ok with designing the database its how to get a "newsletter" style results page in dreamweaver. I am ok with getting the images to match the results, its the 3 column layout I need to work on. When you enter text into a database field say from a form the text will be standard text ie with no bold/italic formatting etc.
Im thinking that creating PDF documents and using Zoom to index them would be simpler and just as effective, I just wanted to try and avoid having hundreds of PDF documents, I wanted the information to be stored in a database if possible.
Say 2 tables, one-to-many, Primary key called Location_id
Table_1 - Location_id, Location_name
Table_2 - Location_id, County, Details, Images
Then the user can search by location name, county, details (key words).
One location may have more than one set of details eg the county of Essex may have 15 places of interest (details).