While building a wordpress site and needed to work with a separate existing database.
\nAdded a function in wp-includes\/functions.php like this:<\/p>\n
Then wherever I need to connect to this database I can use the function like this:<\/p>\n While building a wordpress site and needed to work with a separate existing database. Added a function in wp-includes\/functions.php like this: function my_query($sql){ $db = @mysql_connect(“my_DB_host”, “DB_usr”, “DB_pass”); mysql_select_db(“my_other_database”); $result = mysql_query($sql) or die(‘Did not get required database result’); return … Continue reading
\nfunction my_query($sql){
\n$db = @mysql_connect(\"my_DB_host\", \"DB_usr\", \"DB_pass\");
\nmysql_select_db(\"my_other_database\");
\n$result = mysql_query($sql) or die('Did not get required database result');
\nreturn $result;
\nmysql_close($db);
\n}
\n<\/code><\/p>\n
\n$sql = sprintf(\"SELECT blah FROM table\");
\n$result = my_query($sql);
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"