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
 
LinkBack Thread Tools Display Modes
  #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'";

       $result= mysql_query($query);



       $row = mysql_fetch_assoc($result);

       

       $query2="SELECT * FROM books WHERE id='2'";

       $result2= mysql_query($query2);



       $row2 = mysql_fetch_assoc($result2);

       

       $query3="SELECT * FROM books WHERE id='3'";

       $result3= mysql_query($query3);



       $row3 = mysql_fetch_assoc($result3);

       

       $query4="SELECT * FROM books WHERE id='4'";

       $result4= mysql_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'";
$result= mysql_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

« Share your web programming knowledge, Help others and be an Expert | how to call a php function while click on html button? »

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

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.