I have a Joomla database with all my aritcles (stories in Geeklog, content in Joomla) imported from a Geeklog database.
Joomla has a table 'jos_content' with a column (catid) that represents the content categories with int(20).
Geeklog has a table 'gl_stories' with a column (tid) that represents my stories categories with varchar(20).
The Geeklog stories have been imported into Joomla, but I left 'catid' column empty. Here is why:
What I have is this:
Geeklog.gl_stories | Joomla.jos_content
tid | catid
topic1 | 1
topic2 | 2
topic3 | 3
How would I UPDATE jos_content catid in Joomla so that it reflected the equivalent categories as Geeklog gl_stories tid?
I already created the categories in Joomla, but the content I imported from Geeklog does not have categories assigned.
I just need the MySQL syntax to populate 'catid' values with 'tid' values as per above.
I hope this explains clearly enough what I need.
It is a minor project, so I'll pay the hourly rate.
I need the