PHP - Input _get Into A Query.

function showCart() {
   global $db;
   
   $cart = $_SESSION['cart'];
   $output[] = '<div align="center"><table cellpadding="1" cellspacing="1" bgcolor="#666666" width="400">';
         $output[] = '<tr bgcolor="#FFFFFF" valign="middle">';
         $output[] = '<td width="70" align="center">Titlu</td>';
         $output[] = '<td width="90" align="center">Imagine </td>';
         $output[] = '<td width="60" align="center">Pret</td>';
         $output[] = '<td align="center">Sterge Produs</td>';
         
         $total += $price * $qty;
         $output[] = '</tr>';
         $output[] = '</table>';
   if ($cart) {
      $items = explode(',',$cart);
      $contents = array();
      foreach ($items as $item) {
         $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
      }
         $output[] = '<form  action="http://www.sprayart.info/new/sprayart.php"><div align="center" name="trimite" id="trimite"><table width="400">';
      foreach ($contents as $id=>$qty) {
                  

         $sql = 'SELECT * FROM com_images WHERE id = '.$id;
         $result = $db->query($sql);
         $row = $result->fetch();
         extract($row);
         
         $output[] = '<tr bgcolor="#FFFFFF">';
         $output[] = '<td width="70">
         <input type="hidden" name="title[ ]"         
          value="'.$title.'" size="5" maxlength="5" />
         <input type="text"  value="'.$title.'" size="5" maxlength="5" disabled="disabled" /></td>';
         $output[] = '<td width="90" align="center" valign="middle"><img src=../../'.$thumbnail.'> </td>';
         $output[] = '<td width="60" align="center">'.$price.'</td>';
         $output[] = '<td ></td>';
         $total += $price * $qty;
         $output[] = '<td width="50"><a href="cart.php?action=delete&id='.$id.'" class="r"><img src="../../media/sterge.jpg"></a></td>';
         $output[] = '</tr>';   
      }
   
      $output[] = '</table>';
      $output[] = '<hr>';
      $output[] = '<p align="right">Total De plata: <strong>'.$total.' RON</strong></p></div>';
      
      $output[] = '<table border="0" width="444" id="table29" cellspacing="0" cellpadding="0" background="#BASE_URL#media/comand_form.gif" height="322">
  <form action="#BASE_URL#sprayart.php" method="post" name="trimite" id="trimite">
    <tr>
      <td width="25"></td>
      <td width="71" class="text_negru_left_25"><span class="style4">*</span> Nume:</td>
      <td width="146"><input name="nume" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td  class="text_negru_left_25"><span class="style4">*</span> Adresa:</td>
      <td ><input name="adresa" type="text" class="text_negru_fild_19"></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td  class="text_negru_left_25"><span class="style4">*</span> E-mail:</td>
      <td ><input name="email" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25"></td>
      <td class="text_negru_left_25"><span class="style4">*</span> Telefon:</td>
      <td ><input name="telefon" type="text" class="text_negru_fild_19" /></td>
      <td width="170"></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25" height="139"></td>
      <td colspan="3" class="text_negru_left_25"><span class="style4">*</span>        <textarea name="mesaj" cols="44" rows="7" ></textarea></td>
      <td width="32"></td>
    </tr>
    <tr>
      <td width="25" height="39"></td>
      <td colspan="2" valign="top" class="text_negru_left_25"></td>
      <td valign="top" class="text_negru_left_25"><input style="BORDER-RIGHT: #3a3a3a 1px solid; BORDER-TOP: #3a3a3a 1px solid; FONT-SIZE: 8pt; FLOAT: right; BORDER-LEFT: #3a3a3a 1px solid; COLOR: #b1b1a7; BORDER-BOTTOM: #3a3a3a 1px solid; FONT-FAMILY: Verdana; BACKGROUND-COLOR: #3a3a3a" type="submit" class="buton" name="trimite" value="Trimite" /></td>
      <td width="32"></td>
    </tr></table></form>';


  how can i get the "title" for all products ! if i buy one its ok it will send me in email, but if is more products i get only the last added product!!

 Please help thank you !

i have the following code:
            <li>Have you read the <?php echo link_to('FAQ','util/faq') ?> ?
                 <select id="yesnolist" onChange="getChoice(this.value)">
                    <option value="yes" selected="selected">Yes</option>
                    <option value="no">No</option>
                 </select>
            </li>   
             <input type="hidden" name="text" size=30 id="yesandno">
             <?php
                if ($_GET['yesandno'] == "no")
                {
                   echo "anything!!!!!!!!!!!!!!!!!!!";
                }
            ?>

then my java script for getCoice():
function getChoice(val)
  {
      yesNo = new Array("Yes", "No");
      var getsel = document.contactus.yesnolist.value;
      var e = document.getElementById("yesnolist");
      var strUser = e.options[e.selectedIndex].value;
     
      document.contactus.yesandno.value = strUser;
      alert(document.contactus.yesandno.value);
      return strUser;
  }

my alert will gove yes or no depending on what i chose in the dropdown
but HOWCOME it does not go into the if  ($_GET['yesandno'] == "no") ????

please help???

Hey guys having a bit of bother here, I don't understand why my PHP script isn't working.   So I will first show the code and then go over the issue I am having:  

include('select-stock.php');
include('db-affinity/header-main.php'); ?>
<?php $carId = $_GET['id']; ?>
<?php 
try {
$carview = $db->prepare("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive, FullRegistration FROM import WHERE FullRegistration = $carId");
} catch (Exception $e) {
  echo "Error.";
  exit;
}
  $cardata = $carview->fetch(PDO::FETCH_ASSOC)
?>
<div class="container">
  <div class="row">
    <div class="col-md-12 col-sm-12">
    <?php echo "$carId"; ?>
    <?php echo mysql_errno($carview) ?>
    <?php echo '<ul class="overwrite-btstrp-ul other-specs-ul h4-style">
   <li>Mileage: '.number_format($cardata["Mileage"]).'</li>
   <li>Engine size: '.$cardata["EngineSize"].'cc</li>
 </ul>'
 ?>
    </div>
  </div>
</div>
<?php include('db-affinity/footer.php') ?>

So basically what I am trying to achieve from this code is giving my page dynamic content based on if the the ?id= of a URL matches a row of my 'FullRegistration' column.   So for example if I have a URL like this "www.cars.com/carview.php?id=NG61CWJ" I then want my script check if there is a row that has that value in the 'FullRegistration' column of my table and then echo out the results of certain columns of that row like this example currently in my code:

<?php echo '<ul class="overwrite-btstrp-ul other-specs-ul h4-style">
   <li>Mileage: '.number_format($cardata["Mileage"]).'</li>
   <li>Engine size: '.$cardata["EngineSize"].'cc</li>
 </ul>'
 ?>

In theory 

FROM import WHERE FullRegistration = $carId

should make this happen however for some reason on my server when I use the script above I get nil results returned instead of the results of the row that matches the GET id I get:   Mileage: 0 Engine size: cc I am aware my code is insecure at the moment however it isn't an issue at this moment in time.   Any ideas why I might be getting nil results returned, my other queries to this table have worked flawlessly however I am having bother with this one, can you see anything in this code that might cause this issue?   Here is the database connection file that is included at the top of the code block just in case this could be a bit of a problem:  

<?php
include('database.php');
try {
  $results = $db->query("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive, FullRegistration FROM import ORDER BY Make ASC");
} catch (Exception $e) {
  echo "Error.";
  exit;
}
///carousel-vehicle results
try {
  $fourresults = $db->query("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive FROM import ORDER BY Make LIMIT 0, 4");
} catch (Exception $e) {
  echo "Error.";
  exit;
}


try {
  $fourresultsone = $db->query("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive FROM import ORDER BY Make LIMIT 4, 4");
} catch (Exception $e) {
  echo "Error.";
  exit;
}


try {
  $fourresultstwo = $db->query("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive FROM import ORDER BY Make LIMIT 8, 4");
} catch (Exception $e) {
  echo "Error.";
  exit;
}


try {
  $makeFilter = $db->query("SELECT DISTINCT Make FROM import ORDER BY Make ASC");
} catch (Exception $e) {
  echo "Error.";
  exit;
}


try {
  $modelFilter = $db->query("SELECT DISTINCT Model FROM import ORDER BY Make ASC");
} catch (Exception $e) {
  echo "Error.";
  exit;
}
?>

All of these queries are working flawlessly on the live site so the db connection is obviously working.

Hey guys I am a little confused, I have a listing page that displays all of my rows in my SQL table. An example of what I am developing can be seen he  http://www.drivencar...k/used-cars.php So as you can see I have developed a listing page that fetches all of the table rows, each row is equivalent to one vehicle. I now want to let users filter the results using the form to the left, I was going to use AJAX originally however I feel as if it would take way to long to learn how to develop it that way. Here is the code setup I am using to achieve the example I have shown:

<?php
include('database.php');
try {
$results = $db->query("SELECT Make, Model, Colour, FuelType, Year, Mileage, Bodytype, Doors, Variant, EngineSize, Price, Transmission, PictureRefs, ServiceHistory, PreviousOwners, Options, FourWheelDrive FROM import ORDER BY Make ASC");
} catch (Exception $e) {
echo "Error.";
exit;
}

try {
$filterres = $db->query("SELECT DISTINCT Make FROM import ORDER BY Make ASC");
} catch (Exception $e) {
echo "Error.";
exit;
}
?>

As you can see the first block of code has two SQL selectors, the $results is used to fetch the whole table and list all vehicles. The second block is used to display the 'Make' column for the form. This block of code is the actual form:

<form>
<select class="form-control select-box" name="">
<option value="make-any">Make (Any)</option>
<?php while($make = $filterres->fetch(PDO::FETCH_ASSOC))
{
echo '
<option value="">'.$make["Make"].'</option>
';
} ?>
</select>
<button href="#" class="btn btn-block car-search-button btn-lg btn-success"><span class="glyphicon car-search-g glyphicon-search"></span> Search cars 
</button>
</form>

As you can see this block is using a while loop to display all of the 'Make's' in the 'Make' column and uses a DISTINCT clause so that it doesn't show identical options. Here is the block that lists the results to the page:

<?php while($row = $results->fetch(PDO::FETCH_ASSOC))
{
echo '
<div class="listing-container">
<a href="carpage.php"><h3 class="model-listing-title clearfix">'.$row["Make"].' '.$row["Model"].' '.$row["Variant"].'</h3></a>
<h3 class="price-listing">£'.number_format($row['Price']).'</h3>
</div>
<div class="listing-container-spec">
<img src="'.(explode(',', $row["PictureRefs"])[0]).'" class="stock-img-finder"/>
<div class="ul-listing-container">
<ul class="overwrite-btstrp-ul">
<li class="diesel-svg list-svg">'.$row["FuelType"].'</li>
<li class="saloon-svg list-svg">'.$row["Bodytype"].'</li>
<li class="gear-svg list-svg">'.$row["Transmission"].'</li>
<li class="color-svg list-svg">'.$row["Colour"].'</li>
</ul>
</div>
<ul class="overwrite-btstrp-ul other-specs-ul h4-style">
<li>Mileage: '.number_format($row["Mileage"]).'</li>
<li>Engine size: '.$row["EngineSize"].'cc</li>
</ul>
<button href="#" class="btn h4-style checked-btn hover-listing-btn"><span class="glyphicon glyphicon-ok"></span> History checked
</button>
<button href="#" class="btn h4-style more-details-btn hover-listing-btn tst-mre-btn"><span class="glyphicon glyphicon-list"></span> More details
</button>
<button href="#" class="btn h4-style test-drive-btn hover-listing-btn tst-mre-btn"><span class="test-drive-glyph"></span> Test drive
</button>
<h4 class="h4-style listing-photos-count"><span class="glyphicon glyphicon-camera"></span> 5 More photos</h4>
</div>
';
} ?>

So down to my question... How can I filter these results displayed in the listing block using the select element, when a user selects a 'Make' from the select element I want them to be able to submit the form and return all rows in the SQL table containing the same 'Make' string and hide other rows that are false. Any ideas how I can achieve this or any easier ways? Thanks

A few months ago, and a good amount of time before that, I had people telling me to use isset() instead of performing to see if the variable is empty, such as: !$_GET['']

I know the differences in the function and what they do, but when could isset() be used in a situation where it's better/more efficient then: !$_GET['']

I do use isset(), though.