Eroare Column id in where clause is ambiguous
Scris: Lun Feb 04, 2013
Cum as putea face selectia dupa id si session_id din tabelu store_shoppertrack ??
Am incercat asa :
Dar cand functia face selectia imi zice asa :
Am incercat asa :
Cod: Selectaţi tot
if($_GET['id'] != ""){
$id = $_GET['id'];
$get_cart = "SELECT si.id, si.item_title, si.item_price, si.item_image, st.id, st.session_id, st.sel_item_id, st.sel_item_qty, st.date_added FROM `store_shoppertrack` AS st LEFT JOIN `store_items` AS si ON si.id = st.sel_item_id WHERE session_id = '$session_id' AND id = '$id'";
$get_cart_res = mysql_query($get_cart) or die(mysql_error());
while($cart = mysql_fetch_array($get_cart_res)){
$item_id = $cart['id'];
$item_title = stripslashes($cart['item_title']);
$item_price = $cart['item_price'];
$item_image = $cart['item_image'];
$item_qty = $cart['sel_item_qty'];
$item_id_info = $cart['sel_item_id'];
$total_price = sprintf("%.02f", $item_price * $item_qty);
}
} Cod: Selectaţi tot
Column 'id' in where clause is ambiguous