amaze
Posts: 10
|
| Posted: 05/21/2004, 9:11 AM |
|
A client wants to add class information pages to his site using CCS, PHP and MySQL
We've created the following Innodb table: class_information with these fields: class_title, class_description, class_duration, class_credits This works fine in CCS.
Now the client would now like to add class_location field and available date(s) field class_start_date and class_end_date. There will only be 6 cities and these will not changes. Class titles will not change either. The client would like to be able to select a class title and add and remove location and start and end dates using pop calendar feature.
And finally have a page which lets user select a class title with a listbox and see what locations and dates are available for that particular course.
How do I do I best accomplish this?
|
 |
 |
amaze
Posts: 10
|
| Posted: 05/22/2004, 6:33 AM |
|
Anyone... anyone... anyone at all?
|
|
|
|
DaveRexel
Posts: 50
|
| Posted: 05/23/2004, 8:51 AM |
|
::
RE : add class_location field and available date(s) field class_start_date and class_end_date.
using standard SQL to alter your table you shoud be able to insert your fields (use a copy of yor table for testing)
CCS can now insert components based on the new structure
http://www.google.se/search?q=innodb+table+add+column
_________________
/Dave
RexDesign CodeCharge Studio Tutorials
http://rexdesign.com/ccs/ |
|
|
|
|
