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 Quote Link to comment Share on other sites More sharing options...
dezkit Posted September 7, 2008 Share Posted September 7, 2008 Whats the problem? Quote Link to comment Share on other sites More sharing options...
techker Posted September 7, 2008 Author Share Posted September 7, 2008 did you see the link Quote Link to comment 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... ...? Quote Link to comment 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? Quote Link to comment 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? 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.