techker Posted September 7, 2008 Share Posted September 7, 2008 hey guys im doing a car dealer site for my budy and im trying to figure out a page to show multible cars inventory page.. i got this going but it is now showing the second query right? <?php $QQQ = mysql_query("SELECT * FROM employees"); if (!$QQQ) die(mysql_error()); // Get the total number of rows $total_items = mysql_num_rows($QQQ); // Get the page limit & page $limit = $_GET['limit']; $page = $_GET['page']; // Do default setting if((!$limit) || (is_numeric($limit) == false) || ($limit < 1) || ($limit > 5)) { $limit = 2; //default } // Do default setting if((!$page) || (is_numeric($page) == false) || ($page < 0) || ($page > $total_items)) { $page = 1; //default } // Calculate the number to page to display $total_pages = ceil($total_items / $limit); $set_limit = $page * $limit - ($limit); $QQQ1 = mysql_query("SELECT * FROM employees LIMIT $set_limit, $limit "); if(!$QQQ1) die(mysql_error()); $err = mysql_num_rows($QQQ1); if($err == 0) die("No matches met your criteria."); // Let user decide how many result to show in each page // echo "Results per page: "; //echo "<a href='list_store.php?limit=2&page=1'>2</a> | //<a href='list_store.php?limit=5&page=1'>5</a> | //<a href='list_store.php?limit=10&page=1'>10</a>"; //Count Message $count = 1; //to loop the results into the table rows code goes here //while($FFF = mysql_fetch_assoc($QQQ1)) { ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- body { background-image: url(images/index_23.gif); } --> </style></head> <body> <table width="515" height="346" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="515" height="346" valign="top" background="images/admin_mid_m.jpg"><table width="506" height="140" border="1" align="center" cellpadding="0" cellspacing="0"> <tr><?php while ($info=mysql_fetch_array($QQQ1)) {?> <td width="209" height="105" rowspan="6"><div align="center"><?php echo '<img src="/ADMIN/pics/'. $info['thumb'] .'" border="0" alt="" /> <br />'; ?></div></td> </tr> <tr> <td colspan="2"><div align="center"><?php echo $info['name'] ?>-<?php echo $info['email'] ?></div></td> <td> </td> </tr> <tr> <td height="23" colspan="2"><strong>Numero de commande:<?php echo $info['numero'] ?></strong></td> <td width="87"> </td> </tr> <tr> <td height="60" colspan="2"><?php echo $info['description'] ?></td> <td> </td> </tr> <tr> <td height="29" colspan="2"><strong>Sold </strong>:<?php echo $info['sold'] ?></td> <td height="29"> </td> </tr> <?php } ?> </table> <p><table width="194" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="194"><div align="center"> <?php $prev_page = $page - 1; if($prev_page >= 1) { echo(" <a href=index_view.php?limit=$limit&page=$prev_page><b>Prev</b></a>"); } for($i = 1; $i <= $total_pages; $i++){ if($i == $page){ echo($i." "); }else{ echo("<a href=\"index_view.php?limit=$limit&page=$i\">$i</a> "); } } $next_page = $page + 1; if($next_page <= $total_pages) { echo("</b><a href=index_view.php?limit=$limit&page=$next_page><b>Next</b></a> "); } //dbDisconnect($conn2); ?></td> </tr> </table></p></td> </tr> </table> </body> </html> this is whats it showing. http://www.canada-auto.com/new/inv_inc.php Link to comment https://forums.phpfreaks.com/topic/123172-view-page/ Share on other sites More sharing options...
dezkit Posted September 7, 2008 Share Posted September 7, 2008 Whats the problem? Link to comment https://forums.phpfreaks.com/topic/123172-view-page/#findComment-636146 Share on other sites More sharing options...
techker Posted September 7, 2008 Author Share Posted September 7, 2008 did you see the link Link to comment https://forums.phpfreaks.com/topic/123172-view-page/#findComment-636148 Share on other sites More sharing options...
dezkit Posted September 7, 2008 Share Posted September 7, 2008 Seems perfectly normal, a little repair in css and tables, that's it... ...? Link to comment https://forums.phpfreaks.com/topic/123172-view-page/#findComment-636152 Share on other sites More sharing options...
techker Posted September 7, 2008 Author Share Posted September 7, 2008 thats what i need..cause the code is good but the view is not.think you can help with the css? Link to comment https://forums.phpfreaks.com/topic/123172-view-page/#findComment-636162 Share on other sites More sharing options...
techker Posted September 7, 2008 Author Share Posted September 7, 2008 ok i got it going..but is there a way to limit the amout of words shown in my description?so when he clicks more info it shows the hole thing? Link to comment https://forums.phpfreaks.com/topic/123172-view-page/#findComment-636188 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.