bbhank

Thank you.

That’s not what I get here. Will look into.

The address data in the locations database needs to always be the same as in the main database. When the address data changes in the main database, this needs to be automatically changed in the locations database.

Eliminated the theme as a possible culprit.
THEN:
Took apart the whole page. Reassembled it piece by piece, php code block by php code block.
Problem was not where I thought it would be, but I didn’t know.

Took out this code:
“//select which database you want to edit
mysql_select_db(“database”)or die( “<p><span style=\”color: red;\”>Unable to select database</span></p>”);”

Realized database already selected. Tested and It now works!

Thank you much.
Out of 5 possible stars you must get at least 8 for this kind of help.

I have the same theme as ever. This is the same code as ever. Nothing changed on my end. That’s the frustrating part. I didn’t write the theme. The last part of May a lot of things stopped working on my site. I hadn’t even been on the site. There were no virus or malware. Everything has had to be rebuilt. This is the last piece that doesn’t work and you say there is no error in my code but in the page itself. Thank you for the time and video but the stuff you are talking about on the page, in the theme, is not something I built, or can edit. All I can do is try another theme but that wrecks everything else.

From footer.php –

do_action( ‘__before_footer’ ); ?>
<!– FOOTER –>
<footer id=”footer” class=”<?php echo czr_fn__f(‘tc_footer_classes’, ”) ?>”>
<?php do_action( ‘__footer’ ); // hook of footer widget and colophon?>
</footer>
</div><!– //#tc-page-wrapper –>
<?php
do_action( ‘__after_page_wrap’ );
wp_footer(); //do not remove, used by the theme and many plugins
do_action( ‘__after_footer’ ); ?>
</body>
<?php do_action( ‘__after_body’ ); ?>
</html>

That’s what I’ve been doing.
Not being a programmer, I used Custom Shortcode Creator plugin to house the php. It all worked until recently. I’m running the site in debug mode and getting no errors at all. Got very little to go on. I’ve tried putting the code directly into the template but it doesn’t work and gives no error message that way either.

Not sure of what you mean with on the fly but each page shows the information for that page, that business, by ID number. When you go to the page it is for one particular business. Data for each business changes freely.

I was using exec-php without problem until it ceased to work. Now none of the shortcodes work. Presently the php is in Custom ShortCode Creator, which also shows its on the way out. Hasn’t been updated in a long time. No word from the producer. Its shortcodes are in the main template of a child theme.

I also tried putting the actual php in place of the shortcodes and without exec-php they didn’t work that way either. Before the loss of exec-php neither was a problem. I could use either shortcode or php wherever I wanted.

• This reply was modified 7 years, 9 months ago by bbhank.

Looking for plugin that will sync any selected fields in any selected table with any selected fields in any other selected table, in the same database, in either direction, independent of how any other system works with them. The tables that need syncing are part of two separate systems, one written almost totally in java and the other totally in php. The locations table (java) needs to be identical with the locations only, in the main database table. Every time there is a change or addition to the main database, certain location data (fields) for that table needs to be synchronized with the locations table. The locations data is used by a calendar whereas the main data is used as an information database that uses the calendar events but not its locations. This is why the sync is one direction only (main to locations), and only for selected fields used by the calendar locations database.