Reply to thread

Message

<blockquote data-quote="Dragy" data-source="post: 829693" data-attributes="member: 91197">Hello,I want to keep track of my watched movies in IMDB. A first start to get the list filled in IMDB, is to get the movie info from my Moving Pictures database. After that, I am gonna use PHP to add the info to IMDB (with cURL probably)Now I have the following query:[code]SELECT movie_info.imdb_id,user_movie_settings.watched FROM movie_info LEFT JOIN user_movie_settings ON user_movie_settings.id=movie_info.id[/code]Unfortunately, it's not right.. the id's of the watched column in the user_movie_settings table, do not match the id's of the movie_info table. I was not able to find how it works then.Can you help me?Thanks!EDIT:I think I have a better idea.. I don't know why I wanted to do it with IMDB.. Why not use the Trakt integration? Well, that is what I'm going to do now!You may still answer my question for if I change my mind again <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="Dragy, post: 829693, member: 91197"] Hello, I want to keep track of my watched movies in IMDB. A first start to get the list filled in IMDB, is to get the movie info from my Moving Pictures database. After that, I am gonna use PHP to add the info to IMDB (with cURL probably) Now I have the following query: [code]SELECT movie_info.imdb_id,user_movie_settings.watched FROM movie_info LEFT JOIN user_movie_settings ON user_movie_settings.id=movie_info.id[/code] Unfortunately, it's not right.. the id's of the watched column in the user_movie_settings table, do not match the id's of the movie_info table. I was not able to find how it works then. Can you help me? Thanks! [B]EDIT:[/B] I think I have a better idea.. I don't know why I wanted to do it with IMDB.. Why not use the Trakt integration? Well, that is what I'm going to do now! You may still answer my question for if I change my mind again :) [/QUOTE]

Verification