Database Redundacy between two different components - sync

We a have a joomla based site which has two different components which utilize location/address information.

Problem is the two have locations which should be visible and shared between the two. Example, for the one component, if a venue is added there we would like it automatically added it to the other component's related table.


How can we automatically eliminate dupes within the individual tables and also between the two?


This may also involve addition of a small text string added to joomla's jos_content table. One of the two components works in concert with Joomla's article/content system. So effectively when you add a new listing, you are creating a new content item in joomla. And joomla requires that at the creation of a new article, that there be some content in the description field, So we just to create/add/or copy a simple text string to that field.

Extensive database and joomla "rated" experienced required.

Taidot: Joomla, PHP, SQL

Näytä lisää: two string problem, the string problem, string problem, php components, creating php table, venue, two, new venue, DIFFERENT, creating question, Components, database question, create venue, joomla add table article, php sync, added database, database example, field addition, eliminate, component works, copy tables, database system simple, php sync database, text based database, extensive related

Tietoa työnantajasta:
( 17 arvostelua ) Chicago, United States

Projektin tunnus: #525084