Jump to content

[SOLVED] Search Results Query


Jack8900

Recommended Posts

I recently download a script and this is the page where it shows results of the database. At the bottom of the script I want to create an option so if no results are shown then display a message (in bold at the bottom). Would someone be able to figure it out for me please as I haven't got a clue where to start.

 

Thanks

 

<?

session_start();

    include "./admin/global.php";

    include_once "header.php";

?>

<SCRIPT language=JavaScript type=text/JavaScript>

function MM_findObj(n, d) { //v4.01

  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

  if(!x && d.getElementById) x=d.getElementById(n); return x;

}

 

function YY_Animateimg() { //v3.04

  //copyright ©1999,2001 yaromat.com

  var args = YY_Animateimg.arguments;

  if (document.images){

    var yyani=eval(args[1]);

    if (args.length>5){

      eval(args[3]+"= new Array()");

      for (var i=5;i<args.length;i=i+2){

        eval(args[3]+"["+ args[3] + ".length]= new Image")

        eval(args[3]+"["+ args[3] + ".length-1].src=\'"+args+"\'")

        eval(args[3]+"["+ args[3] + ".length-1].yyto=\'"+args[i+1]+"\'")

      }

    }

    var yyImgArray = eval(args[3]);

    var yyImage = MM_findObj(args[4]);

    if(yyImgArray[yyani]){

      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);

      if(yyImage)yyImage.src = yyImgArray[yyani].src;

    }

    if(yyani>=yyImgArray.length-1){args[0]=(args[0]!="-1")?(args[0]-1):args[0]}

    var argStr= 'YY_Animateimg(\"' +args[0]+ '\",\"' +((yyani>=yyImgArray.length-1 && args[0]!=0)?'0':(yyani+1));

    for (var i=2;i<5;i++){argStr+='\",\"'+args}

    argStr+='\")';

    if ((yyani<yyImgArray.length-1) || args[0]!=0&&yyImgArray[yyani]){

      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);

      yyImgArray[yyani].yyTimeout = setTimeout(argStr,yyImgArray[yyani].yyto);

    }else{if(args[2]!='#')setTimeout(args[2],10)}

  }

}

</SCRIPT>

                  <SCRIPT language=javascript

                  src="Common.js">

</SCRIPT>

<?

echo "<table border=\"0\" width=\"99%\" cellspacing=\"0\" cellpadding=\"0\">\n";

 

function get_array ($test) {

unset($test1);

$j = 0;

$i = 0;

while ( $j < sizeof ($test)) {

if ( !empty ($test[$i])) {

$test1[$j] = $test[$i];

$j++;

}

$i++;

}

return ($test1);

}

 

if ( $submit) {

session_register ("ses_title"); 

session_register ("ses_make"); 

session_register ("ses_fuel"); 

session_register ("ses_cat"); 

session_register ("ses_price"); 

session_register ("ses_price1"); 

session_register ("ses_year"); 

session_register ("ses_year1"); 

session_register ("ses_miles"); 

session_register ("ses_miles1"); 

session_register ("ses_door"); 

session_register ("ses_extra"); 

session_register ("ses_sort"); 

}

 

if ( $submit == $frontend_labels["SEARCH"] ) {

session_register ("ses_title"); 

session_register ("ses_make"); 

session_register ("ses_fuel"); 

session_register ("ses_cat"); 

session_register ("ses_price"); 

session_register ("ses_price1"); 

session_register ("ses_year"); 

session_register ("ses_year1"); 

session_register ("ses_miles"); 

session_register ("ses_miles1"); 

session_register ("ses_door"); 

session_register ("ses_extra"); 

session_register ("ses_sort"); 

 

$_SESSION["ses_title"] = $ses_title = $title;

$_SESSION["ses_make"][0] = $ses_make[0] = $make[0];

$_SESSION["ses_fuel"] = $ses_fuel = get_array( $fuel);

$_SESSION["ses_cat"][0] = $ses_cat[0] = $cat[0];

$_SESSION["ses_price"] = $ses_price = $price + 1;

$_SESSION["ses_price1"] = $ses_price1 = $price1 - 1;

$_SESSION["ses_year"] = $ses_year = $year + 1;

$_SESSION["ses_year1"] = $ses_year1 = $year1 - 1;

$_SESSION["ses_miles"] = $ses_miles = $miles + 1;

$_SESSION["ses_miles1"] = $ses_miles1 = $miles1 - 1;

$_SESSION["ses_door"][0] = $ses_door[0] = $door[0];

$_SESSION["ses_extra"] = $ses_extra = get_array( $extra);

}

 

if ( !empty ($sort) ) {

$ses_sort = $sort;

}

 

if ( empty($sort) && empty($ses_sort)) {

$ses_sort = $site."_motor.title";

}

 

{

 

$sql = "select distinct ".$site."_motor.id,".$site."_motor.title,".$site."_motor.price,

".$site."_category.name,".$site."_motor.des, 

".$site."_motor.model, ".$site."_make.name, ".$site."_motor.status

from ".$site."_motor,".$site."_category, ".$site."_make  ";

 

if ( !empty($ses_extra) && (sizeof ($ses_extra) > 0)) {

$sql .= ",".$site."_pars where ".$site."_pars.article_id = ".$site."_motor.id ";

$sql .= " and ".$site."_pars.par_id = ( ";

for ( $i = 0; $i < sizeof ($ses_extra);$i++) {

if ( $i > 0) {

$sql .= " and ";

}

$sql .= "  '$ses_extra[$i]'";

}

$sql .= " ) and ";

} else

 

{

$sql .= " where ";

}

$sql .= " ".$site."_make.id = ".$site."_motor.make and ".$site."_motor.price > 0 and  ".$site."_category.id = ".$site."_motor.cat and ".$site."_motor.id != '0' and active = 'y' ";

 

 

if ( !empty($ses_title)) {

$sql .= "and (".$site."_motor.title like '%$ses_title%' or ".$site."_motor.des like '%$ses_title%') ";

}

 

if ( $ses_make[0] != '' && (sizeof ($ses_make) > 0)) {

$sql .= " and ( ";

for ( $i = 0; $i < sizeof ($ses_make);$i++) {

if ( $i > 0) {

$sql .= " or ";

}

$sql .= "".$site."_motor.make = '$ses_make[$i]'";

}

$sql .= " ) ";

}

 

if ( !empty($ses_fuel) && (sizeof ($ses_fuel) > 0)) {

$sql .= " and ( ";

for ( $i = 0; $i < sizeof ($ses_fuel);$i++) {

if ( $i > 0) {

$sql .= " or ";

}

$sql .= "".$site."_motor.fuel = '$ses_fuel[$i]'";

}

$sql .= " ) ";

}

 

if ( $ses_cat[0] != '' && (sizeof ($ses_cat) > 0)) {

$sql .= " and ( ";

for ( $i = 0; $i < sizeof ($ses_cat);$i++) {

if ( $i > 0) {

$sql .= " or ";

}

$sql .= "".$site."_motor.cat = '$ses_cat[$i]'";

}

$sql .= " ) ";

}

 

if ( $ses_door[0] != '' && (sizeof ($ses_door) > 0)) {

$sql .= " and ( ";

for ( $i = 0; $i < sizeof ($ses_door);$i++) {

if ( $i > 0) {

$sql .= " or ";

}

$sql .= "".$site."_motor.no_of_doors = '$ses_door[$i]'";

}

$sql .= " ) ";

}

 

if ( !empty($ses_price) && $ses_price > 1) {

$sql .= "and ".$site."_motor.price < '$ses_price' ";

}

if ( !empty($ses_price1)  && $ses_price1 > 1) {

$sql .= "and ".$site."_motor.price > '$ses_price1' ";

}

 

if ( !empty($ses_year)  && $ses_year > 1) {

$sql .= "and ".$site."_motor.year < '$ses_year' ";

}

if ( !empty($ses_year1)  && $ses_year1 > 1) {

$sql .= "and ".$site."_motor.year > '$ses_year1' ";

}

 

if ( !empty($ses_miles)  && $ses_miles > 1) {

$sql .= "and ".$site."_motor.miles < '$ses_miles' ";

}

if ( !empty($ses_miles1)  && $ses_miles1 > 1) {

$sql .= "and ".$site."_motor.miles > '$ses_miles1' ";

}

 

$sql .= " group by ".$site."_motor.id ";

$result = mysql_query ( $sql);

$counter = mysql_num_rows( $result);

 

 

echo "<tr><td colspan='2' height='10'></td></tr>\n";

 

echo "<tr>\n";

echo "<td valign=\"top\" class=\"bodyfont\">\n";

if ($webmaster_search != 'n') {

if (($start+$display_count_main) > $counter) {

$temp = $counter;

} else {

$temp = $start+$display_count_main;

}

echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];

}

echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

 

if ( empty ($start)) {

$start = 0;

}

 

$page_count=ceil ($counter/$display_count_main);

if ( $start > 0) {

$start1 = $start - $display_count_main;

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";

}

 

if ( $page_count > 0) {

echo $frontend_labels["PAGE"];

for ( $i = 0; $i < $page_count; $i++) {

$start1 = $i * $display_count_main ;

if ( $start != $start1) {

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";

} else {

echo "[".($i+1)."]";

}

}

}

 

$start1 = $start + $display_count_main;

if ( ($counter) > $start1 ) {

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";

}

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

 

if ( $ses_sort) {

$sql .= " order by $ses_sort ";

}

$sql .= " limit $start,$display_count_main";

 

 

$result = mysql_query ( $sql);

while ( $row = mysql_fetch_row( $result)) {

echo "<a name=\"$row[1]\"></a>";

 

echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";

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

 

echo "<tr><td colspan=\"2\">";

echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";

 

echo "<tr>\n<td class=\"bodyfontdkgrey\">\n";

echo "$row[1]";

 

if ( $row[7] == $admin_fields["SOLD"]) {

echo " - <font color='#ff0000'>".$admin_fields["SOLD"]."</font>";

}

else if ( $row[7] == $admin_fields["AWAITING PREPARATION"]) {

echo " - ".$admin_fields["AWAITING PREPARATION"]."";

}

 

echo "</td>\n<td class=\"bodyfont\" align=\"right\">";

echo "$default_currency $row[2]  <a href=\"offer_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\"  class=\"links\">".$frontend_labels["OFFER"]."</a>";

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

 

echo "<tr>\n<td colspan=\"2\">\n";

echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";

 

echo "<tr>\n<td class=\"bodyfont\" align=\"center\">\n";

 

if(file_exists("./admin/uploaded_photos/".$row[0]."_3")) {

echo "<a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" >

<img src='./admin/uploaded_photos/".$row[0]."_3'  alt=\"View $row[1]\" border='0'></a>\n";

} else {

echo ("<table width=\"100\" height=\"74\" bgcolor=\"#f4f4f4\"><tr><td align=\"center\" class=\"bodyfontdkgrey\" valign=\"middle\">".$frontend_labels["NO_IMAGE"]."</td></tr></table>");

}

 

echo "</td>";

echo "<td width=\"80%\" class=\"bodyfont\" valign=\"bottom\"><br><br>".nl2br($row[4]);

 

  $sql1 = "select ".$site."_pars.article_id, ".$site."_miles.name from ".$site."_pars, ".$site."_miles

    where article_id = '$row[0]' and par_id = ".$site."_miles.id order by article_id";

 

  $result1 = mysql_query($sql1);

 

if ( mysql_num_rows( $result1) > 0) {

echo "<br><br>";

echo "<span class=\"bodyfontbluesm\">".$frontend_labels["FEATURES"]."</span>";

echo "\n";

}

  while ( $row1 = mysql_fetch_row($result1)) {

echo " : $row1[1]";

  }

   

echo " <div align=\"right\"><a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" class=\"links\" title=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\" >".$frontend_labels["VIEW_DETAILS"]." <img src=\"images/viewicon.gif\" width=\"12\" height=\"12\" border=\"0\" alt=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\"></a></div></td>\n</tr>\n";

echo "</table>\n";

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

 

echo "</table>\n";

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

}

 

echo "<tr><td colspan=\"2\" height=\"10\"  class=\"bodyfont\">";

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

 

 

echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";

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

 

echo "<tr>\n";

echo "<td valign=\"top\" class=\"bodyfont\">\n";

if ($webmaster_search != 'n') {

if (($start+$display_count_main) > $counter) {

$temp = $counter;

} else {

$temp = $start+$display_count_main;

}

echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];

}

echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

 

if ( empty ($start)) {

$start = 0;

}

 

$page_count=ceil ($counter/$display_count_main);

if ( $start > 0) {

$start1 = $start - $display_count_main;

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";

}

 

if ( $page_count > 0) {

echo $frontend_labels["PAGE"];

for ( $i = 0; $i < $page_count; $i++) {

$start1 = $i * $display_count_main ;

if ( $start != $start1) {

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";

} else {

echo "[".($i+1)."]";

}

}

}

 

$start1 = $start + $display_count_main;

if ( ($counter) > $start1 ) {

echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";

}

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

 

echo "<tr><td colspan=\"2\" height=\"10\">";

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

}

echo "</table>";

  if ()

{

  echo "<p align=\"center\"><br><br>Currently we do not have any vehicles of this category for sale.<br><br>If you get in touch with us we might be able to help you further.<br><br><strong>Thanks</strong></p><br>";

  }

    include_once "./footer.php";

?>

Link to comment
https://forums.phpfreaks.com/topic/168555-solved-search-results-query/
Share on other sites

Try this

 

<?php
session_start();
     include "./admin/global.php";
     include_once "header.php";
?>
<SCRIPT language=JavaScript type=text/JavaScript>
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function YY_Animateimg() { //v3.04
  //copyright (c)1999,2001 yaromat.com
  var args = YY_Animateimg.arguments;
  if (document.images){
    var yyani=eval(args[1]);
    if (args.length>5){
      eval(args[3]+"= new Array()");
      for (var i=5;i<args.length;i=i+2){
        eval(args[3]+"["+ args[3] + ".length]= new Image")
        eval(args[3]+"["+ args[3] + ".length-1].src=\'"+args+"\'")
        eval(args[3]+"["+ args[3] + ".length-1].yyto=\'"+args[i+1]+"\'")
      }
    }
    var yyImgArray = eval(args[3]);
    var yyImage = MM_findObj(args[4]);
    if(yyImgArray[yyani]){
      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);
      if(yyImage)yyImage.src = yyImgArray[yyani].src;
    }
    if(yyani>=yyImgArray.length-1){args[0]=(args[0]!="-1")?(args[0]-1):args[0]}
    var argStr= 'YY_Animateimg(\"' +args[0]+ '\",\"' +((yyani>=yyImgArray.length-1 && args[0]!=0)?'0':(yyani+1));
    for (var i=2;i<5;i++){argStr+='\",\"'+args}
    argStr+='\")';
    if ((yyani<yyImgArray.length-1) || args[0]!=0&&yyImgArray[yyani]){
      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);
      yyImgArray[yyani].yyTimeout = setTimeout(argStr,yyImgArray[yyani].yyto);
    }else{if(args[2]!='#')setTimeout(args[2],10)}
  }
}
</SCRIPT>
                  <SCRIPT language=javascript
                  src="Common.js">
</SCRIPT>
<?php
echo "<table border=\"0\" width=\"99%\" cellspacing=\"0\" cellpadding=\"0\">\n";

   function get_array ($test) {
      unset($test1);
      $j = 0;
      $i = 0;
      while ( $j < sizeof ($test)) {
         if ( !empty ($test[$i])) {
            $test1[$j] = $test[$i];
            $j++;
         }
         $i++;
      }
      return ($test1);   
   }

if ( $submit) {
      session_register ("ses_title");   
      session_register ("ses_make");   
      session_register ("ses_fuel");   
      session_register ("ses_cat");   
      session_register ("ses_price");   
      session_register ("ses_price1");   
      session_register ("ses_year");   
      session_register ("ses_year1");   
      session_register ("ses_miles");   
      session_register ("ses_miles1");   
      session_register ("ses_door");   
      session_register ("ses_extra");   
      session_register ("ses_sort");   
}

   if ( $submit == $frontend_labels["SEARCH"] ) {
      session_register ("ses_title");   
      session_register ("ses_make");   
      session_register ("ses_fuel");   
      session_register ("ses_cat");   
      session_register ("ses_price");   
      session_register ("ses_price1");   
      session_register ("ses_year");   
      session_register ("ses_year1");   
      session_register ("ses_miles");   
      session_register ("ses_miles1");   
      session_register ("ses_door");   
      session_register ("ses_extra");   
      session_register ("ses_sort");   

      $_SESSION["ses_title"] = $ses_title = $title;
      $_SESSION["ses_make"][0] = $ses_make[0] = $make[0];
      $_SESSION["ses_fuel"] = $ses_fuel = get_array( $fuel);
      $_SESSION["ses_cat"][0] = $ses_cat[0] = $cat[0];
      $_SESSION["ses_price"] = $ses_price = $price + 1;
      $_SESSION["ses_price1"] = $ses_price1 = $price1 - 1;
      $_SESSION["ses_year"] = $ses_year = $year + 1;
      $_SESSION["ses_year1"] = $ses_year1 = $year1 - 1;
      $_SESSION["ses_miles"] = $ses_miles = $miles + 1;
      $_SESSION["ses_miles1"] = $ses_miles1 = $miles1 - 1;
      $_SESSION["ses_door"][0] = $ses_door[0] = $door[0];
      $_SESSION["ses_extra"] = $ses_extra = get_array( $extra);
   }

   if ( !empty ($sort) ) {
      $ses_sort = $sort;
   }   
   
   if ( empty($sort) && empty($ses_sort)) {
      $ses_sort = $site."_motor.title";
   }   

   {

   $sql = "select distinct ".$site."_motor.id,".$site."_motor.title,".$site."_motor.price,
         ".$site."_category.name,".$site."_motor.des, 
         ".$site."_motor.model, ".$site."_make.name, ".$site."_motor.status
         from ".$site."_motor,".$site."_category, ".$site."_make  ";
   
   if ( !empty($ses_extra) && (sizeof ($ses_extra) > 0)) {
      $sql .= ",".$site."_pars where ".$site."_pars.article_id = ".$site."_motor.id ";
         $sql .= " and ".$site."_pars.par_id = ( ";
         for ( $i = 0; $i < sizeof ($ses_extra);$i++) {
            if ( $i > 0) {
               $sql .= " and ";
            }
            $sql .= "  '$ses_extra[$i]'";
         }
         $sql .= " ) and ";   
   } else
   
   {
      $sql .= " where ";
   }
   $sql .= " ".$site."_make.id = ".$site."_motor.make and ".$site."_motor.price > 0 and  ".$site."_category.id = ".$site."_motor.cat and ".$site."_motor.id != '0' and active = 'y' ";


      if ( !empty($ses_title)) {
         $sql .= "and (".$site."_motor.title like '%$ses_title%' or ".$site."_motor.des like '%$ses_title%') ";
      }

      if ( $ses_make[0] != '' && (sizeof ($ses_make) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_make);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.make = '$ses_make[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( !empty($ses_fuel) && (sizeof ($ses_fuel) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_fuel);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.fuel = '$ses_fuel[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( $ses_cat[0] != '' && (sizeof ($ses_cat) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_cat);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.cat = '$ses_cat[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( $ses_door[0] != '' && (sizeof ($ses_door) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_door);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.no_of_doors = '$ses_door[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( !empty($ses_price) && $ses_price > 1) {
         $sql .= "and ".$site."_motor.price < '$ses_price' ";
      }
      if ( !empty($ses_price1)  && $ses_price1 > 1) {
         $sql .= "and ".$site."_motor.price > '$ses_price1' ";
      }

      if ( !empty($ses_year)  && $ses_year > 1) {
         $sql .= "and ".$site."_motor.year < '$ses_year' ";
      }
      if ( !empty($ses_year1)  && $ses_year1 > 1) {
         $sql .= "and ".$site."_motor.year > '$ses_year1' ";
      }

      if ( !empty($ses_miles)  && $ses_miles > 1) {
         $sql .= "and ".$site."_motor.miles < '$ses_miles' ";
      }
      if ( !empty($ses_miles1)  && $ses_miles1 > 1) {
         $sql .= "and ".$site."_motor.miles > '$ses_miles1' ";
      }

      $sql .= " group by ".$site."_motor.id ";   
      $result = mysql_query ( $sql);
      $counter = mysql_num_rows( $result);
   

echo "<tr><td colspan='2' height='10'></td></tr>\n";      
      
echo "<tr>\n";
echo "<td valign=\"top\" class=\"bodyfont\">\n";
if ($webmaster_search != 'n') {
   if (($start+$display_count_main) > $counter) {
      $temp = $counter;
   } else {
      $temp = $start+$display_count_main;
   }
   echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];
}
echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

   if ( empty ($start)) {
      $start = 0;
   }

   $page_count=ceil ($counter/$display_count_main);
   if ( $start > 0) {
      $start1 = $start - $display_count_main;
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";
   }

   if ( $page_count > 0) {
      echo $frontend_labels["PAGE"];
      for ( $i = 0; $i < $page_count; $i++) {
            $start1 = $i * $display_count_main ;
            if ( $start != $start1) {
               echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";
            } else {
               echo "[".($i+1)."]";
            }   
      }   
   }

   $start1 = $start + $display_count_main;
   if ( ($counter) > $start1 ) {
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";
   }
   echo "</td>\n</tr>\n";

   if ( $ses_sort) {
      $sql .= " order by $ses_sort ";
   }   
   $sql .= " limit $start,$display_count_main";

   
   $result = mysql_query ( $sql);
   if(mysql_num_rowS($result)>0){
   while ( $row = mysql_fetch_row( $result)) {
      echo "<a name=\"$row[1]\"></a>";

      echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";
      echo "</td></tr>";

      echo "<tr><td colspan=\"2\">";
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";

      echo "<tr>\n<td class=\"bodyfontdkgrey\">\n";
      echo "$row[1]";
      
      if ( $row[7] == $admin_fields["SOLD"]) {
         echo " - <font color='#ff0000'>".$admin_fields["SOLD"]."</font>";
      }
      else if ( $row[7] == $admin_fields["AWAITING PREPARATION"]) {
         echo " - ".$admin_fields["AWAITING PREPARATION"]."";
      }
      
      echo "</td>\n<td class=\"bodyfont\" align=\"right\">";
      echo "$default_currency $row[2]  <a href=\"offer_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\"  class=\"links\">".$frontend_labels["OFFER"]."</a>";
      echo "</td>\n</tr>\n";

      echo "<tr>\n<td colspan=\"2\">\n";
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";

      echo "<tr>\n<td class=\"bodyfont\" align=\"center\">\n";

      if(file_exists("./admin/uploaded_photos/".$row[0]."_3")) {
         echo "<a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" >
         <img src='./admin/uploaded_photos/".$row[0]."_3'  alt=\"View $row[1]\" border='0'></a>\n";
      } else {
         echo ("<table width=\"100\" height=\"74\" bgcolor=\"#f4f4f4\"><tr><td align=\"center\" class=\"bodyfontdkgrey\" valign=\"middle\">".$frontend_labels["NO_IMAGE"]."</td></tr></table>");
      }

      echo "</td>";      
      echo "<td width=\"80%\" class=\"bodyfont\" valign=\"bottom\"><br><br>".nl2br($row[4]);

         $sql1 = "select ".$site."_pars.article_id, ".$site."_miles.name from ".$site."_pars, ".$site."_miles
             where article_id = '$row[0]' and par_id = ".$site."_miles.id order by article_id";

         $result1 = mysql_query($sql1);

      if ( mysql_num_rows( $result1) > 0) {
         echo "<br><br>";
         echo "<span class=\"bodyfontbluesm\">".$frontend_labels["FEATURES"]."</span>";
         echo "\n";
      }   
         while ( $row1 = mysql_fetch_row($result1)) {
            echo " : $row1[1]";
         }
     
      echo " <div align=\"right\"><a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" class=\"links\" title=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\" >".$frontend_labels["VIEW_DETAILS"]." <img src=\"images/viewicon.gif\" width=\"12\" height=\"12\" border=\"0\" alt=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\"></a></div></td>\n</tr>\n";
      echo "</table>\n";
      echo "</td>\n</tr>\n";
      
      echo "</table>\n";
      echo "</td></tr>";
   }

      echo "<tr><td colspan=\"2\" height=\"10\"  class=\"bodyfont\">";
      echo "</td></tr>";


      echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";
      echo "</td></tr>";

echo "<tr>\n";
echo "<td valign=\"top\" class=\"bodyfont\">\n";
if ($webmaster_search != 'n') {
   if (($start+$display_count_main) > $counter) {
      $temp = $counter;
   } else {
      $temp = $start+$display_count_main;
   }
   echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];
}
echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

   if ( empty ($start)) {
      $start = 0;
   }

   $page_count=ceil ($counter/$display_count_main);
   if ( $start > 0) {
      $start1 = $start - $display_count_main;
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";
   }

   if ( $page_count > 0) {
      echo $frontend_labels["PAGE"];
      for ( $i = 0; $i < $page_count; $i++) {
            $start1 = $i * $display_count_main ;
            if ( $start != $start1) {
               echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";
            } else {
               echo "[".($i+1)."]";
            }   
      }   
   }

   $start1 = $start + $display_count_main;
   if ( ($counter) > $start1 ) {
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";
   }
   echo "</td>\n</tr>\n";

      echo "<tr><td colspan=\"2\" height=\"10\">";
      echo "</td></tr>";
}
echo "</table>";

}else{

  echo "<p align=\"center\"><br><br>Currently we do not have any vehicles of this category for sale.<br><br>If you get in touch with us we might be able to help you further.<br><br><strong>Thanks</strong></p><br>";
  }
    include_once "./footer.php";
?>

 

 

edit: for the sake of god please use FULL PHP TAGS, yuo will run into script compatibility issues in the future, and will be a big mess for users of <?xml tags.

 

changed them for yuo

tryyyyy

 

<?php
session_start();
     include "./admin/global.php";
     include_once "header.php";
?>
<SCRIPT language=JavaScript type=text/JavaScript>
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function YY_Animateimg() { //v3.04
  //copyright (c)1999,2001 yaromat.com
  var args = YY_Animateimg.arguments;
  if (document.images){
    var yyani=eval(args[1]);
    if (args.length>5){
      eval(args[3]+"= new Array()");
      for (var i=5;i<args.length;i=i+2){
        eval(args[3]+"["+ args[3] + ".length]= new Image")
        eval(args[3]+"["+ args[3] + ".length-1].src=\'"+args+"\'")
        eval(args[3]+"["+ args[3] + ".length-1].yyto=\'"+args[i+1]+"\'")
      }
    }
    var yyImgArray = eval(args[3]);
    var yyImage = MM_findObj(args[4]);
    if(yyImgArray[yyani]){
      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);
      if(yyImage)yyImage.src = yyImgArray[yyani].src;
    }
    if(yyani>=yyImgArray.length-1){args[0]=(args[0]!="-1")?(args[0]-1):args[0]}
    var argStr= 'YY_Animateimg(\"' +args[0]+ '\",\"' +((yyani>=yyImgArray.length-1 && args[0]!=0)?'0':(yyani+1));
    for (var i=2;i<5;i++){argStr+='\",\"'+args}
    argStr+='\")';
    if ((yyani<yyImgArray.length-1) || args[0]!=0&&yyImgArray[yyani]){
      if(yyImgArray[yyani].yyTimeout) clearTimeout(yyImgArray[yyani].yyTimeout);
      yyImgArray[yyani].yyTimeout = setTimeout(argStr,yyImgArray[yyani].yyto);
    }else{if(args[2]!='#')setTimeout(args[2],10)}
  }
}
</SCRIPT>
                  <SCRIPT language=javascript
                  src="Common.js">
</SCRIPT>
<?php
echo "<table border=\"0\" width=\"99%\" cellspacing=\"0\" cellpadding=\"0\">\n";

   function get_array ($test) {
      unset($test1);
      $j = 0;
      $i = 0;
      while ( $j < sizeof ($test)) {
         if ( !empty ($test[$i])) {
            $test1[$j] = $test[$i];
            $j++;
         }
         $i++;
      }
      return ($test1);   
   }

if ( $submit) {
      session_register ("ses_title");   
      session_register ("ses_make");   
      session_register ("ses_fuel");   
      session_register ("ses_cat");   
      session_register ("ses_price");   
      session_register ("ses_price1");   
      session_register ("ses_year");   
      session_register ("ses_year1");   
      session_register ("ses_miles");   
      session_register ("ses_miles1");   
      session_register ("ses_door");   
      session_register ("ses_extra");   
      session_register ("ses_sort");   
}

   if ( $submit == $frontend_labels["SEARCH"] ) {
      session_register ("ses_title");   
      session_register ("ses_make");   
      session_register ("ses_fuel");   
      session_register ("ses_cat");   
      session_register ("ses_price");   
      session_register ("ses_price1");   
      session_register ("ses_year");   
      session_register ("ses_year1");   
      session_register ("ses_miles");   
      session_register ("ses_miles1");   
      session_register ("ses_door");   
      session_register ("ses_extra");   
      session_register ("ses_sort");   

      $_SESSION["ses_title"] = $ses_title = $title;
      $_SESSION["ses_make"][0] = $ses_make[0] = $make[0];
      $_SESSION["ses_fuel"] = $ses_fuel = get_array( $fuel);
      $_SESSION["ses_cat"][0] = $ses_cat[0] = $cat[0];
      $_SESSION["ses_price"] = $ses_price = $price + 1;
      $_SESSION["ses_price1"] = $ses_price1 = $price1 - 1;
      $_SESSION["ses_year"] = $ses_year = $year + 1;
      $_SESSION["ses_year1"] = $ses_year1 = $year1 - 1;
      $_SESSION["ses_miles"] = $ses_miles = $miles + 1;
      $_SESSION["ses_miles1"] = $ses_miles1 = $miles1 - 1;
      $_SESSION["ses_door"][0] = $ses_door[0] = $door[0];
      $_SESSION["ses_extra"] = $ses_extra = get_array( $extra);
   }

   if ( !empty ($sort) ) {
      $ses_sort = $sort;
   }   
   
   if ( empty($sort) && empty($ses_sort)) {
      $ses_sort = $site."_motor.title";
   }   

   {

   $sql = "select distinct ".$site."_motor.id,".$site."_motor.title,".$site."_motor.price,
         ".$site."_category.name,".$site."_motor.des, 
         ".$site."_motor.model, ".$site."_make.name, ".$site."_motor.status
         from ".$site."_motor,".$site."_category, ".$site."_make  ";
   
   if ( !empty($ses_extra) && (sizeof ($ses_extra) > 0)) {
      $sql .= ",".$site."_pars where ".$site."_pars.article_id = ".$site."_motor.id ";
         $sql .= " and ".$site."_pars.par_id = ( ";
         for ( $i = 0; $i < sizeof ($ses_extra);$i++) {
            if ( $i > 0) {
               $sql .= " and ";
            }
            $sql .= "  '$ses_extra[$i]'";
         }
         $sql .= " ) and ";   
   } else
   
   {
      $sql .= " where ";
   }
   $sql .= " ".$site."_make.id = ".$site."_motor.make and ".$site."_motor.price > 0 and  ".$site."_category.id = ".$site."_motor.cat and ".$site."_motor.id != '0' and active = 'y' ";


      if ( !empty($ses_title)) {
         $sql .= "and (".$site."_motor.title like '%$ses_title%' or ".$site."_motor.des like '%$ses_title%') ";
      }

      if ( $ses_make[0] != '' && (sizeof ($ses_make) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_make);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.make = '$ses_make[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( !empty($ses_fuel) && (sizeof ($ses_fuel) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_fuel);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.fuel = '$ses_fuel[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( $ses_cat[0] != '' && (sizeof ($ses_cat) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_cat);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.cat = '$ses_cat[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( $ses_door[0] != '' && (sizeof ($ses_door) > 0)) {
         $sql .= " and ( ";
         for ( $i = 0; $i < sizeof ($ses_door);$i++) {
            if ( $i > 0) {
               $sql .= " or ";
            }
            $sql .= "".$site."_motor.no_of_doors = '$ses_door[$i]'";
         }
         $sql .= " ) ";   
      }

      if ( !empty($ses_price) && $ses_price > 1) {
         $sql .= "and ".$site."_motor.price < '$ses_price' ";
      }
      if ( !empty($ses_price1)  && $ses_price1 > 1) {
         $sql .= "and ".$site."_motor.price > '$ses_price1' ";
      }

      if ( !empty($ses_year)  && $ses_year > 1) {
         $sql .= "and ".$site."_motor.year < '$ses_year' ";
      }
      if ( !empty($ses_year1)  && $ses_year1 > 1) {
         $sql .= "and ".$site."_motor.year > '$ses_year1' ";
      }

      if ( !empty($ses_miles)  && $ses_miles > 1) {
         $sql .= "and ".$site."_motor.miles < '$ses_miles' ";
      }
      if ( !empty($ses_miles1)  && $ses_miles1 > 1) {
         $sql .= "and ".$site."_motor.miles > '$ses_miles1' ";
      }

      $sql .= " group by ".$site."_motor.id ";   
      $result = mysql_query ( $sql);
      $counter = mysql_num_rows( $result);
   

echo "<tr><td colspan='2' height='10'></td></tr>\n";      
      
echo "<tr>\n";
echo "<td valign=\"top\" class=\"bodyfont\">\n";
if ($webmaster_search != 'n') {
   if (($start+$display_count_main) > $counter) {
      $temp = $counter;
   } else {
      $temp = $start+$display_count_main;
   }
   echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];
}
echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

   if ( empty ($start)) {
      $start = 0;
   }

   $page_count=ceil ($counter/$display_count_main);
   if ( $start > 0) {
      $start1 = $start - $display_count_main;
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";
   }

   if ( $page_count > 0) {
      echo $frontend_labels["PAGE"];
      for ( $i = 0; $i < $page_count; $i++) {
            $start1 = $i * $display_count_main ;
            if ( $start != $start1) {
               echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";
            } else {
               echo "[".($i+1)."]";
            }   
      }   
   }

   $start1 = $start + $display_count_main;
   if ( ($counter) > $start1 ) {
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";
   }
   echo "</td>\n</tr>\n";

   if ( $ses_sort) {
      $sql .= " order by $ses_sort ";
   }   
   $sql .= " limit $start,$display_count_main";

   
   $result = mysql_query ( $sql);
   if(mysql_num_rows($result)>0){
   while ( $row = mysql_fetch_row( $result)) {
      echo "<a name=\"$row[1]\"></a>";

      echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";
      echo "</td></tr>";

      echo "<tr><td colspan=\"2\">";
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";

      echo "<tr>\n<td class=\"bodyfontdkgrey\">\n";
      echo "$row[1]";
      
      if ( $row[7] == $admin_fields["SOLD"]) {
         echo " - <font color='#ff0000'>".$admin_fields["SOLD"]."</font>";
      }
      else if ( $row[7] == $admin_fields["AWAITING PREPARATION"]) {
         echo " - ".$admin_fields["AWAITING PREPARATION"]."";
      }
      
      echo "</td>\n<td class=\"bodyfont\" align=\"right\">";
      echo "$default_currency $row[2]  <a href=\"offer_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\"  class=\"links\">".$frontend_labels["OFFER"]."</a>";
      echo "</td>\n</tr>\n";

      echo "<tr>\n<td colspan=\"2\">\n";
      echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";

      echo "<tr>\n<td class=\"bodyfont\" align=\"center\">\n";

      if(file_exists("./admin/uploaded_photos/".$row[0]."_3")) {
         echo "<a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" >
         <img src='./admin/uploaded_photos/".$row[0]."_3'  alt=\"View $row[1]\" border='0'></a>\n";
      } else {
         echo ("<table width=\"100\" height=\"74\" bgcolor=\"#f4f4f4\"><tr><td align=\"center\" class=\"bodyfontdkgrey\" valign=\"middle\">".$frontend_labels["NO_IMAGE"]."</td></tr></table>");
      }

      echo "</td>";      
      echo "<td width=\"80%\" class=\"bodyfont\" valign=\"bottom\"><br><br>".nl2br($row[4]);

         $sql1 = "select ".$site."_pars.article_id, ".$site."_miles.name from ".$site."_pars, ".$site."_miles
             where article_id = '$row[0]' and par_id = ".$site."_miles.id order by article_id";

         $result1 = mysql_query($sql1);

      if ( mysql_num_rows( $result1) > 0) {
         echo "<br><br>";
         echo "<span class=\"bodyfontbluesm\">".$frontend_labels["FEATURES"]."</span>";
         echo "\n";
      }   
         while ( $row1 = mysql_fetch_row($result1)) {
            echo " : $row1[1]";
         }
     
      echo " <div align=\"right\"><a href=\"car_". str_replace (" ", "-", $row[5])."-".str_replace (" ", "-", $row[6]) ."_".$row[0]."_".$start."_index.php\" class=\"links\" title=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\" >".$frontend_labels["VIEW_DETAILS"]." <img src=\"images/viewicon.gif\" width=\"12\" height=\"12\" border=\"0\" alt=\"".$frontend_labels["VIEW_DETAILS"]." of $row[1]\"></a></div></td>\n</tr>\n";
      echo "</table>\n";
      echo "</td>\n</tr>\n";
      
      echo "</table>\n";
      echo "</td></tr>";
   }

      echo "<tr><td colspan=\"2\" height=\"10\"  class=\"bodyfont\">";
      echo "</td></tr>";


      echo "<tr><td colspan=\"2\" height=\"10\"><hr size=\"1\" color=\"#cccccc\">";
      echo "</td></tr>";

echo "<tr>\n";
echo "<td valign=\"top\" class=\"bodyfont\">\n";
if ($webmaster_search != 'n') {
   if (($start+$display_count_main) > $counter) {
      $temp = $counter;
   } else {
      $temp = $start+$display_count_main;
   }
   echo $frontend_labels["DISPLAYING"]." ".($start+1)." - $temp ".$frontend_labels["OF"]." $counter ".$frontend_labels["CARS"];
}
echo "</td><td valign=\"top\" align=\"right\" class=\"bodyfont\">";

   if ( empty ($start)) {
      $start = 0;
   }

   $page_count=ceil ($counter/$display_count_main);
   if ( $start > 0) {
      $start1 = $start - $display_count_main;
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["PREV"]." </a>";
   }

   if ( $page_count > 0) {
      echo $frontend_labels["PAGE"];
      for ( $i = 0; $i < $page_count; $i++) {
            $start1 = $i * $display_count_main ;
            if ( $start != $start1) {
               echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".($i+1)." </a>";
            } else {
               echo "[".($i+1)."]";
            }   
      }   
   }

   $start1 = $start + $display_count_main;
   if ( ($counter) > $start1 ) {
      echo "<a href=\"$PHP_SELF?start=$start1&submit=1\" class=\"links\"> ".$frontend_labels["NEXT"]." </a>";
   }
   echo "</td>\n</tr>\n";

      echo "<tr><td colspan=\"2\" height=\"10\">";
      echo "</td></tr>";
}
echo "</table>";

}else{

  echo "<p align=\"center\"><br><br>Currently we do not have any vehicles of this category for sale.<br><br>If you get in touch with us we might be able to help you further.<br><br><strong>Thanks</strong></p><br>";
  }
    include_once "./footer.php";
?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.