Database vs static page 
Autor: Robert A.
Visitado 1146,
Followers 1,
Compartido 0
Hello, this is my first post here, so I hope I'm asking the right question in the right place.
I am developing a website to replace a current site that I have on Shopify. I am trying to create a simple catalog site - no selling of our eBooks, just listing them so that prospective customers can see some details before being led to Amazon to buy.
All is going well - although the learning curve is steep.
What I want to do is have the page at http://winghigh2020.co.uk/--science-fiction.html list it's content from a database and be able to have the rows be sorted by a criteria which the user would select (e.g. Author, Release Date, etc.) - is that possible?
Thanks, Robert.
Publicado en
Hello Robert
X5 is not a databse tool.
But you could maybe use the blog for your purpose. The bloag can be selected on categories and tags and you can for each post have images and you could also have a link that directs to the specific item on amazon.
Try experimenting with the blog and then post any questions here. Maybe other users have better suggestions.
For your need then maybe a database tool as AppGini will be a good solution. It is easy to integrate with X5.
You can see an example here : http://bramminginfo.dk/oversigt.html
You would need a table with the books and then some extra tables with categories and writers.
You can then select on writer, and/or category and also make a full-text search and you can sort all columns.
You can have a table view and a detail view, or you can have the table-view and the detail view in one form. You can then click on a record in the table and then see the detail information immediately to the right of the table.
I have a ( not very good ) example here : http://eksempelsite.dk/biler/Biler_view.php
If you want to know some more about the database solution then you can use the contact form here :
http://bramminginfo.dk/kontakt.html
Depends on how many items in total you have.... The menu system can be "by author", "by date", etc
If you don't have a lot of items to list, then look at abthermal.com to see the "Products" menu and then imagine the products being Author/Date, etc This menu system serves 250 products in about a dozen groupings. Then notice other menu items called Applications and Materials, which could be the same products but listed by another classification, such as genre, language, country, etc
Adrian