Jack8900 Posted August 2, 2009 Share Posted August 2, 2009 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 More sharing options...
timmah1 Posted August 2, 2009 Share Posted August 2, 2009 You should really start using the code tags instead of quote. Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889174 Share on other sites More sharing options...
Jack8900 Posted August 3, 2009 Author Share Posted August 3, 2009 Sorry about that Tim, I didn't see the code tags. Jack Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889372 Share on other sites More sharing options...
phpSensei Posted August 3, 2009 Share Posted August 3, 2009 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 Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889387 Share on other sites More sharing options...
Jack8900 Posted August 3, 2009 Author Share Posted August 3, 2009 Thanks for your suggestion. I tried that and the following error appeared: Parse error: syntax error, unexpected T_ELSE in /home/gridwebd/public_html/results.php on line 379 Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889431 Share on other sites More sharing options...
phpSensei Posted August 3, 2009 Share Posted August 3, 2009 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"; ?> Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889437 Share on other sites More sharing options...
Jack8900 Posted August 3, 2009 Author Share Posted August 3, 2009 Same error still occurs: Parse error: syntax error, unexpected T_ELSE in /home/gridwebd/public_html/results.php on line 379 Thanks in advance, Jack Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-889677 Share on other sites More sharing options...
phpSensei Posted August 3, 2009 Share Posted August 3, 2009 Alright I am just wondering what part of the script you dont want to show when there are no search results. this is a quite large script and I had to break it down, its hard to find whats what.... Link to comment https://forums.phpfreaks.com/topic/168555-solved-search-results-query/#findComment-890163 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.