Code: Select all
//Update cart_contents view
if(isset($_GET['update_cart'])):
$user_ip = $_SERVER['SERVER_ADDR'];
$sql = mysql_query("SELECT * FROM cart_contents WHERE user_ip = '$user_ip' ");
while($row = mysql_fetch_assoc($sql)):
extract($row);
//
$sql2 = mysql_query("SELECT CategoryID FROM ItemCategories WHERE ItemID = '$ItemID' ");
$row2 = mysql_fetch_assoc($sql2);
$CategoryID = $row2['CategoryID'];
//
$sql3 = mysql_query("SELECT ThumbNailImage, Name FROM Categories WHERE CategoryID = '$CategoryID' ");
$row3 = mysql_fetch_assoc($sql3);
//
$sql4 = mysql_query("SELECT * FROM application_mappings WHERE item_id = '$ItemID' ");
$row4 = mysql_fetch_assoc($sql4);
$jetting_id = $row4['jetting_id'];
//
$sql5 = mysql_query("SELECT MAKE, MODEL FROM Jetting WHERE ID = '$jetting_id' ");
$row5 = mysql_fetch_assoc($sql5);
print'
<ul class="id_'.$ItemID.'">
<li class="item_col">
<img src="lib/img/products/'.$row3['ThumbNailImage'].'" width="113" height="91" alt="'.$row3['Name'].'" />
<span class="item">'.$row3['Name'].'</span>
<span class="for_vehicle">for '.$row5['MAKE'].' '.$row5['MODEL'].'</span>
</li>
<li>
<ul class="quantity">
<li>'.$quantity.'</li>
<li class="btns">
<div class="add" title="Add Quantity"> </div>
<div class="minus" title="Remove Quantity"> </div>
</li>
</ul>
</li>
<li>$150.00</li>
<li class="remove"><div class="remove_item" title="Remove Item"> </div></li>
</ul>
';
endwhile;
endif;