Title: PHP/MySQL querystrings and exec-php
Last modified: August 18, 2016

---

# PHP/MySQL querystrings and exec-php

 *  [rozilla](https://wordpress.org/support/users/rozilla/)
 * (@rozilla)
 * [18 years, 10 months ago](https://wordpress.org/support/topic/phpmysql-querystrings-and-exec-php/)
 * i installed [exec-php](http://bluesome.net/post/2005/08/18/50/) and the Hello
   World test worked fine. I’m trying to run the php code listed below. It works
   just fine offline with EasyPHP. I put the same db online and tried to run the
   code as a WordPress page. But all I keep getting is the portion listed in the
   else-block. How can I get the querystring properly processed?
 *     ```
       <?php
   
       dbh=mysql_connect ("localhost", "<USERNAME>", "<PASSWORD>") or die ('I cannot connect to the database because: ' . mysql_error());
       mysql_select_db ("intore_cabd");*/
   
       // display individual record
       if ($category)
       {
          $result = mysql_query("SELECT * FROM <code>businesses</code> WHERE <code>category</code> = '{$category}' ORDER by bizname;", $dbh);
          $myrow = mysql_fetch_array($result);
          echo "<h2>Category: $category</h2>";
          do
          {
             printf("<p><b>%s</b>\n<br />", $myrow["bizname"]);
             printf("%s\n<br />", $myrow["description"]);
             printf("%s\n<br />", $myrow["address"]);
             printf("%s\n<br />", $myrow["country"]);
             printf("%s\n<br />", $myrow["telephone"]);
             if ($myrow["url"])
               printf("<a href=\"$myrow[7]\" target=\"_blank\">%s</a>\n<br />", $myrow["url"]);
             if ($myrow["email"])
               printf("<a href=\"mailto:$myrow[8]\">%s</a>\n</p><br />", $myrow["email"]);
             echo"<hr>";
           }while($myrow = mysql_fetch_array($result));
       }
       else
       {// show categories list
          $result = mysql_query("SELECT * FROM categories ORDER BY category",$dbh);
   
           if ($myrow = mysql_fetch_array($result))
           {// display list if there are records to display
             do
             {
               printf("<a href=\"%s?category=%s\">%s</a><br>\n", $PHP_SELF, $myrow["category"], $myrow["category"]);
             } while ($myrow = mysql_fetch_array($result));
           }
           else
           {// no records to display
             echo "Sorry, no records were found!";
           }
       }
   
       ?>
       ```
   

The topic ‘PHP/MySQL querystrings and exec-php’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [Query String](https://wordpress.org/support/topic-tag/query-string/)
 * [wordpress Pages](https://wordpress.org/support/topic-tag/wordpress-pages/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [rozilla](https://wordpress.org/support/users/rozilla/)
 * Last activity: [18 years, 10 months ago](https://wordpress.org/support/topic/phpmysql-querystrings-and-exec-php/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics