blasto Posted December 15, 2007 Share Posted December 15, 2007 Hi - firstly apologies if I have missed an obvious contribution or post - I have searched far and wide. I am using OSC to build a booking system for educational classes. There are several 'attributes' that are critical to learners that I need to show as field in the product listing tables and and the product information pages. Using attributes doesn't seem to work for me in this case. So you can see what I'm trying to do, fields I need are: Date Venue Time Academic level I'm assuming I'll need to add fields to the database and then modify some php files, but would appreciate some guidance. I am quite new to mysql and php, but finding my way round okay. Could anyone either provide a quick 'how to' or point me to relevant post or contributions. Thanks in advance Link to comment Share on other sites More sharing options...
photofxplus Posted December 16, 2007 Share Posted December 16, 2007 DateVenue Time Academic level I'm assuming I'll need to add fields to the database and then modify some php files Yes you will need to add some fields to the database. Easy enough -- you can even draw these values back and display on any page using the customer_id as an identfier -- with a simple query -- Question is how will you update these new fields to reflect correct values?? You will need an input area.. Unless you plan on manually updateing the db yourself. Lloyd Link to comment Share on other sites More sharing options...
blasto Posted December 16, 2007 Author Share Posted December 16, 2007 Thanks for the swift reply Lloyd. That's where I'm stuck - I'd like to be able to add these attributes in the admin section and then have them appear in the product info, but more importantly, appear in the product listing view of the index page, so that visitors can sort by these new fields, search them etc. Link to comment Share on other sites More sharing options...
blasto Posted December 19, 2007 Author Share Posted December 19, 2007 I have amended the language files to use 'model' as a venue field, but I still need a 'date' column that will show up correctly on the product listing table in index.php. Has anyone managed to add a column to this table that is searchable and sortable? I have amended my database and can now add dates at admin, but the product listing table is tricky to figure out. I don't use the 'available from' feature so could subvert that, but its just getting the table to work correctly... Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.