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?
 
glorytohim36360Connect With a Mentor Author 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
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
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
 
NerdsOfTechConnect With a Mentor Technology ScientistCommented:
Please replace the same url so I can see it
0
 
Jason C. LevineConnect With a Mentor No oneCommented:
FYI,

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

http://www.tom-muck.com/extensions/help/HorizontalLooper/
0
 
Jason C. LevineNo oneCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.