Title: Database Connect within WordPress
Last modified: August 18, 2016

---

# Database Connect within WordPress

 *  [thebindlestick](https://wordpress.org/support/users/thebindlestick/)
 * (@thebindlestick)
 * [18 years, 11 months ago](https://wordpress.org/support/topic/database-connect-within-wordpress/)
 * I created a Page called editSubscriber and created a custom Theme for it, so 
   that I could embed php/html within the body. I want to run an SQL query from 
   this page and echo the results to the page with php, but I cannot get my database
   to connect. I can get it to connect from my root folder but when I place the 
   connection code at the top of Template for editSubscriber (in my theme folder)
   it says the table in the database does not connect. The exact error is:
 * QUERY ERROR:
    SELECT cm_lastname, cm_status FROM subscriber_data WHERE cm_lastname
   = Wilson Table ‘cmwordpress.subscriber_data’ doesn’t exist
 * First off, exactly where does the ‘cmwordpress’ come from? That is not the name
   of my database, or anything else that I can find.
 * Second, how can I get my database to connect? Like I said, i created a seperate
   script and placed it in my root folder (root wordpress not my theme) and it connected,
   and i am assuming it is just a file path issue, but how do I go about this? I
   was under the impression that when the theme files were read into the main index
   file, that it would look for a database from the root, but this isn;t the case.
   Any help here?
 * here is my db code:
 *     ```
       <?php
       /*
       Template Name: pt_editsubscriber
       */
       ?>
       <?
       // Makes initial conection to database
       define ('DB_USER', 'dbuser');
       define ('DB_PASSWORD', 'password');
       define ('DB_HOST', 'localhost');
       define ('DB_NAME', 'cmsubsdata');
   
       $connect = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)
         	or die('Our database is currently down for updates, please check back later.'); 
   
       $db = @mysql_select_db(DB_NAME, $connect)
       	or die('Our database is currently down for updates, please check back later.'); 
   
       // Selects data from database
        $getsubscriber = "SELECT cm_lastname, cm_status FROM subscriber_data WHERE cm_lastname = Wilson";
   
         $getsubscriber_result= mysql_query($getsubscriber)
          OR die('QUERY ERROR:<br />' .$getsubscriber. '<br />' .mysql_error());
       ?>
   
       blah blah blah html code here
   
       <?
                   while ($row = mysql_fetch_array($getsubscriber_result)) {
       	     $cm_firstname = $row["cm_firstname"];
                    $cm_status = $row["cm_status"];
                    echo"
                    $cm_firstname<br/>
                    $cm_status<br/>
                    ";
                    }
                    ?>
       ```
   

Viewing 1 replies (of 1 total)

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [18 years, 11 months ago](https://wordpress.org/support/topic/database-connect-within-wordpress/#post-552874)
 * Sorry your posts went into the spam queue. However, cursing will not be tolerated
   in the forum, so your “what happened to my post” complaint has been deleted.

Viewing 1 replies (of 1 total)

The topic ‘Database Connect within WordPress’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Samuel B](https://wordpress.org/support/users/samboll/)
 * Last activity: [18 years, 11 months ago](https://wordpress.org/support/topic/database-connect-within-wordpress/#post-552874)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics