![]() Here is the out put I get: -|įirstly this view should return more than 200 records. INNER JOIN m4l_actors ON m4l_movies.Actors = m4l_actors.ID INNER JOIN m4l_genre ON m4l_movies.Genre = m4l_genre.ID ![]() JOIN m4l_movierating ON m4l_movierating.ID = m4l_movies.Rating & I've created a View: SELECT m4l_movies.ID AS ID, ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8 ) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8 That receives input for a form which has values from a these lookup tables: CREATE TABLE `m4l_actors` ( ) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 ![]() I have one master table: CREATE TABLE `m4l_movies` ( I'm doing my first work in PHP/MySQL & I need help. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |