Matthew Nock wrote:
Hi all,
I am currently building a site for a cinema to display session times, film synopsis' etc...
I have built the database as follows:
TABLE: film_detail
FilmID
FilmName
FilmRunTime
FilmRating
FilmSynopsis
etc...
TABLE session_data
session_ID
session_filmID
What does your SQL look like? I would say make sure you use UNIQUE if that
doesn't mess up your implementation ... also, some code snippets would help
if you need assistance.
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc