Ciao a tutti,
ho cercato nel forum ma non sono riuscito a cavarci niente... 
Ho uno script di ricerca diviso in due pagine, una browse.php (che funziona correttamente mandando i valori) e una view.php che però pur ricevendo i valori non mi smista la ricerca... vi posto il codice, magari qualcuno mi sa dare una mano.. 
Grazie in anticipo!!
Codice PHP:
<?php
include("./common.php");
$link = mysql_connect ($server, $user, $password);
if (! $link)
{
die ("Couldn't connect to mySQL server");
}
if (!mysql_select_db ($db, $link) )
{
die ("Coldn't open $db: ".mysql_error() );
}
$view = $_REQUEST["view"];
$cur_page = $_REQUEST["cur_page"];
$guidestring = $_REQUEST["guidestring"];
$sort = $_REQUEST["sort"];
$Id = $_REQUEST["Id"];
function makelisting($querystring, $link, $guidestring, $cur_page, $listings_per_page, $sort)
{
global $use_city_state;
global $bcolor1;
global $bcolor2;
if ($sort == "") {$sort = "price DESC";}
$querystring = $querystring." ORDER BY $sort";
$result = mysql_query("$querystring;",$link);
$num_rows = mysql_num_rows($result);
$limit_str = "LIMIT ". $cur_page * $listings_per_page .",$listings_per_page";
$query = "$querystring $limit_str";
$result = mysql_query("$query;",$link);
print "<table width=\"98%\" border=0 cellspacing=0 cellpadding=0>";
print "<TR bgcolor=$bcolor1>";
if ($use_city_state == "Y")
{
print "<td width=\"20%\" align=center>Moto</td>";
print "<td width=\"15%\" align=center>Categoria</td>";
print "<td width=\"40%\" align=center>Descrizione</td>";
print "<td width=\"10%\" align=center>Rivenditore</td>";
print "<td width=\"5%\" align=center>Anno</td>";
print "<td width=\"10%\" align=center>Prezzo</td>";
}
else
{
print "<td width=\"20%\" align=center>Moto</td>";
print "<td width=\"20%\" align=center>Marca</td>";
print "<td width=\"45%\" align=center>Titolo</td>";
print "<td width=\"5%\" align=center>Anno</td>";
print "<td width=\"10%\" align=center>Prezzo</td>";
}
print "</tr>";
print "<TR bgcolor=black height=3>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
print "<TR height=5>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
print "";
while ($a_row =mysql_fetch_array ($result) )
{
$a_row[$title] = stripslashes($a_row[$title]);
$a_row[$address] = stripslashes($a_row[$address]);
$a_row[city] = stripslashes($a_row[city]);
$a_row[state] = stripslashes($a_row[state]);
$a_row[previewdesc] = stripslashes($a_row[previewdesc]);
$a_row[fulldesc] = stripslashes($a_row[fulldesc]);
$a_row[type] = stripslashes($a_row[type]);
$a_row[transmission] = stripslashes($a_row[transmission]);
$a_row[color] = stripslashes($a_row[color]);
$a_row[doors] = stripslashes($a_row[doors]);
$a_row[stereo] = stripslashes($a_row[stereo]);
$a_row[notes] = stripslashes($a_row[notes]);
$a_row[price] = number_format ($a_row[price]);
if ($nowcolor == $bcolor2)
{
$nowcolor = $bcolor1;
}
else
{
$nowcolor = $bcolor2;
}
print "<TR bgcolor = $nowcolor>";
$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id] LIMIT 1";
$output = mysql_query("$query",$link);
$count = 0;
while ($image_row =mysql_fetch_array ($output) )
{
print "<td valign=top align=center width=115><a href=\"./carview.php?view=$a_row[id]\">[img]image.php?Id=$image_row[id_files][/img]</a>
</td>";
$count++;
}
if ($count == 0)
{
print "<td valign=top align=center width=115><a href=\"./carview.php?view=$a_row[id]\"><img src=\"./images/nophoto.gif\" border=1 width=100 alt=\"View Listing\"></a>
</td>";
}
print "</td>";
print "<td align=center>$a_row[make]</td>";
print "<td align=center>$a_row[title]</td>";
print "<td align=center>$a_row[year]</td>";
print "<td align=center>$a_row[price]</td>";
print "</tr>";
print "<TR bgcolor=$nowcolor>";
print "<td align=center>Listing: $a_row[id]</td>";
print "<td align=center><a href=\"./carview.php?view=$a_row[id]\"><font color=\"blue\">Clicca per vedere la moto</font></a></td>";
print "<td colspan=4>";
print "</tr>";
print "<TR height=2>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
print "<TR bgcolor=black height=1>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
print "<TR height=3>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
}
print "</table>";
print "\r\n";
include("./templates/user_top.html");
print "\r\n\r\n\r\n";
if ($cur_page == "") {$cur_page = 0;}
if ($view != "")
{
$query = "SELECT * FROM vehicles WHERE id='$view'";
$result = mysql_query($query);
if (!$result) error_message (sql_error());
$a_row = mysql_fetch_array($result);
$a_row[$title] = stripslashes($a_row[$title]);
$a_row[$address] = stripslashes($a_row[$address]);
$a_row[city] = stripslashes($a_row[city]);
$a_row[previewdesc] = stripslashes($a_row[previewdesc]);
$a_row[fulldesc] = stripslashes($a_row[fulldesc]);
$a_row[type] = stripslashes($a_row[type]);
$a_row[transmission] = stripslashes($a_row[transmission]);
$a_row[color] = stripslashes($a_row[color]);
$a_row[doors] = stripslashes($a_row[doors]);
$a_row[stereo] = stripslashes($a_row[stereo]);
$a_row[notes] = stripslashes($a_row[notes]);
$a_row[price] = number_format ($a_row[price]);
$a_row[miles] = number_format ($a_row[miles]);
Print "<table border=0 cellspacing=0 cellpadding=0 width=\"90%\">";
Print "<tr><td><font face=\"arial,ms sans serif\" size=3>[b]Moto : $a_row[title] [/b]</font></td></tr>";
Print "</table>
";
Print "<table border=0 cellspacing=0 cellpadding=2 width=\"550\"><tr><td rowspan=20 valign=top align=center width=165><font size=2 face=\"Arial,Helvetica,Geneva,Swiss,SunSans-Regular\">";
$count = 0;
$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id]";
$result = mysql_query("$query",$link);
while ($image_row =mysql_fetch_array ($result) )
{
echo "[B]";
echo stripslashes($image_row[description]) . "
\n";
echo "[/b]<table border=1 cellspacing=0 cellpadding=0 width=100><tr><td align=center><a href=\"./image.php?Id=$image_row[id_files]\" target=\"_new\">[img]image.php?Id=$image_row[id_files][/img]</a></td></tr></table>";
echo "
\n";
$count++;
}
print "</font>";
else
{
if ($minprice == "")
{
$minprice = 0;
}
if ($maxprice == "")
{
$maxprice = 1000000000000000;
}
$minprice = ereg_replace("%24","",$minprice);
$maxprice = ereg_replace("%24","",$maxprice);
$minprice = ereg_replace("%2C","",$minprice);
$maxprice = ereg_replace("%2C","",$maxprice);
$minprice = ereg_replace("[^[:alnum:]]","",$minprice);
$maxprice = ereg_replace("[^[:alnum:]]","",$maxprice);
$querystring = "SELECT * FROM vehicles WHERE ";
$querystring = $querystring."(price >= '$minprice' AND price <= '$maxprice')";
$guidestring = "minprice=$minprice&maxprice=$maxprice";
foreach ($HTTP_GET_VARS as $key=>$value)
{
if ($key == "citystate")
{
if ($use_city_state == "Y")
{
$count = 0;
$extra = "";
$querystring = $querystring." AND (";
foreach ($value as $two_dim_value)
{
$guidestring = $guidestring."&citystate%5B%5D=$two_dim_value";
if ($count > 0) {$extra = " OR ";}
$querystring = $querystring."$extra(state='$two_dim_value')";
$count++;
}
$querystring = $querystring.")";
}
}
elseif ($key == "makemodelchoice")
{
$count = 0;
$extra = "";
$querystring = $querystring." AND (";
foreach ($value as $two_dim_value)
{
$guidestring = $guidestring."&makemodelchoice%5B%5D=$two_dim_value";
$buffer = explode("___" , $two_dim_value);
$make = $buffer[0];
$model = $buffer[1];
if ($count > 0) {$extra = " OR ";}
$querystring = $querystring."$extra(make='$make' and model='$model')";
$count++;
}
$querystring = $querystring.")";
}
elseif ($key == "minprice")
{
}
elseif ($key == "maxprice")
{
}
elseif ($key == "typechoice")
{
$count = 0;
$extra = "";
$querystring = $querystring." AND (";
foreach ($value as $two_dim_value)
{
$guidestring = $guidestring."&typechoice%5B%5D=$two_dim_value";
if ($count > 0) {$extra = " OR ";}
$querystring = $querystring."$extra(type='$two_dim_value')";
$count++;
}
$querystring = $querystring.")";
}
elseif ($key == "makechoice")
{
$count = 0;
$extra = "";
$querystring = $querystring." AND (";
foreach ($value as $two_dim_value)
{
$guidestring = $guidestring."&makechoice%5B%5D=$two_dim_value";
if ($count > 0) {$extra = " OR ";}
$querystring = $querystring."$extra(make='$two_dim_value')";
$count++;
}
$querystring = $querystring.")";
}
elseif ($key == "transmissionchoice")
{
$count = 0;
$extra = "";
$querystring = $querystring." AND (";
foreach ($value as $two_dim_value)
{
$guidestring = $guidestring."&transmissionchoice%5B%5D=$two_dim_value";
if ($count > 0) {$extra = " OR ";}
$querystring = $querystring."$extra(transmission='$two_dim_value')";
$count++;
}
$querystring = $querystring.")";
}
elseif ($key == "cur_page")
{
}
elseif ($key == "sort")
{
}
else
{
$guidestring = $guidestring."&$key=$value";
$querystring = $querystring." AND $key = '$value'";
}
}
makelisting($querystring, $link, $guidestring, $cur_page, $listings_per_page, $sort);
}
print"\r\n\r\n";
include("./templates/user_bottom.html");
mysql_close($link);
?>
Rispondi quotando