transparencia Posted October 23, 2008 Share Posted October 23, 2008 Hello friends, The problem is the following: I have made a partial IMDB database copy (Movie names and the year released) and want to apply it to Joomla. Joomla stores the articles information in a table called Jos_Content using a Title field, Full-text, and other fields, like alias and created_by. The IMDB database has a table called movies which have the Movie Title field and the Year field. What I would like to do is to copy all the movies fields to the Joomla article title fields and the year field to the full text field. IMDB database (movies table) --------» Joomla database (jos_content table) Movie Title --------------------------------» Article Title Year ----------------------------------------» Full text field What are the ways to do this? Quote Link to comment https://forums.phpfreaks.com/topic/129760-two-sql-databases-moving-table-fields-from-one-to-another/ Share on other sites More sharing options...
fenway Posted October 23, 2008 Share Posted October 23, 2008 Why corrupt the imdb database? Can't you just use those table locally? Quote Link to comment https://forums.phpfreaks.com/topic/129760-two-sql-databases-moving-table-fields-from-one-to-another/#findComment-673234 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.