PHP - Why Echo Is Not Echoin D Entire Field In Database

I actually asked a question here yesterday and decided to try a different route with it.  What I am doing is passing an email variable entered from my home page on to www.dollapal.com/offerlist.php.  I'm wanting this page to be a complete list of all of my entries in my surveys table.  The email variable needs to be appended to the end of every link.  I got that to work, but what I want to do now is display that information for every record in my 'surveys' table.

Right now I am using the random function, which I'm sure is wrong, but I'm not sure what function to be looking for.

Is it possible to use a foreach function here to echo each record?  If so, I'm not sure how exactly to call the foreach() function in this case.

I believe my two problems lie in the random and foreach functions, but I'm not sure how to correct them.  I've attached a little chunk of code that I'm working with.  I'm not sure if I'm completely off base here, or if I'm close to achieving my desired result.  Please let me know if you require more information.

This forum has been amazing to me so far.  Thank you all for your help!

Here is one part of php code. Here I try to show in last 1 month which dates exactly user made orders. When I run the SQL code in command prompt it works. I think problem is in while loop.

Thanks beforhand for contribution.


$query = "SELECT Date FROM orders WHERE User='$username' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= Date;";
$result = mysql_query($query,$link_id) or die (mysql_error());

echo "<table border='1'>
        <tr>
          <td>&nbsp;Last 1 month's orders:</td>
        </tr>";
   
      while($order_date = mysql_fetch_row($result)) {
        echo "<tr>";
          echo "<td>" . $order_date[0] . "</td>";
        echo "</tr>";
      }
     
      echo "</table>

<a href="entries.php?eid=<?php echo $row2->eid; ?>" class="n">Entry ID <?php echo $row2->eid; ?> by <?php echo $row2->username; ?></a>
My issue is that the second output of entry id works fine. The first output, being the more important, does not, even though they are identical. This will probably be something ridiculously stupid.

Hi guys

When I retrieve information from database into text field and update the fields, each time I press on update button, an space gets added before the text so in screenshots I have added you can see in image1 everything is fine but once I click on update, a space will be added before the text inside the text field.

Here is my code
<?php
session_start();
include ("global.php");


//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];



//welcome messaage
echo "Welcome, " .$_SESSION['username']."!<p>";

  if ($_POST['register'])
    {
     //get form data
     $name = addslashes(strip_tags($_POST['name']));
     $telephonenumber = addslashes(strip_tags($_POST['telephonenumber']));
     $buildingnumber = addslashes(strip_tags($_POST['buildingnumber']));
     $streetname = addslashes(strip_tags($_POST['streetname']));
     $town = addslashes(strip_tags($_POST['town']));
     $county = addslashes(strip_tags($_POST['county']));
     $country = addslashes(strip_tags($_POST['country']));
     $postcode = addslashes(strip_tags($_POST['postcode']));
     $email = addslashes(strip_tags($_POST['email']));

//update statements
   
$query = "UPDATE  userss   SET name =' $name' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET telephonenumber = ' $telephonenumber' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET buildingnumber = ' $buildingnumber' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET streetname = ' $streetname' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET county = ' $county' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET town = ' $town' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET country = ' $country' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET postcode = ' $postcode' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET email = ' $email' WHERE username='$username'";
$result = mysql_query($query);

}

//update from database to txt field
$update = "SELECT name, telephonenumber, buildingnumber, streetname, country, town, postcode, county, email FROM userss WHERE username='$username'";
$result = mysql_query($update);
$row = mysql_fetch_assoc($result);
 
 
 
?>
  <form action='updateprofile.php' method='POST'>
     Name:<br />
    <input type='text' name='name' value='<?php echo $row['name'];?>'><p />
    Telephone Number:<br />
    <input type='text' name='telephonenumber' value='<?php echo $row['telephonenumber'];?>'><p />
    Building Number:<br />
    <input type='text' name='buildingnumber' value='<?php echo $row['buildingnumber'];?>'><p />
    Street Name:<br />
     <input type='text' name='streetname' value='<?php echo $row['streetname'];?>'><p />
     County:<br />
     <input type='text' name='county' value='<?php echo $row['county'];?>'><p />
     Town:<br />
     <input type='text' name='town' value='<?php echo $row['town'];?>'><p />
     Country:<br />
      <input type='text' name='country' value='<?php echo $row['country'];?>'><p />
      Postcode:<br />
      <input type='text' name='postcode' value='<?php echo $row['postcode'];?>'><p />
      Email:<br />
      <input type='text' name='email' value='<?php echo $row['email'];?>'><p />
             
    <input type='submit' name='register' value='Update'>
    </form>


    <iframe width="750" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&amp;sll=&amp;sspn=0.007597,0.025921&amp;ie=UTF8&amp;hq=&amp;hnear=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&amp;ll=&amp;spn=0.011236,0.025921&amp;z=14&amp;output=embed"></iframe>


could someone kindly advice me on this please?

Hi,
I have a search results page that return the results based on "Make" & "Model" of vehicle.

The question is, can an image be echoed onto that results page based on which make and model has been searched for?

The image is stored in a field called "Image_Van"  so would need to display that depending on the row in that database that has been selected from Make & Model...

Hope this makes sense!


<?php

//info bars colour
$color_info="#D6D685"; // Almost Silver //FFFFCC
$color1="#E9E9E9";// Light Blue
$color2="#EAD5FF";// Light Blue


//include function library code

include_once("func_lib.php");

// use the user_connection include file's connectDB function

include_once("usr_conn.php");

if (!connectDB())

{


echo "<p>Unable To Connect To Database</p>";

return;
}

//test that make and model are passed in, if they are assign them
if (($_GET ['make'] == "MAKE") or ($_GET ['model'] == "MODEL"))

{
$errMessage =  "<br><br><b><font class=small>Your search hasn't returned any results, please re-enter your search again.</font></b><br><br><a href=van_accessories.php>Search again</a><br><br>";


}


else


{
// get search values for make and model, removing " and ' chars
$strMake = mysql_escape_string($_GET ['make']);















$strModel = mysql_escape_string($_GET ['model']);















}















// set the Prod_Type that is to be shown regardless of car make and model















$strDefaultProd = "XD";































//write query string that will pased in paging links















$strQuery = "make=".$strMake."&model=".$strModel."&";















//echo $strQuery;















//grab the page number that we're on















$page = mysql_escape_string($_GET ['page']);































//$strMake = "FIAT";















//$strModel = "Uno";































//create sql query















$sqlSelect = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Prod_REF, Product_Desc, Price_ExVat, image_name, Image_Van FROM products";

                                                                                        //change this back to 'FILL THIS IS IN' to switch accessories off!

$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Default_Code = 'SA')";


//$criteria = " WHERE Car_Make = '".$strMake."' AND Car_Model = '".$strModel."'";







// assign the basic sqlquery



$sqlquery = $sqlSelect . $criteria;



//echo $sqlquery; #debug











//get the result set



$result = mysql_query($sqlquery);



$count = mysql_num_rows($result);



$full_count = $count;















//set max number of records per page



$records_per_page = 999;







//Next figure out how many pages you'll have.



$total_pages = ceil( $count / $records_per_page );







/*















This just sets up a page variable which will be past in a "next" and "prev"















link.  The first link to this page may not actually have $page so this just















sets it up.















*/































if ( $page == "" ) { $page = 1; }































//echo "<br>page number".$page; #debug















































# this will set up the "First | Prev | " part of our navigation.















if ( $page == 1 ) {















    # if we are on the first page then "First" and "Prev"















    # should not be links.















    $naviagation = "<font color=\"#666666\">First</font> | <font color=\"#666666\">Prev</font> | ";















} else {















    # we are not on page one so "First" and "Prev" can















    # be links















    $prev_page = $page - 1;















    $navigation = "<a href=\"van_steps_results.php?".$strQuery."page=1\">First</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$prev_page."\">Prev</a> | ";















}































# this part will set up the rest of our navigation "Next | Last"















if ( $page == $total_pages ) {















    # we are on the last page so "Next" and "Last"















    # should not be links















   // $navigation .= "<font color=\"#666666\">Next</font> | <font color=\"#666666\">Last</font>";















} else {















    # we are not on the last page so "Next" and "Last"















    # can be links















    $next_page = $page + 1;















    $navigation .= "<a href=\"van_steps_results.php?".$strQuery."page=".$next_page."\">Next</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$total_pages."\">Last</a>";















}































/*















The final thing to do is your actual query, but first we have to figure out















what the offset will be.















*/















$offset = ( $page - 1 ) * $records_per_page;















//echo "<br>offset".$offset; #debug


//create sql query


$sqlSelect = "SELECT Car_Make, Car_Model, Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat, Link, image_name, Image_Van FROM products";


$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Car_Model = 'all' AND Default_Code = 'SA')";


$limit = " ORDER BY Priority ASC, Prod_Code ASC, Prod_ID ASC LIMIT $offset, $records_per_page";

// assign the basic sqlquery
$sqlquery = $sqlSelect . $criteria . $limit ;

//echo $sqlquery;

//get the result set

$result = mysql_query($sqlquery);
// if no matches found from query
if (!$result || (mysql_num_rows($result) == 0)){
//echo ("<b><font class=small>No matches were found.</font></b>");
}
// display the results
else{
// use rowcount to display total results found

$count = mysql_num_rows($result);

//echo $count;

//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Results Page:</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
<!--script src="js/jquery.lint.js" type="text/javascript" charset="utf-8"></script-->
<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" title="prettyPhoto main stylesheet" charset="utf-8" />
<script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>


<!--  start header graphic html -->

<style type="text/css">
<!--
.table {
border: 0px none;
border-collapse: separate;
}

BODY
{
}
A
{
    COLOR: #003366;
    TEXT-DECORATION: none;
}
A:hover
{
TEXT-DECORATION: underline;
color: #900;
}
.small
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.std
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR: #000000;
}
.header
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
.bigheader
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: BOLD;
    COLOR:#FFFFFF;
}
.error
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR:#FF0000
}
.headertable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#FFFFFF;
    BACKGROUND-COLOR:#000066;
}
.stdtable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#000066;
}
.style16 {font-size: 11px}
.style7 { color: #CC0000;
font-style: italic;
}
.small1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.header1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
a:link {
color: #900;
}
-->
</style>




<div align="center">
  <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td background=""><table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
        <tr>
          <td bgcolor="#003366">&nbsp;</td>
        </tr>
      </table>

        <!--END header-->
        
        <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
              <tr>
                <td><div align="center">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td class="arial11"><table width="100%" border="0" cellpadding="10" cellspacing="0">
                        <tr>
                          <td width="33%"><p><img src="2003/results.gif" alt="" width="238" height="43" /></p>
                            <p>&nbsp;</p>
                            <p>&nbsp;</p></td>
                          </tr>
                        </table></td>
                    </tr>
                  </table>
                </div></td>
              </tr>
            </table>
              <table width="950" border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#FFFFFF">
                <tr align="center" valign="top" class="std">
                  <td colspan="7"><hr width="500" size="1" />
                    <?php















if (isset($errMessage)){















echo $errMessage;















}















// if no matches found from query















if (!$result || (mysql_num_rows($result) == 0))















echo ("<b><font class=small>No matches were found.</font></b><br><br>");































// display the results















else{















// use rowcount to display total results found















echo("<br><p><em><font class=vehicle>Search Results for " . $strMake . "&nbsp;" . $strModel .".</em> Total Matches Found = " . $full_count . "</p>"); //*debug















echo $navigation;



}




/*



With your navigation built you can just echo that out any where you want it



to appear.



*/



//echo $navigation;



?></td>
                </tr>
                <?php



$title =  "<tr align=\"center\" class=\"headertable\" height=\"32\">";


$title .= "<td width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"1\" /></td>";

    $title .= "<td width=\"60\">Make</td>";



    $title .= "<td width=\"60\">Ref No.</td>";



    $title .= "<td width=\"550\">Title/Description</td>";



    $title .= "<td width=\"73\">Price Ex VAT</td>";



    $title .= "<td width=\"73\">Price Inc VAT</td>";



    $title .= "<td width=\"60\"><img src=\"2003/basket.gif\" width=\"21\" height=\"14\"></td>";



    $title .= "</tr>";































//set the counters for the records results display screen















$cnt = 0;















$headercount1 = 0;















$headercount2 = 0;















$headercount3 = 0;















$headercount4 = 0;















$headercount5 = 0;















$headercount6 = 0;















$headercount7 = 0;



























while ($row = mysql_fetch_assoc($result))















{































//cut the prod_type variable















//get the length of the variable















$strLength = strlen ($row["Prod_Type"]);















//assign first 2 characters of variable















$strPrefix = substr($row["Prod_Type"], 0, 2);















//debug















//echo "\n prefix :" . $strPrefix;















//assign remaining characters of variable















$strSuffix = substr($row["Prod_Type"], 2, $strLength);















//debug















//echo "\n suffix :" . $strSuffix;































































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=center><td colspan=7 class=small>";










//set bg cell color diff for BH make
switch ($strPrefix)
{
case "BH":
$color=$color2;
break;

default:
$color=$color1;
break;
}//end switch


switch ($strPrefix)
{

   case "BH":

        if ($headercount1 == 0)

{

echo "<img border=0 src=2003/searchheaders/step.jpg></td></tr>";
echo $title;
}
$headercount1 ++;

//$headercount1


       break;

  // REMOVE ALL THIS COMMENTING IF NEEDED TO SHOW THE ROOF BARS!  case "RB":

     //  if ($headercount2 == 0)
// {
// echo "<img border=0 src=2003/searchheaders/NOTUSED.jpg alt=Roof-Bars></td></tr>";
// echo $title;
// }

// $headercount2 ++;

//$headercount1

       break;

case "BX":
        if ($headercount3 == 0)
{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Roof-Boxes></td></tr>";
echo $title;
}
$headercount3 ++;

//$headercount1

       break;
case "BR":


        if ($headercount4 == 0)

{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Bike-Racks></td></tr>";

echo $title;

}


$headercount4 ++;

//$headercount1

       break;
case "SR":
        if ($headercount5 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Ski-Rack></td></tr>";
echo $title;
}

$headercount5 ++;


//$headercount1


       break;
case "CR":

        if ($headercount6 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Canoe-Rack></td></tr>";



echo $title;
}


$headercount6 ++;

//$headercount1

       break;

case "XD":

 if ($headercount7 == 0)

{


echo "<img border=0 src=2003/searchheaders/towbar.jpg alt=General-Accessories></td></tr>";
echo $title;

}



$headercount7 ++;


}















//end header image selection and close the table row.















//echo "</td></tr>";































// if (($cnt++)%2)
// {
// $color="#E9E9E9"; // Almost Silver
// }
//     else
// {
// $color="#E9E9E9";// Light Blue
// }































//print a product row if the prodtype isn't set to INFO



$pop_link = "";







if ($strSuffix != "INFO"){







//test to see if an image exists for the product



if ($row["Link"] <> NULL){



$pop_link = "&nbsp;&nbsp;&nbsp;<a href=\"products/".$row["Link"]."?iframe=true&width=650&height=500\" rel=\"prettyPhoto\" >More information >>>></a>";



}







echo "<tr class=stdtable align=center height=25>";


//DISPLAY THUMB IMAGE IF ONE WAS LISTED IN THE image_name FIELD
$p_Image_Van = htmlspecialchars($row["Image_Van"]);
//echo "p_Image_Van:$p_image_name";
if ($p_Image_Van != "")
echo "<td bgcolor=$color width=\"95\"><img src=\"images/product_images/$p_Image_Van\" border=\"0\" /></td>";
else
echo "<td bgcolor=$color width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"50\" border=\"0\" /></td>";


echo "<td bgcolor=$color width=\"60\">". htmlspecialchars($row["Prod_Make"]) .




"</td><td bgcolor=$color width=\"60\">" . htmlspecialchars($row["Prod_REF"]) .















"</td><td bgcolor=$color align=left class=\"infolink\" width=\"550\">" . htmlspecialchars($row["Product_Desc"]) .







$pop_link .







"</td><td bgcolor=$color width=\"73\">&pound;" . number_format(htmlspecialchars($row['Price_ExVat']), 2) .















"</td><td bgcolor=$color width=\"73\">&pound;" . number_format((calcVAT (htmlspecialchars($row['Price_ExVat']))), 2) .















"</td><td bgcolor=$color width=\"60\"><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=7 bgcolor=$color_info><em><strong>" . htmlspecialchars($row["Product_Desc"]) . "</strong></em></td></tr>";















}















}















































//******************************************************************************************************







/*







//get all porducts from the database that are marked with prod_type XD regardless of car make and model















$sqlSelectDefault = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat FROM products";















$criteriaDefault = " WHERE Prod_Type LIKE '".$strDefaultProd."%'";















$limitDefault = "ORDER BY Priority ASC, Prod_Code ASC";































// assign the basic sqlquery















$sqlqueryDefault = $sqlSelectDefault . $criteriaDefault . $limitDefault ;















//echo $sqlquery;































//get the result set















$resultDefault = mysql_query($sqlqueryDefault);















































// if no matches found from query















if (!$resultDefault || (mysql_num_rows($resultDefault) == 0)){















//echo ("<b><font class=small>No matches were found.</font></b>");















}















// display the results















else{















// use rowcount to display total results found















$countDefault = mysql_num_rows($resultDefault);















//echo $count;















//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug















}































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=left><td colspan=6 class=small>";































echo "<img border=0 src=2003/searchheaders/general.jpg alt=General-Accessories>";































echo "</td></tr>";































while ($rowDefault = mysql_fetch_assoc($resultDefault))















{































//cut the prod_type variable















//get the length of the variable















$strLengthDefault = strlen ($rowDefault["Prod_Type"]);















//assign first 2 characters of variable















$strPrefixDefault = substr($rowDefault["Prod_Type"], 0, 2);















//debug















//echo htmlspecialchars($rowDefault["Prod_ID"]);















//echo "\n prefix :" . $strPrefixDefault;















//assign remaining characters of variable















$strSuffixDefault = substr($rowDefault["Prod_Type"], 2, $strLengthDefault);















//debug















//echo "\n suffix :" . $strSuffixDefault;















































if ($strSuffixDefault != "INFO"){















$color="#E9E9E9"; // Almost Silver















//print a product row if the prodtype isn't set to INFO















echo "<tr class=stdtable align=center height=25 ><td bgcolor=$color>". htmlspecialchars($rowDefault["Prod_Make"]) .















"</td><td bgcolor=$color>" . htmlspecialchars($rowDefault["Prod_REF"]) .















"</td><td bgcolor=$color align=left>" . htmlspecialchars($rowDefault["Product_Desc"]) .















"</td><td bgcolor=$color>?" . number_format(htmlspecialchars($rowDefault['Price_ExVat']), 2) .















"</td><td bgcolor=$color>?" . number_format((calcVAT (htmlspecialchars($rowDefault['Price_ExVat']))), 2) .















"</td><td bgcolor=$color><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $rowDefault["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=6 bgcolor=$color><em>" . htmlspecialchars($rowDefault["Product_Desc"]) . "</em></td></tr>";















}















}











*/



?>
                <tr align="center">
                  <td colspan="7" class="small1"></td>
                </tr>
                <tr>
                  <!-- <tr align="center" class="headertable" height="32">















          <td width="145">Product Name</td>















          <td width="178">Ref No.</td>















          <td width="280">Description</td>















          <td width="73">Price Ex VAT</td>















          <td width="73">Price Inc VAT</td>















          <td width="60"><img src="2003/basket.gif" width="21" height="14"> </td>















        </tr>-->
                  <td colspan="7" height="1" bgcolor="#003366"><img src="colour_spacer.gif" width="756" height="1" /></td>
                </tr>
            </table></td>
          </tr>
        </table>
        <p><br />
          </p>
        </p>
        <div align="center"><br />
        </div>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td>&nbsp;</td>
          </tr>
</table>
        <?php































//free up some memory















mysql_free_result($result);



// close the aatabase connection

mysql_close();

//include footer code


?>
        <br />
      </table>


</html>