WB Database Question

[dhdesign]

I'm using WB version 2.6.1.

I am trying to insert a script into a page using a code section.  This code requires that a connection be made to another database to retrieve the data to be displayed.  This page also has a WYSIWYG section at the beginning of the page, followed by the code section.

I have been getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in .../modules/code/view.php(30) : eval()'d code on line 46

After searching the forum, I happened upon this thread:  http://forum.websitebaker.org/index.php/topic,907.0.html that explained the error that I'm getting.  They talk about not being able to use 2 different database connections from the same page.  That is understandable, and I have no problem with that.

What I would like to know is this:  Can I add a database table to the WB database to use to store the data submitted, and to retrieve it from?  The information in this database table would not be used by WB anyplace else, just on this page.  The data is entered into the database via a small form that I have set up.  Would this extra table interfere with WB in any way?

I think, if I am able to do that, it should hopefully eliminate this error, and allow my script to work properly.

Thank you in advance for you help! 

[felix_se_cat]

i have a lot of other tables in my database because my provider only allows one db.
i don't think additional tables will interfere your wb. (in my case it's no problem)

[pcwacht]

It doesn't interfere, multiple tables in one database.

tip, use prefixes to extinguish them!

ie:
wb_  for wb tables
forum_  for forum etc etc etc


this way you can determine very easy wich is what

John

[dhdesign]

Thanks for your responses!  I've gone ahead and created a new table in the WB database with a prefix to identify it, corrected the code to take out the extra database call, and all is working well now!