By amrit09 on

I'm wanting to insert mySql PHP into a page so that when that node is selected, the query is run. When i paste the code in however, using php filtering, i get the following error displayed on the page and several similar ones:-

Warning: Table 'mxmanagement.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table 'mxmanagement.role' doesn't exist\nquery: SELECT * FROM role ORDER BY name in /var/www/abhachu/drupalforum/includes/database.mysql.inc on line 121.', 2, '', 'http://dewey.computing.dundee.ac.uk/abhachu/drupalforum/?q=node/16', 'http://dewey.computing.dundee.ac.uk/abhachu/drupalforum/?q=node/16/edit', '134.36.37.136', 1171398196) in /var/www/abhachu/drupalforum/includes/database.mysql.inc on line 121

Is there a way to hide these warnings because the code actually does what is needed of it, or do i need to find another way to insert the mySql?

AMRIT

⋅ Categories: Drupal 4.7.x

Comments

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Your query is being executed using the Drupal database connection rather than your own connection.

See http://drupal.org/node/18429
"How to connect to multiple databases within Drupal"

--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.