I finally understand. Maybe episode titles might be a possibility one day, but for now there's too many things to sort out already.

It would take more space if the title was stored each time in the vehicle page instead of having it once in a separate table.
There is often more than one vehicle in a episode.
It is not only for the space taken, but also to keep the database structure somewhat clean and coherent (it is already not perfect currently).

Yes, makes take space. And I could have a make list separated to not have to reenter it each time. Same for models actually. This is one of the improvements that I may do one day.

For info:

cars table = 7.9 MB
comments table = 34.4 MB
movies table = 1.5 MB
users table = 0.3 MB

total = 44.1 MB
max allowed = 50 MB

If the database reaches the max allowed size, OVH (where the site is hosted) will put it on another server, which is slower.
I could split the database and put comments & users in a separate database, but some day we will reach that limit.

Now I understand, it would take up space to enter everything manually. But would it take up that much space? Every time you enter a new car, you have to type in model names.

If a computer can do something in one millisecond and save space of the database, why do you want to do it yourself manually and waste database space?

Why should the site have to be programmed to automatically sort it out? The thing is each different episode title would have to be typed in at least once, and there won't be that many different vehicles per episode, you could just copy the title once you've typed it and paste it into the field in the admin section for each vehicle on that episode, it wouldn't take that long at all. And it's not like I'm excepting you to sort it out for every TV series, you don't have to do any of them, other admins will be free to do it if they want to (I'll do the ones for my favourite TV shows), just think of it as a work-in-progress.

- take too much space in the database
- take too much time for entering
why do you want to type the title each time you add a vehicle rather than having to type the title once, and have the site find it when you type the episode number?

I didn't say that the whole thing was a bad idea, I just said that if I add it, it would be a more automated solution. Of course it would be a little more work to add it to the site than just adding a new field, but it would work better too.

I know very little about programming. But I'm just wondering, could someone just enter the name of the episode in a new field in the same way you enter information in the Extra Info field so that the site wouldn't have to search for anything, it would just display the letters typed in the field. Would all this be too complex or take up too much space?

We need to draw this discussion to a close, do you think the whole thing is a bad idea and we should forget about it?

Somewhere one the "edit movie title" page, I could add links "add episode", where you could enter number and title of each episode.

When the vehicle page is displayed, the site searches in the "movies" table the title of the movie with the number stored in the vehicle info.
It could at the same time search in the "episodes" table a title with the episode number matching the one of the vehicle info (well, actually movie number + episode number).

It is hard to try to explain with simple words such database concept actually. It sounds logical for me as I am programmer, but I guess that it is not so easy for non-programmers.

I'm sorry I'm just really confused here, where would you store all the titles so the site could automatically post them for each vehicle on the episode? Could you try explaining it again, as simply as you can? Your English is excellent, it's just on this occaission I'm not completely understanding you.

Well, I do not really see how I can explain it differently...