Help with DB Structure, vOD site

I have a video on demand style site that hosts series of videos under different modules. However with the way I have designed the database it is proving to be very slow. I have asked this question before and someone suggested indexing, but i cannot seem to get my head around it. But I would like someone to help with the structure of the database here to see if it can be improved. The core table is Videos:

What is the difference (if any) between (null != $object) and ($object != null) when using PHP?

I am used to Java and therefore always think conditions are interpreted from left to right, i.e. there is a vital difference in null != $obj and $obj != null

What is the purpose of returning $this in PHP

function select($select = ‘*’) { if( is_string($select) ) { $select = explode(‘,’, $select) ; } foreach($select as $s) { $s = trim($s) ; if($s != ”) { $this->aSelect[] = $s ; } } return $this ; } In PHP, what is meant by return $this. php 3 There are many scenarios in which one might […]

Multiple Public Function inside a single Public Function?

Each step gathers data from user input. This is public function from step1. Im trying to insert the data to the database but im getting mostly clientID error.

How to Properly Make use of Codeigniter’s HMVC

I have been having problems wrapping my brain around how to properly utilize the modular extension for Codeigniter. From what I understand, modules should be entirely independent of one another so I can work on one module and not have to worry about what module my teammate is working on. I am building a frontend and a backend to my site, and am having confusion about how I should structure my applications.

Is it safe to use LAST_INSERT_ID() in a system like Point of Sale

Is it safe to use LAST_INSERT_ID() in a system using MySQL like Point Of Sale when there are multiple users using the system at the same time?

My father wants to learn PHP-MySQL to port his application. What I should do to help? [closed]

Closed 9 years ago.

Would I benefit changing from PHP to Node.js (in context) [closed]

Closed 10 years ago.

Is there any reason why I should use parentheses when calling new in PHP?

When there are no arguments, we have these two options:

What scripting languages can be embedded within HTML?

Most of scripting languages (like Pythong, Perl, etc) generates the whole HTMLfile. However, PHP code can be embedded within html codes. PHP will process only code between <?php ?> tags and ignore other lines.