Hi,
I am trying to add a code to display products and pagination together but I having real problems in fitting the HTML inside the curly tags. Is there anyway to seperate these out.
So I just echo each column inside its own set of PHP brackets.
Is there a way I can simplify this?Code:$pages_query = mysql_query("SELECT COUNT(`name`) FROM `productdbase`"); $pages = mysql_result($pages_query, 0); $pages = ceil(mysql_result($pages_query, 0) / $per_page); $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1; $start = ($page - 1) * $per_page; $query_string = "SELECT `name`, `rrp`, `image_link`, `image_link`, `discount` FROM `productdbase` LIMIT $start, $per_page"; $query = mysql_query($query_string); while ($query_row = mysql_fetch_assoc($query)) { echo '<p>', $query_row['name'] ,'</p>'; echo '<p>', $query_row['rrp'] ,'</p>'; echo '<p>', $query_row['image_link'] ,'</p>'; echo '<p>', $query_row['name'] ,'</p>'; } if ($pages >= 1 && $page <= $pages) { for ($x=1; $x<=$pages; $x++) { echo ($x == $page) ? '<strong><a href="?page='.$x.'">'.$x.'</a></strong> ' : '<a href="?page='.$x.'">'.$x.'</a> '; } }
Code:'<div class="productrangeborder">' echo '<div class="productdetailsborder"><a href="product.php?product_id=' . $query_row['product_id'] . '">' . $query_row['name'] . '</a></div>'; echo '<div class="productimageborder"><a href="product.php?product_id=' . $query_row['product_id'] . '"><img src="' . $query_row['image_link'] . '"/></a></div>'; echo '<div class="priceborder">' . $query_row['rrp'] . '</div>'; echo '<div class="discountborder">' . $query_row['discount'] . '</div>';'</div>'



Reply With Quote




Bookmarks