Current location: Hot Scripts Forums » Programming Languages » PHP » How can i reduce the amount of query's?


How can i reduce the amount of query's?

Reply
  #1 (permalink)  
Old 05-04-10, 11:01 AM
blackhawkso blackhawkso is offline
Newbie Coder
 
Join Date: Mar 2010
Posts: 39
Thanks: 3
Thanked 0 Times in 0 Posts
Question How can i reduce the amount of query's?

How could i reduce the amount of query's that i have in this script? Because the guy might be adding stuff in the future and the code in this page could get very crazy.

PHP Code:

<?php


require('../../../config/config.php');

$con mysql_connect($host,$dbuser,$dbpass);
    if (!
$con)
      {
      die(
'Could not connect: ' mysql_error());
      }
      
mysql_select_db ($dbname);
   
   
$location '../../../images/book_covers/';

echo
'<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,td,th {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    color: #FFF;
    font-weight: bold;
}
body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
    background-color: transparent;
}
a {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    color: #FFF;
    font-weight: bold;
}
a:visited {
    color: #FFF;
}
a:hover {
    color: #FFF;
}
a:active {
    color: #FFF;
}
-->
</style></head>

<body>
<table width="619" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="267" height="287" align="center" valign="middle" background="../../../images/books/books_backing.png"><table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
       <tr>'
;
       
       
$query="SELECT * FROM books WHERE id='1'";
       
$resultmysql_query($query);

       
$row mysql_fetch_assoc($result);
       
       
$query2="SELECT * FROM books WHERE id='2'";
       
$result2mysql_query($query2);

       
$row2 mysql_fetch_assoc($result2);
       
       
$query3="SELECT * FROM books WHERE id='3'";
       
$result3mysql_query($query3);

       
$row3 mysql_fetch_assoc($result3);
       
       
$query4="SELECT * FROM books WHERE id='4'";
       
$result4mysql_query($query4);

       
$row4 mysql_fetch_assoc($result4);

       echo
'<td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' .$row['id']. '" target="_top"><img src="' .$location.$row['cover']. '" width="142" height="204" border="0" /></a></td>
       <td width="10">&nbsp;</td>
       <td>&nbsp;</td>
       <td width="10">&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><p>' 
.$row['name']. '</p></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle">&pound;' 
.$row['price']. '</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><a href="#">Buy it now</a></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="70">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td colspan="4" align="left" valign="top">' 
.$row['quote']. '</td>
       </tr>
   </table></td>
    <td width="79" height="287" background="../../../images/books/books_spacer.png">&nbsp;</td>
    <td width="273" height="287" align="center" valign="middle" background="../../../images/books/books_backing_r.png"><table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
       <tr>
       <td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' 
.$row2['id']. '" target="_top"><img src="' .$location.$row2['cover']. '" width="142" height="204" border="0" /></a></td>
       <td width="10">&nbsp;</td>
       <td>&nbsp;</td>
       <td width="10">&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><p>' 
.$row2['name']. '</p></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle">&pound;' 
.$row2['price']. '</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><a href="#">Buy it now</a></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="70">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td colspan="4" align="left" valign="top">' 
.$row2['quote']. '</td>
       </tr>
   </table></td>
  </tr>
  <tr>
    <td><img src="../../../images/books/spacer.gif" width="1" height="90" /></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td width="267" height="287" align="center" valign="middle" background="../../../images/books/books_backing.png"><table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
       <tr>
       <td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' 
.$row3['id']. '" target="_top"><img src="' .$location.$row3['cover']. '" width="142" height="204" border="0" /></a></td>
       <td width="10">&nbsp;</td>
       <td>&nbsp;</td>
       <td width="10">&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><p>' 
.$row3['name']. '</p></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle">&pound;' 
.$row3['price']. '</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><a href="#">Buy it now</a></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="70">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td colspan="4" align="left" valign="top">' 
.$row3['quote']. '</td>
       </tr>
   </table></td>
    <td width="79" height="287" background="../../../images/books/books_spacer.png">&nbsp;</td>
    <td width="273" height="287" align="center" valign="middle" background="../../../images/books/books_backing_r.png"><table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
       <tr>
       <td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' 
.$row4['id']. '" target="_top"><img src="' .$location.$row4['cover']. '" width="142" height="204" border="0" /></a></td>
       <td width="10">&nbsp;</td>
       <td>&nbsp;</td>
       <td width="10">&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><p>' 
.$row4['name']. '</p></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle">&pound;' 
.$row4['price']. '</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="20">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td align="center" valign="middle"><a href="#">Buy it now</a></td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td>&nbsp;</td>
       <td height="70">&nbsp;</td>
       <td>&nbsp;</td>
     </tr>
     <tr>
       <td colspan="4" align="left" valign="top">' 
.$row4['quote']. '</td>
       </tr>
   </table></td>
  </tr>
  <tr>
  <td colspan="3"><img src="../../../images/books/spacer.gif" width="1" height="30" /></td>
  </tr>
</table>
</body>
</html>'
;

mysql_close($con);

?>
Please help if you can
__________________
Don't understand science?

Try religion lol
Reply With Quote
  #2 (permalink)  
Old 05-06-10, 09:34 AM
job0107's Avatar
job0107 job0107 is offline
Community Liaison
 
Join Date: Dec 2006
Location: Tacoma, Washington USA
Posts: 3,454
Thanks: 0
Thanked 140 Times in 137 Posts
I am not exactly sure where your cutoffs are, but if I am right, then this should work.
PHP Code:

<?php
$sw
=0;
require(
'../../../config/config.php');
$con mysql_connect($host,$dbuser,$dbpass);
if(!
$con){die('Could not connect: ' mysql_error());}
mysql_select_db ($dbname);
$location '../../../images/book_covers/';
echo
'<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,td,th {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    color: #FFF;
    font-weight: bold;
}
body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
    background-color: transparent;
}
a {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    color: #FFF;
    font-weight: bold;
}
a:visited {
    color: #FFF;
}
a:hover {
    color: #FFF;
}
a:active {
    color: #FFF;
}
-->
</style>
</head>
<body>
<table width="619" border="0" cellspacing="0" cellpadding="0">'
;
$query="SELECT * FROM books WHERE id between '1' and '4'";
$resultmysql_query($query);
while(
$row mysql_fetch_assoc($result))
{
 if(
$sw==0){
  echo 
'<tr>
         <td width="267" height="287" align="center" valign="middle" background="../../../images/books/books_backing.png">
          <table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
           <tr>
            <td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' 
.$row['id']. '" target="_top"><img src="' .$location.$row['cover']. '" width="142" height="204" border="0" /></a></td>
            <td width="10">&nbsp;</td>
            <td>&nbsp;</td>
            <td width="10">&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td align="center" valign="middle"><p>' 
.$row['name']. '</p></td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td height="20">&nbsp;</td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td align="center" valign="middle">&pound;' 
.$row['price']. '</td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td height="20">&nbsp;</td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td align="center" valign="middle"><a href="#">Buy it now</a></td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td height="70">&nbsp;</td>
            <td>&nbsp;</td>
           </tr>
           <tr>
            <td colspan="4" align="left" valign="top">' 
.$row['quote']. '</td>
           </tr>
          </table>
         </td>
         <td width="79" height="287" background="../../../images/books/books_spacer.png">&nbsp;</td>'
;
  }
 if(
$sw==1){
   
$sw=2;
   echo 
'<td width="273" height="287" align="center" valign="middle" background="../../../images/books/books_backing_r.png">
          <table width="245" height="269" border="0" cellspacing="0" cellpadding="0">
           <tr>
            <td rowspan="7" align="center" valign="top" width="142" height="204"><a href="../../view.php?book=' 
.$row['id']. '" target="_top"><img src="' .$location.$row['cover']. '" width="142" height="204" border="0" /></a></td>
            <td width="10">&nbsp;</td>
            <td>&nbsp;</td>
            <td width="10">&nbsp;</td>
           </tr>
           <tr>
            <td>&nbsp;</td>
            <td align="center" valign="middle"><p>' 
.$row['name']. '</p></td>
            <td>&nbsp;</td>
           </tr>
          <tr>
           <td>&nbsp;</td>
           <td height="20">&nbsp;</td>
           <td>&nbsp;</td>
          </tr>
          <tr>
           <td>&nbsp;</td>
           <td align="center" valign="middle">&pound;' 
.$row['price']. '</td>
           <td>&nbsp;</td>
          </tr>
          <tr>
           <td>&nbsp;</td>
           <td height="20">&nbsp;</td>
           <td>&nbsp;</td>
          </tr>
          <tr>
           <td>&nbsp;</td>
           <td align="center" valign="middle"><a href="#">Buy it now</a></td>
           <td>&nbsp;</td>
          </tr>
          <tr>
           <td>&nbsp;</td>
           <td height="70">&nbsp;</td>
           <td>&nbsp;</td>
          </tr>
          <tr>
           <td colspan="4" align="left" valign="top">' 
.$row['quote']. '</td>
          </tr>
         </table>
        </td>
       </tr>'
;
   }
  
// Do once, then two more records. //
  
echo '<tr>
         <td><img src="../../../images/books/spacer.gif" width="1" height="90" /></td>
         <td>&nbsp;</td>
         <td>&nbsp;</td>
        </tr>'
;
  if(
$sw==2){$sw=0;}
  else{
$sw=1;}
  }
echo 
'<tr>
       <td colspan="3"><img src="../../../images/books/spacer.gif" width="1" height="30" /></td>
      </tr>
     </table>
    </body>
   </html>'
;
mysql_close($con);
?>
__________________
Jerry Broughton

Last edited by job0107; 05-06-10 at 09:45 AM.
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
display x amount of vbulleting new post outside of vb forum? romeo2010 PHP 2 03-26-08 09:44 PM
Amount for Donation form (required) multimediakt PHP 1 12-08-06 10:53 AM
Customer enter amount paypal subscription & auto cpanel acc creation willing to pay! Jolin Script Requests 0 10-09-06 10:04 PM
amount of time x spends on my site pkcidstudio Script Requests 3 08-28-06 04:03 PM
please help... running 2 querys when only one should be ran... tc3driver PHP 2 08-30-05 08:17 PM


All times are GMT -5. The time now is 08:14 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.