Dreamweaver: Using PHP to display multiples values across a 3x5 grid (think photo album)

I am designing an online portfolio for my website, and I want the results to be displayed in a table, such as a 3 column x 5 row grid (to show 15 samples).  Right now, the only thing I can get it to do is to display the same record in each column.  For example

PIC A  |  PIC A   | PIC A
PIC B  |  PIC B  |  PIC B

I want this:

PIC A  |  PIC B  |  PIC C
PIC D  |  PIC E  |  PIC F

I hope this makes sense.  I want the simplest solution; hopefully it's built into dreamweaver.
glorytohim36360Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nanharbisonCommented:
This makes sense if you have the values stored in a database table. Do you have a query you can show us, which is not working as you want it to work yet? SInce you asked this question in the PHP and databases zone, this must involve a query, right?
0
glorytohim36360Author Commented:
Check out http://www.g2graphicsmore.com/main_portfolio.php.  I'm trying to get pictures and the text to go 3 columns wide x 5 rows.  

My queries are working fine; data is being pulled; put I want to put separate values into the columns, as well as the rows.
0
glorytohim36360Author Commented:

<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	background-color: #84BAE8;
	margin-top: 5px;
}
.style1 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 9px;
	color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
	font-family: Arial, Helvetica, sans-serif;
	font-weight: bold;
	color: #2985C4;
}
.style3 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
		<td colspan="6">
		  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
	<tr>
		<td>
		  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
	  <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
	  <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
	  <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
	  <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
	  <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
	</tr>
	<tr>
	  <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
	    <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%"><?php do { ?>
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center"><img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div></td>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center"></div></td>
                  <td width="32%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center"></div></td>
                </tr>
                                </table>
                <?php } while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records)); ?></td>
          </tr>
        </table>
	  <!-- InstanceEndEditable --></td>
  </tr>
	<tr>
	  <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
	  PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

NerdsOfTechTechnology ScientistCommented:
This script also deals with blank columns left over from incomplete rows

Alter to your specs

=NerdsOfTech
<?php
// quick image maxcols table by NerdsOfTech
// user will need to set CONNECTION and SQL stetments
 
$maxcols = 5; // maximum columns changed for glorytohim36360 to 5 by N table
$count=0; // initialize count
 
// START CUSTOMIZATION. CHANGE THIS BELOW TO YOUR INFORMATION. MAKE $result your SQL query results
 
$tablename = 'Images';
$conn = mysqli_connect($host,$user,$password,$database)
or die ("couldn't connect to server");
        
$query = "SELECT * FROM $tablename";
$result = mysqli_query($conn, $query)
or die ("Couldn't execute query.");
 
// END CUSTOMIZATION
 
while ($row=mysqli_fetch_assoc($result))
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="600" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row['fieldname']
 
?>
 
<td align="center">
<A HREF="<? echo $row['url']; ?>" target="_blank"><IMG SRC="<? echo $row['url']; ?>" border="0" alt="<? echo $row['description']; ?>" width="150"></a>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td>&nbsp;</td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>

Open in new window

0
glorytohim36360Author Commented:
Is there not an easier way to handle this - such as a next record option in dreamweaver or anything?
0
NerdsOfTechTechnology ScientistCommented:
You have to use a modulus division nonetheless.
Count % 5

Here is my program flow above:

start table if data exist
print
check MOD for 0: false
print
check MOD for 0: false
print
check MOD for 0: false
print
check MOD for 0: false
print
check MOD for 0: true; break row start new row
...
check to see if last column is filled: false
print blank columns 5 minus x times
end last row
end table

I altered your code to reflect your output to match my code somewhat... see if this works:
<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
 
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-color: #84BAE8;
        margin-top: 5px;
}
.style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
        color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
        font-family: Arial, Helvetica, sans-serif;
        font-weight: bold;
        color: #2985C4;
}
.style3 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
 
 
 
 
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
                <td colspan="6">
                  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
        <tr>
                <td>
                  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
          <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
          <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
          <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
        </tr>
        <tr>
          <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
            <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%">
<?php 
 
$maxcols = 5; // maximum columns
$count=0; // initialize count
 
while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records)) { 
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row_portfolio_records['fieldname']
 
?>
 
<td align="center">
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center">
                      <img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div>
                  </td>
                </tr>
              </table>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row_portfolio_records['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td> </td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>
 
 
 
           </td>
          </tr>
        </table>
 
 
 
 
          <!-- InstanceEndEditable --></td>
  </tr>
        <tr>
          <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
          PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
glorytohim36360Author Commented:
No luck: pasted the code to this php file:

http://www.g2graphicsmore.com/test2.php
0
NerdsOfTechTechnology ScientistCommented:
1 syntax error fixed extra '{' removed
<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
 
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-color: #84BAE8;
        margin-top: 5px;
}
.style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
        color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
        font-family: Arial, Helvetica, sans-serif;
        font-weight: bold;
        color: #2985C4;
}
.style3 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
 
 
 
 
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
                <td colspan="6">
                  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
        <tr>
                <td>
                  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
          <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
          <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
          <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
        </tr>
        <tr>
          <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
            <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%">
<?php 
 
$maxcols = 5; // maximum columns
$count=0; // initialize count
 
while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records))
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row_portfolio_records['fieldname']
 
?>
 
<td align="center">
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center">
                      <img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div>
                  </td>
                </tr>
              </table>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row_portfolio_records['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td> </td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>
 
 
 
           </td>
          </tr>
        </table>
 
 
 
 
          <!-- InstanceEndEditable --></td>
  </tr>
        <tr>
          <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
          PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
glorytohim36360Author Commented:
It's working now, but it's not pulling all of the records.  I've got three records, and it only displays two records.
0
NerdsOfTechTechnology ScientistCommented:
Can you post up the one that is showing only 2 records so I see whats going on

ALSO

is it the first 2 or the last 2 showing?
0
NerdsOfTechTechnology ScientistCommented:
debug output SQL copy/paste SQL output
<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
 
 
echo $query_limit_portfolio_records; // debug: SQL
 
 
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
 
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-color: #84BAE8;
        margin-top: 5px;
}
.style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
        color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
        font-family: Arial, Helvetica, sans-serif;
        font-weight: bold;
        color: #2985C4;
}
.style3 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
 
 
 
 
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
                <td colspan="6">
                  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
        <tr>
                <td>
                  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
          <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
          <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
          <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
        </tr>
        <tr>
          <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
            <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%">
<?php 
 
$maxcols = 5; // maximum columns
$count=0; // initialize count
 
while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records))
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row_portfolio_records['fieldname']
 
?>
 
<td align="center">
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center">
                      <img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div>
                  </td>
                </tr>
              </table>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row_portfolio_records['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td> </td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>
 
 
 
           </td>
          </tr>
        </table>
 
 
 
 
          <!-- InstanceEndEditable --></td>
  </tr>
        <tr>
          <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
          PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
glorytohim36360Author Commented:
http://www.g2graphicsmore.com/test2.php

it's the latest 2 records that's showing.  the first one is not showing.
0
NerdsOfTechTechnology ScientistCommented:
More debug replace file
<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
 
 
echo $query_limit_portfolio_records; // debug: SQL
 
 
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
 
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-color: #84BAE8;
        margin-top: 5px;
}
.style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
        color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
        font-family: Arial, Helvetica, sans-serif;
        font-weight: bold;
        color: #2985C4;
}
.style3 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
 
 
 
 
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
                <td colspan="6">
                  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
        <tr>
                <td>
                  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
          <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
          <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
          <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
        </tr>
        <tr>
          <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
            <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%">
<?php 
 
$maxcols = 5; // maximum columns
$count=0; // initialize count
 
//debug
echo '<br>' . $portfolio_records . '<br>';
$row = mysql_fetch_assoc($portfolio_records);
print_h $row;
 
 
while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records))
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row_portfolio_records['fieldname']
 
?>
 
<td align="center">
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center">
                      <img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div>
                  </td>
                </tr>
              </table>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row_portfolio_records['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td> </td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>
 
 
 
           </td>
          </tr>
        </table>
 
 
 
 
          <!-- InstanceEndEditable --></td>
  </tr>
        <tr>
          <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
          PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
NerdsOfTechTechnology ScientistCommented:
Oops try this instead...
<?php require_once('Connections/g2_portfolio.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
 
$maxRows_portfolio_records = 15;
$pageNum_portfolio_records = 0;
if (isset($_GET['pageNum_portfolio_records'])) {
  $pageNum_portfolio_records = $_GET['pageNum_portfolio_records'];
}
$startRow_portfolio_records = $pageNum_portfolio_records * $maxRows_portfolio_records;
 
mysql_select_db($database_g2_portfolio, $g2_portfolio);
$query_portfolio_records = "SELECT * FROM portfolio_records";
$query_limit_portfolio_records = sprintf("%s LIMIT %d, %d", $query_portfolio_records, $startRow_portfolio_records, $maxRows_portfolio_records);
 
 
echo $query_limit_portfolio_records; // debug: SQL
 
 
$portfolio_records = mysql_query($query_limit_portfolio_records, $g2_portfolio) or die(mysql_error());
$row_portfolio_records = mysql_fetch_assoc($portfolio_records);
 
if (isset($_GET['totalRows_portfolio_records'])) {
  $totalRows_portfolio_records = $_GET['totalRows_portfolio_records'];
} else {
  $all_portfolio_records = mysql_query($query_portfolio_records);
  $totalRows_portfolio_records = mysql_num_rows($all_portfolio_records);
}
 
$totalPages_portfolio_records = ceil($totalRows_portfolio_records/$maxRows_portfolio_records)-1;
?><html><!-- InstanceBegin template="/Templates/G2 Secondary Pages.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Nov2008 Secondary Page</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
        background-color: #84BAE8;
        margin-top: 5px;
}
.style1 {
        font-family: Verdana, Arial, Helvetica, sans-serif;
        font-size: 9px;
        color: #FFFFFF;
}
-->
</style>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
<!--
.style2 {
        font-family: Arial, Helvetica, sans-serif;
        font-weight: bold;
        color: #2985C4;
}
.style3 {
        font-family: Arial, Helvetica, sans-serif;
        font-size: 10px;
}
.style6 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; font-weight: bold; }
-->
</style>
<!-- InstanceEndEditable -->
</head>
<body leftmargin="0" marginwidth="0">
<!-- ImageReady Slices (Nov2008 Secondary Page.psd) -->
 
 
 
 
<table width="850" height="197" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
<tr>
                <td colspan="6">
                  <img src="images/Nov2008-Secondary-Page_01.jpg" width="850" height="35" alt=""></td>
  </tr>
        <tr>
                <td>
                  <a href="index.html"><img src="images/Nov2008-Secondary-Page_02.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <a href="about_g2.html"><img src="images/Nov2008-Secondary-Page_03.jpg" alt="" width="149" height="162" border="0"></a></td>
  <td>
          <a href="port_magnews_1.html"><img src="images/Nov2008-Secondary-Page_04.jpg" alt="" width="169" height="162" border="0"></a></td>
<td>
          <a href="media.html"><img src="images/Nov2008-Secondary-Page_05.jpg" alt="" width="158" height="162" border="0"></a></td>
  <td>
          <a href="contact.html"><img src="images/Nov2008-Secondary-Page_06.jpg" alt="" width="151" height="162" border="0"></a></td>
<td>
          <img src="images/Nov2008-Secondary-Page_07.jpg" width="72" height="162" alt=""><br></td>
        </tr>
        <tr>
          <td colspan="6" bgcolor="#F7FBFE"><!-- InstanceBeginEditable name="Main Content" -->
            <table width="100%" border="0" cellspacing="0" cellpadding="2">
          <tr>
            <td colspan="2"><div align="right" class="style2">Portfolios &amp; Samples</div></td>
          </tr>
          <tr>
            <td colspan="2">&nbsp;</td>
          </tr>
          <tr>
            <td width="23%">&nbsp;</td>
            <td width="77%">
<?php 
 
$maxcols = 5; // maximum columns
$count=0; // initialize count
 
//debug
echo '<br>' . $portfolio_records . '<br>';
$row = mysql_fetch_assoc($portfolio_records);
print_r $row;
 
 
while ($row_portfolio_records = mysql_fetch_assoc($portfolio_records))
{
$count++; // increment count
 
 if ($count == 1)
 { // initalize table
?>
 
<table width="100%" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
 
<?
 }
 
// START CUSTOMIZATION. CELL Printout. Reference fields by $row_portfolio_records['fieldname']
 
?>
 
<td align="center">
              <table width="100%" border="1" cellspacing="0" cellpadding="2">
                <tr>
                  <td width="34%" bordercolor="#FFFFFF" bgcolor="#CCCCCC"><div align="center">
                      <img src="<?php echo $row_portfolio_records['thumbnail_pic']; ?>" alt="" width="200" height="200"><br>
                      <span class="style6"><?php echo $row_portfolio_records['client']; ?></span><br>
                      <span class="style3"><?php echo $row_portfolio_records['budget']; ?><br>
                      <?php echo $row_portfolio_records['comments']; ?></span><br>
                  </div>
                  </td>
                </tr>
              </table>
</td>
 
<?
 
// END CUSTOMIZATION. CELL printout. Reference fields by $row_portfolio_records['fieldname']
 
 if (!bcmod($count,$maxcols)) 
 { // if modulus of count is = 0 then end row
  echo '</tr><tr>'; 
 }
 
}
 
if ($count)
{ // data exists
 $fill = bcmod($count,$maxcols); // current column
 if ($fill){ // if not last column already fill in blank columns
  for ($i = $fill; $i <= ($maxcols -1); $i++){
   echo '<td> </td>';
  }
  echo '</tr>';
 }
 echo '</table>';
}
?>
 
 
 
           </td>
          </tr>
        </table>
 
 
 
 
          <!-- InstanceEndEditable --></td>
  </tr>
        <tr>
          <td colspan="6" bgcolor="#2985C4"><div align="center" class="style1">&copy;2008 G2 Graphics &amp; More. All rights reserved. <br>
          PO Box 793 | Ozark AL 36361 | 866-813-6316 | gary@g2graphicsmore.com</div></td>
  </tr>
</table>
<br>
<!-- End ImageReady Slices -->
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($portfolio_records);
?>

Open in new window

0
NerdsOfTechTechnology ScientistCommented:
I'll post back tommorrow try the last answer first to debug
0
NerdsOfTechTechnology ScientistCommented:
Please replace the same url so I can see it
0
Jason C. LevineDon't talk to me.Commented:
FYI,

There is a free extension for Dreamweaver that handles horizontal looping:

http://www.tom-muck.com/extensions/help/HorizontalLooper/
0
glorytohim36360Author Commented:
Jason,

I had originally tried that, and it didn't work.  However, I tried it again, but this time, I detached the template from the page, and it worked beautifully!  You'll have to resize the tables after using it, but it works great.

Thanks,

Gary
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason C. LevineDon't talk to me.Commented:
The template was preventing some needed code from being written.

Also, when closing questions that the Experts answer, you use the "Accept Multiple Solutions' button in any Expert post to split points.  Right now, you are telling everyone that you solved the question yourself, but are giving us points anyway...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.