andrew_biggart Posted February 28, 2009 Share Posted February 28, 2009 Does anyone know how i would go about recreating this effect? http://www.faceparty.com/browse/browse.aspx im using code something along the lines of this for single entrys but i want like four in a row. <?php include("config_members.php"); $sql="SELECT * FROM User_infoT "; $result=mysql_query($sql); while($rows=mysql_fetch_array($result)){ ?> <table style="width: 100%" cellspacing="0" cellpadding="0"> <tr><td class="proinfo"><? echo $rows['Profile_pic']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> <? // close while loop } // close connection mysql_close(); ?> But how would i go about coding it so that each row has four of these tables in the while loop? Thanks in advance Quote Link to comment Share on other sites More sharing options...
andrew_biggart Posted February 28, 2009 Author Share Posted February 28, 2009 ok ive tried this solution but it just has four of the same user in a row instead of four different users in each row. Is there any easy way to solve this? <br /> <table style="width: 100%" cellspacing="0" cellpadding="0"> <tr> <td> <table> <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> </td> <td> <table> <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> </td> <td> <table> <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> </td> <td> <table> <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> </td> </tr> </table> <br /> Quote Link to comment Share on other sites More sharing options...
andrew_biggart Posted February 28, 2009 Author Share Posted February 28, 2009 can anyone please help? im climbing the walls hahha Quote Link to comment Share on other sites More sharing options...
andrew_biggart Posted February 28, 2009 Author Share Posted February 28, 2009 surely someone can point me in the right direction seriously ??? Quote Link to comment Share on other sites More sharing options...
DarkSuperHero Posted February 28, 2009 Share Posted February 28, 2009 try this... <?php include("config_members.php"); $sql="SELECT * FROM User_infoT "; $result=mysql_query($sql); echo '<table style="width: 100%" cellspacing="0" cellpadding="0">'; while($rows=mysql_fetch_array($result)){ $myRow = '<tr><td class="proinfo">'.$rows['Profile_pic'].'</td> <td class="proinfo">'.$rows['Username'].'</td> <td class="proinfo">'.$rows['Location'].'</td> <td class="proinfo">'.$rows['Fav'].'</td></tr>'; } echo '</table>'; mysql_close(); ?> or are you trying to do pagination ? only display 4 rows, then make up another page with 4 more rows to display ? Quote Link to comment Share on other sites More sharing options...
andrew_biggart Posted February 28, 2009 Author Share Posted February 28, 2009 someone else solved it for anyone else who cares hear is the solution. <div id="pagination"> <br /> <?php /* Place code to connect to your DB here. */ include('config_members.php'); // include your code to connect to DB. $tbl_name="User_infoT"; //your table name // How many adjacent pages should be shown on each side? $adjacents = 3; /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure you mirror it here. */ $query = "SELECT COUNT(*) as num FROM $tbl_name"; $total_pages = mysql_fetch_array(mysql_query($query)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "page_test2.php"; //your file name (the name of this file) $limit = 4; //how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $sql = "SELECT Username, Location, Fav FROM $tbl_name ORDER BY User_id ASC LIMIT $start, $limit"; $result = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { $pagination .= "<div class=\"pagination\">"; //previous button if ($page > 1) $pagination.= "<a href=\"$targetpage?page=$prev\">« previous</a>"; else $pagination.= "<span class=\"disabled\">« previous</span>"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //close to end; only hide early pages else { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } } //next button if ($page < $counter - 1) $pagination.= "<a href=\"$targetpage?page=$next\">next »</a>"; else $pagination.= "<span class=\"disabled\">next »</span>"; $pagination.= "</div>\n"; } ?> <?=$pagination?> <br /> <table style="width: 100%" cellspacing="0" cellpadding="0"> <tr> <?php $counter = 0; while($rows = mysql_fetch_array($result)) { ?> <td> <table> <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr> <tr><td class="proinfo"><? echo $rows['Username']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr> <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr> </table> </td> <?php $counter++; if($counter == 4) { echo '</tr><tr>'; $counter = 0; } } for(; $counter != 4; $counter++) echo '<td></td>'; ?> </tr> </table> <br /> <?=$pagination?> </div> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.