pixeltrace Posted July 29, 2007 Share Posted July 29, 2007 hi, i need help, i have a list page that has pagination and the list should be displayed in 5 columns. unfortunately, i cant make the column display work this is the link http://ideas-people.com/engsoon/brands.php and this is my current code <? include 'admean/db_connect.php'; include("admean/pagina/my_pagina_class.php"); $letter = ''; if (isset($_GET['sort'])) { if($_GET['sort'] != ''){ $letter = "WHERE substring(brand_name,1,1) = '". $_GET['sort'] ."'"; } } $test = new JHpage; $test->sql = "SELECT * FROM engsoon_brands ".$letter.""; //$test->sql = "SELECT * FROM engsoon_brands ORDER BY ".$sort1 ." ".$sort3." ".$sort2." "; // the (basic) sql statement (use the SQL whatever you like) $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <table width="500" border="0" cellspacing="4" cellpadding="0"> <tr> <td><span class="h2">Our Brands</span></td> </tr> <tr> <td>view brands by alphabetical order </td> </tr> <tr> <td>total record found:<?php echo " " .$total_recs; ?> </td> </tr> <tr> <td><a href="brands.php?id=2&sort=">All</a> <a href="brands.php?id=2&sort=A">A</a> <a href="brands.php?id=2&sort=B">B</a> <a href="brands.php?id=2&sort=C">C</a> <a href="brands.php?id=2&sort=D">D</a> <a href="brands.php?id=2&sort=E">E</a> <a href="brands.php?id=2&sort=F">F</a> <a href="brands.php?id=2&sort=G">G</a> <a href="brands.php?id=2&sort=H">H</a> <a href="brands.php?id=2&sort=I">I</a> <a href="brands.php?id=2&sort=J">J</a> <a href="brands.php?id=2&sort=K">K</a> <a href="brands.php?id=2&sort=L">L</a> <a href="brands.php?id=2&sort=M">M</a> <a href="brands.php?id=2&sort=N">N</a> <a href="brands.php?id=2&sort=O">O</a> <a href="brands.php?id=2&sort=P">P</a> <a href="brands.php?id=2&sort=Q">Q</a> <a href="brands.php?id=2&sort=R">R</a> <a href="brands.php?id=2&sort=S">S</a> <a href="brands.php?id=2&sort=T">T</a> <a href="brands.php?id=2&sort=U">U</a> <a href="brands.php?id=2&sort=V">V</a> <a href="brands.php?id=2&sort=W">W</a> <a href="brands.php?id=2&sort=X">X</a> <a href="brands.php?id=2&sort=Y">Y</a> <a href="brands.php?id=2&sort=Z">Z</a></td> </tr> <tr> <td> <? $columns = 5; //change the number of column for ($i = 0; $i < $num_rows; $i++) { $brands_logo = mysql_result($result, $i, "brands_logo"); $bid = mysql_result($result, $i, "bid"); //$brand_name = mysql_result($result, $i, "brand_name"); $rows = ceil($num_rows / $columns); $data[] = $brands_logo; $data1[] = $bid; echo "<table width='500' border='0' cellspacing='3' cellpadding='0'>\n"; echo "<tr>\n"; for($j = 0; $j < $columns; $j++) { if(isset($data[$i + ($j * $rows)])) { echo "<td><img src=\"../engsoon/images/brandlogo/" . $data[$i + ($j * $rows)] . "\"width='100' height='100'". "></td>\n"; echo "<td valign=\"top\">" . $data1[$i + ($j * $rows)] . "</td>\n"; } } echo "</tr>\n"; } echo "</table>\n"; ?> </td> </tr> <tr> <td align="right"> <? echo "<span>".$nav_links."</span>"; ?> </td> </tr> </table> </body> </html> hope you could help me fix this thanks so much! Link to comment https://forums.phpfreaks.com/topic/62320-solved-need-help-in-my-column-display/ Share on other sites More sharing options...
pixeltrace Posted July 29, 2007 Author Share Posted July 29, 2007 hi, any help on this? i tried fixing it. i set the column to 5 but its displaying the wrong way and its repeating the items http://ideas-people.com/engsoon/brands.php this is the current code i have now <? include 'admean/db_connect.php'; include("admean/pagina/my_pagina_class.php"); $letter = ''; if (isset($_GET['sort'])) { if($_GET['sort'] != ''){ $letter = "WHERE substring(brand_name,1,1) = '". $_GET['sort'] ."'"; } } $test = new JHpage; $test->sql = "SELECT * FROM engsoon_brands ".$letter.""; //$test->sql = "SELECT * FROM engsoon_brands ORDER BY ".$sort1 ." ".$sort3." ".$sort2." "; // the (basic) sql statement (use the SQL whatever you like) $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> </head> <body> <table width="500" border="0" cellspacing="4" cellpadding="0"> <tr> <td><span class="h2">Our Brands</span></td> </tr> <tr> <td>view brands by alphabetical order </td> </tr> <tr> <td>total record found:<?php echo " " .$total_recs; ?> </td> </tr> <tr> <td><a href="brands.php?id=2&sort=">All</a> <a href="brands.php?id=2&sort=A">A</a> <a href="brands.php?id=2&sort=B">B</a> <a href="brands.php?id=2&sort=C">C</a> <a href="brands.php?id=2&sort=D">D</a> <a href="brands.php?id=2&sort=E">E</a> <a href="brands.php?id=2&sort=F">F</a> <a href="brands.php?id=2&sort=G">G</a> <a href="brands.php?id=2&sort=H">H</a> <a href="brands.php?id=2&sort=I">I</a> <a href="brands.php?id=2&sort=J">J</a> <a href="brands.php?id=2&sort=K">K</a> <a href="brands.php?id=2&sort=L">L</a> <a href="brands.php?id=2&sort=M">M</a> <a href="brands.php?id=2&sort=N">N</a> <a href="brands.php?id=2&sort=O">O</a> <a href="brands.php?id=2&sort=P">P</a> <a href="brands.php?id=2&sort=Q">Q</a> <a href="brands.php?id=2&sort=R">R</a> <a href="brands.php?id=2&sort=S">S</a> <a href="brands.php?id=2&sort=T">T</a> <a href="brands.php?id=2&sort=U">U</a> <a href="brands.php?id=2&sort=V">V</a> <a href="brands.php?id=2&sort=W">W</a> <a href="brands.php?id=2&sort=X">X</a> <a href="brands.php?id=2&sort=Y">Y</a> <a href="brands.php?id=2&sort=Z">Z</a></td> </tr> <tr> <td> <? $columns = 5; //change the number of column while($row = mysql_fetch_array($result)) { $rows = ceil($num_rows / $columns); $data[] = $row['brands_logo']; $data1[] = $row['bid']; } echo "<table width='500' border='0' cellspacing='3' cellpadding='0'>\n"; for ($i = 0; $i < $num_rows; $i++) { echo "<tr>\n"; for($j = 0; $j < $columns; $j++) { if(isset($data[$i + ($j * $rows)])) { $bid = $data1[$i + ($j * $rows)]; echo "<td><a href ='brands.php?id=1&bid=$bid'><img src=\"../engsoon/images/brandlogo/" . $data[$i + ($j * $rows)] . "\"width='70' height='70'". "></a></td>\n"; } } echo "</tr>\n"; } echo "</table>\n"; ?> </td> </tr> <tr> <td align="right"> <? echo "<span>".$nav_links."</span>"; ?> </td> </tr> </table> </body> </html> hope you could help me on this. thanks so much! Link to comment https://forums.phpfreaks.com/topic/62320-solved-need-help-in-my-column-display/#findComment-310107 Share on other sites More sharing options...
wildteen88 Posted July 29, 2007 Share Posted July 29, 2007 Try the following <?php include 'admean/db_connect.php'; include 'admean/pagina/my_pagina_class.php'; $letter = ''; if (isset($_GET['sort'])) { if($_GET['sort'] != '') { $letter = "WHERE substring(brand_name,1,1) = '" . $_GET['sort'] . "'"; } } $test = new JHpage; $test->sql = "SELECT * FROM engsoon_brands ".$letter.""; //$test->sql = "SELECT * FROM engsoon_brands ORDER BY ".$sort1 ." ".$sort3." ".$sort2." "; // the (basic) sql statement (use the SQL whatever you like) $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info(); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records ?> <table width="500" border="0" cellspacing="4" cellpadding="0"> <tr> <td><span class="h2">Our Brands</span></td> </tr> <tr> <td>view brands by alphabetical order </td> </tr> <tr> <td>total record found:<?php echo " " .$total_recs; ?> </td> </tr> <tr> <td><a href="brands.php?id=2&sort=">All</a> <a href="brands.php?id=2&sort=A">A</a> <a href="brands.php?id=2&sort=B">B</a> <a href="brands.php?id=2&sort=C">C</a> <a href="brands.php?id=2&sort=D">D</a> <a href="brands.php?id=2&sort=E">E</a> <a href="brands.php?id=2&sort=F">F</a> <a href="brands.php?id=2&sort=G">G</a> <a href="brands.php?id=2&sort=H">H</a> <a href="brands.php?id=2&sort=I">I</a> <a href="brands.php?id=2&sort=J">J</a> <a href="brands.php?id=2&sort=K">K</a> <a href="brands.php?id=2&sort=L">L</a> <a href="brands.php?id=2&sort=M">M</a> <a href="brands.php?id=2&sort=N">N</a> <a href="brands.php?id=2&sort=O">O</a> <a href="brands.php?id=2&sort=P">P</a> <a href="brands.php?id=2&sort=Q">Q</a> <a href="brands.php?id=2&sort=R">R</a> <a href="brands.php?id=2&sort=S">S</a> <a href="brands.php?id=2&sort=T">T</a> <a href="brands.php?id=2&sort=U">U</a> <a href="brands.php?id=2&sort=V">V</a> <a href="brands.php?id=2&sort=W">W</a> <a href="brands.php?id=2&sort=X">X</a> <a href="brands.php?id=2&sort=Y">Y</a> <a href="brands.php?id=2&sort=Z">Z</a></td> </tr> <tr> <td> <?php echo "<table width=\"500\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">\n"; $columns = 5; //change the number of column $cur_col = 1; // current column counter while($row = mysql_fetch_assoc($result)) { $brand_logo = $row['brand_logo']; $big = $row['bid']; $tbl_cols = <<<EOF echo "<td><a href="brands.php?id=1&bid=$bid"><img src="../engsoon/images/brandlogo/$brand_logo" width="70" height="70"></a></td>; EOF; if($cur_col == 1) { echo "<tr>\n" . $tbl_cols . "\n"; // add table row for new column } elseif($cur_col < $columns) { echo $tbl_cols . "\n"; // add in a column } elseif($cur_col == $columns) { echo $tbl_cols . "</tr>\n"; // close table row $cur_col = 0; // reset current column count } $cur_col++; // increase curent column couunt by 1 } echo "</table>\n"; ?> </td> </tr> <tr> <td align="right"> <?php echo "<span>".$nav_links."</span>";?> </td> </tr> </table> </body> </html> It is untested. Link to comment https://forums.phpfreaks.com/topic/62320-solved-need-help-in-my-column-display/#findComment-310145 Share on other sites More sharing options...
pixeltrace Posted July 29, 2007 Author Share Posted July 29, 2007 thanks so much!!!!! its working now!!!!! Link to comment https://forums.phpfreaks.com/topic/62320-solved-need-help-in-my-column-display/#findComment-310161 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.