Hi there,
Can you please have a look at the following code:
I've got two questions;
1. I'm trying not to display the fields that are empty with: if
(!empty($row9->prijs4pk)){
But it's still display the line and there is no value in PRIJS4PK field.
2. How can i reduce the amount of Queries??
Thanks for your time and help,
Frank
The code:
<?
// Avaibility and prices
include("../conf/config.php");
include("../conf/functions.php");
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
//Get ID
$id=$_GET['id'];
$page=$_GET['page'];
// limit value for number of records to be shown per page
// query database to find total number of records to display
$limit = 10;
$query_count = "SELECT date, prijs2pk, prijs1pk FROM date WHERE reisid = '$id'";
$result_count = mysql_query($query_count);
$totalrows = mysql_num_rows($result_count);
if(empty($page))
$page = 1;
$limitvalue = $page * $limit - ($limit);
$query = "SELECT date, prijs2pk, prijs1pk FROM date WHERE reisid = '$id' ORDER BY date
LIMIT $limitvalue, $limit ";
$result = mysql_query($query) or die("Error: " . mysql_error());
$count_result = mysql_num_rows($result);
$query2 = "SELECT date, prijs2pk, prijs1pk FROM date WHERE reisid = '$id' ORDER BY
date LIMIT $limitvalue, $limit ";
$result2 = mysql_query($query2) or die("Error: " . mysql_error());
$query3 = "SELECT date, prijs2pk, prijs1pk FROM date WHERE reisid = '$id' ORDER BY
date LIMIT $limitvalue, $limit ";
$result3 = mysql_query($query3) or die("Error: " . mysql_error());
$query5 = "SELECT date, prijs4pk, prijs3pk, prijs2pk, prijs1pk FROM date WHERE reisid
= '$id' ORDER BY date LIMIT $limitvalue, $limit ";
$result5 = mysql_query($query5) or die("Error: " . mysql_error());
$query6 = "SELECT date, prijs4pk, prijs3pk, prijs2pk, prijs1pk FROM date WHERE reisid
= '$id' ORDER BY date LIMIT $limitvalue, $limit ";
$result6 = mysql_query($query6) or die("Error: " . mysql_error());
$query4 = "SELECT naamreis FROM reizen WHERE reisid = '$id'";
$result4 = mysql_query($query4) or die("Error: " . mysql_error());
$row4 = mysql_fetch_object($result4);
$query9 = "SELECT totaalprijs, prijs4pk, prijs5pk, prijs3pk, prijs2pk, prijs1pk FROM
date WHERE reisid = '$id'";
$result9= mysql_query($query9) or die("Error: " . mysql_error());
$row9 = mysql_fetch_object($result9);
// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;
?>
<html>
<head>
<link href="../css/main.css" rel="stylesheet" type="text/css">
</head>
<body>
<body bgcolor="#F2D071">
<?
echo "<font class=\"bold\">" . $row4->naamreis . "</font>";
?>
<br><br><TR bgColor=#ffcc00>
<TD colSpan=3 height=126>
<TABLE cellSpacing=1 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD class=standaardwit width="14%" bgColor=#ff9900>
<DIV align=right></DIV></TD>
<?
if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_object($result))
{
echo "<TD width=40 bgColor=#ffffff height=38><DIV align=right>".
formatDateShort($row->date) . "</DIV></TD>";
}
}
?>
</TR>
<?
if (!empty($row9->prijs4pk)){
?>
<TR>
<TD class=standaardwit width="14%" bgColor=#ff9900>
<DIV align=right>4 pk</DIV></TD>
<?
if (mysql_num_rows($result6) > 0)
{
while($row5= mysql_fetch_object($result5))
{
$pr6 = number_format($row5->prijs4pk,0);
echo "<TD class=standaard width=40 bgColor=#ffffff><DIV align=right>". $pr6 .
"</DIV></TD>";
}
}
}
if (!empty($row99->prijs3pk)){
?>
<TR>
<TD class=standaardwit width="14%" bgColor=#ff9900>
<DIV align=right>3 pk</DIV></TD>
<?
if (mysql_num_rows($result5) > 0)
{
while($row5= mysql_fetch_object($result5))
{
$pr5 = number_format($row5->prijs3pk,0);
echo "<TD class=standaard width=40 bgColor=#ffffff><DIV align=right>". $pr5 .
"</DIV></TD>";
}
}
}
if (!empty($row9->prijs2pk)){
?>
<TR>
<TD class=standaardwit width="14%" bgColor=#ff9900>
<DIV align=right>2 pk</DIV></TD>
<?
if (mysql_num_rows($result2) > 0)
{
while($row2= mysql_fetch_object($result2))
{
$pr2 = number_format($row2->prijs2pk,0);
echo "<TD class=standaard width=40 bgColor=#ffffff><DIV align=right>". $pr2 .
"</DIV></TD>";
}
}
}
?>
<?
if (!empty($row9->prijs1pk)){
?>
<TR>
<TD class=standaardwit width="14%" bgColor=#ff9900>
<DIV align=right>1 pk</DIV></TD>
<?
if (mysql_num_rows($result3) > 0)
{
while($row3= mysql_fetch_object($result3))
{
$pr1 = number_format($row3->prijs1pk,0);
echo "<TD class=standaard width=40 bgColor=#ffffff><DIV align=right>". $pr1 .
"</DIV></TD>";
}
}
}
// start 123 next>> table
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\"
cellpadding=\"0\">
<tr><td width=\"50%\" bgcolor=\"$bg_colour\"
align=\"left\">";if($numofpages>1){echo"</td><td width=\"50%\" bgcolor=\"$bg_colour\"
align=\"right\"><b></b> ";}
// display previous link if page is not 1
if($page != 1){
$pageprev = $page - 1;
echo("<a href=\"$PHP_SELF?id=$id&page=$pageprev&search=$search\"><< Terug</a> ");
}
// display page nos if not 1
for($i = 1; $i <= $numofpages; $i++){
if($numofpages>1){
if($i == $page)
echo(" ".$i." ");
else
echo(" <a href=\"$PHP_SELF?id=$id&page=$i&search=$search\">$i</a> ");
}}
// display next page link if there is more than one
if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page + 1;
echo("<a href=\"$PHP_SELF?id=$id&page=$pagenext&search=$search\">Volgende >></a>");
}
// end 123 next>> table
echo"</td></tr></table><br>";
?>
</TR> </TBODY></TABLE></TD></TR></html>
