[RESOLVED] Showing Time>>cinema

wounded_soul

Greeting 🙂
hope you're fine
i have question
always my instructor said wrong wrong
look
if i have one movie ->shwoing in more than one cinemaHall
where can i put the shwoingTime???
i'm waiting for any response

bradgrafelman

I would put it out in the lobby where customers are buying tickets. Perhaps even outside the cinema so people can see the showing times as they drive/walk by.

wounded_soul

you means creat new entity and the PK ->sequence key
how out side

wounded_soul

humm.. can u explain more

Bonesnap

I...

...what?

😕

wounded_soul

Bonesnap;10998850 wrote:
I...

...what?

😕

explain in more details ,i dn't got the idea :$

cretaceous

Brad Grafleman is making a joke - it made me laugh

you asked how to show the time at a cinema
he told you of a tried and tested method that has been in use for maybe 100 years
(or you could try this new thing called the internet to show movie times - seems to work quite well sometimes)

what does your question have to do with PHP or code ?

wounded_soul

i meant in the ERD

cretaceous

what is ERD?

wounded_soul

Entity Relationship Diagram

cretaceous

question is too open ended - we don't know how your tables are set up
sounds like you need to add another table for movie times..
but it all depends what you have now

wounded_soul

ok
i have 3 tables (Actor,movie,cinemaHall)
one movie can display in more than one cinemaHall
my question about the timeshowing

Derokorian

YOu need a another table, maybe called showtimes, which has the possibly 3 columns: unique ID of the movie, unique ID of the cinemaHall, and a datetime of the showing.

wounded_soul

i got it
thnk u in advance
cretaceous>>laugh as u want dear

wounded_soul

wounded soul;10999227 wrote:
i got it
thnk u in advance
cretaceous>>laugh as u want dear

cretaceous
I'm kidding with you
Yes ,it was my fault I did not explain clearly what I want

cretaceous

ok, so I'm easily offended, dearie..
(anyway now I know what ERD is)
you might want to work on the idea of another entity (table) for the "show"

that way the "show" could contain two or more movies and adverts as well - it's one level more complex but more flexible

wounded_soul

cretaceous;10999268 wrote:
ok, so I'm easily offended, dearie..
(anyway now I know what ERD is)
you might want to work on the idea of another entity (table) for the "show"

that way the "show" could contain two or more movies and adverts as well - it's one level more complex but more flexible

i'm happy for your response
yes , i will create new entity (showtime)contain (Date,start-time,end-time),and then inherit the primary key of movie(movie_id)also the primayy key of cinemaHall(hall_No),it complex but more flexible as u said,