Connecting to custom database in wordpress

AFAIK you can have only one database. I don’t adding the table will work either. Try looking for a plugin that might work.

Correction. A search shows you can add a table to the wp database with no problems. There are plugins for that.

Thanks a lot for the reply kmessinger.

Can you help me with the name of the plugin?
I have spent a couple of days on the same thing now with nothing much to show for.

You can use phpMyAdmin and you can do anything to the database you want.

This plugin might work
https://www.ads-software.com/plugins/edit-any-table/

A google search for plug in for adding tables to wordpress database shows info that might be of help.

A search here for add+table+to+database also comes up with some information. Any plugin for wp has to have that function so there might be help in info on making plugins.

Sorry I can’t be more specific.

You may want to take a look at the wpdb functions that come with WordPress.

I have used these to manually add data to a gravity form table with good success in the past. It will look similar to this:

$wpdb->query(
	"
	UPDATE $wpdb->posts
	SET post_parent = 7
	WHERE ID = 15
		AND post_status = 'static'
	"
);

Thanks a lot guys.

Really appreciate the help.