PHP链接只传递部分mysql结果

Question

OK i have a php link which is made up of several variables

<a href=\year.php? manufacturer='.$manufacturer.'&fuel_type='.$fuel_type.'&model_type='.$model_type.'>'.$model_type.'</a>

The whole code is really long as it has a lot of pagination, so i will just include the basic query and the loop part.

$query1 = "SELECT Distinct model_type from $tableName where manufacturer='$manufacturer' AND fuel='$fuel_type' LIMIT $start, $limit";
$result = mysql_query($query1);

And then the bottom part where i get and show the results.

 $count = 0;
 $max = 2;
 while($row = mysql_fetch_array($result))
    {
$model_type = $row['model_type'];               
$count++;
echo '<td class="manu"><div align="center">'.'<a href=\year.php?    manufacturer='.$manufacturer.'&fuel_type='.$fuel_type.'&model_type='.$model_type.'>'.$model_type.'</a>'.'</div></td>';

 if($count >= $max){
  //reset counter
   $count = 0;
  //end and restart
  echo '</tr><tr>';
  }

  }

now this works fine except when i take the mode type variable from the database it shows as 1 series, however when it is passed in this link it only gets the 1 and doesn't pick up the series.

Thanks

Answer 1

I am not shure but you probably have a missing encoding Problem.

try this:

<a href="\year.php? manufacturer='.urlencode($manufacturer).'&fuel_type='.urlencode($fuel_type).'&model_type='.urlencode($model_type).'">'.$model_type.'</a>

Its url_encoding the values so your url doesnt get broken by ',",spaces and so on.

additional Hint: Enclose your URL with " or ' so you do not get problems at the end.