Right i made a previous thread earlier but seems no-one could help me or be bothered lol. I have designed the database which i think will work but i have few questions. If you look at this part of my website: Series Part of the site Episode part Right heres my table for the seasons Season table: id (primary key) season_number And heres the table for episodes episodes table: id (primary key) season_id number name summary link Right if you look at my first link im just wandering is once ive created the site would the episodes come out underneath the right season, like im showing you on the first link. Also secondly, once i have that bit working how would it work once someone has pressed the episode link it then goes to the player and plays that video. Can people please help me out, not sure its gonna work or am i missing some fields or missing a table or something. Sorry to be a pain im new to this
or are they both fine, and its done via the php coding on how its displayed, and some sort of relationship between tables which i dont quite understand, but still very unsure on second question
anyone know why i may be getting this? Warning: mysql_connect() [function.mysql-connect]: Host 'box.bluazn.net' is not allowed to connect to this MySQL server in /home/getheroe/public_html/admin/addseason.php on line 7 Unable to connect to database