Sandbox

Code: Select all

<?php
$option['driver']   = 'mysql';            // Database driver name
$option['host']     = 'localhost';    // Database host name
$option['user']     = '<MY USERNAME>';       // User for database authentication
$option['password'] = '<MY PASSWORD>';  // Password for database authentication
$option['database'] = '<MY DB NAME>';      // Database name
$option['prefix']   = '';             // Database prefix (may be empty)

$dbh = & JDatabase::getInstance( $option );
$category = "Art";
$result = mysql_query("SELECT * FROM `#_layouttable` WHERE `category` = '{$category}' ORDER by name;", $dbh); 
$dbh->setQuery($result);
$name = $dbh ->loadResult();
                $myrow = mysql_fetch_array($name);
                ?>
                            
              <table align="center" cellspacing="10" class="categories"><!-- start table class categories -->              
              <?php
              do
              {
                printf("<tr>
                  <td class=\"layoutpic\">
                    <a class=\"layoutnamelink\" href=\"preview.php?name=%s\" target=\"preview\" title=\"%s Layouts\" >%s<br />
                    <img src=\"../images/%s\" /><br />
                    <div align=\"center\">Preview this African MySpace Layout</div></a>
                  </td>
                  </tr>", $myrow["name"], $myrow["name"], $myrow["name"], $myrow["pic"]);
              }while($myrow = mysql_fetch_array($resultcategory));
                ?>
            </table><!-- end table class categories -->