Hi,
I have a cart page that posts from results just fine. The problem is clothing and non clothing items posted on merchants site may or may not need select options for color or size. Or may only need just a few select options for each rather than having all available fields to post to. Would like to post select options when values exist in database and only for available values. With current all select options exist whether or not there are any field variables.
Also a solution for posting "similar products" like maybe 4 or 5 products to be posted on cart page. I know I will need to setup new fields in database to refer to associated products, just wonder what best way is to post.
Any help appreciated, I couldn't find anything to resolve to date.
Thanks,
James
Here is the code thus far:
<?php
$server = "localhost";
$user = "";
$pass = "";
$database = "";
$conn = mysql_pconnect ($server,$user,$pass);
$select = mysql_select_db("$database")or die ("unable to select db");
$result = mysql_query ("SELECT * FROM TABLE
WHERE ID LIKE '$ID1%'
AND ID LIKE '$ID%'
limit 0,1
");
if ($row = mysql_fetch_array($result)) {
do {
print ("
Various db product output ...
Cart Code .......
<SCRIPT LANGUAGE=Javascript>
function addP$rowCat_No
{
document.uShopJSI.addProduct(
'P$row[Cat_No]',
'$row[Name]',
'$row[Description_Cart]' +
' ' +
document.P$row[Cat_No].size.options[document.P$row[Cat_No].size.selectedIndex].value +
' ' +
document.P$row[Cat_No].color.options[document.P$row[Cat_No].color.selectedIndex].value,
'$row[Wt]',
document.P$row[Cat_No].quantity.value,
'$row[Price]',
'$row[Price_mod]',
'$row[Class_1]_$row[Class_2]',
'$row[Ship_mod]',
'$row[Taxable]');
}
</SCRIPT>
<FORM NAME=P$row[Cat_No]>
<SELECT NAME=size Size=1>
<option value=\"\">Select Size
<option value='- Size: $row[Size_1]'>$row[Size_1]
<option value='- Size: $row[Size_2]'>$row[Size_2]
<option value='- Size: $row[Size_3]'>$row[Size_3]
<option value='- Size: $row[Size_4]'>$row[Size_4]
<option value='- Size: $row[Size_5]'>$row[Size_5]
<option value='- Size: $row[Size_6]'>$row[Size_6]
<option value='- Size: $row[Size_7]'>$row[Size_7]
<option value='- Size: $row[Size_8]'>$row[Size_8]
<option value='- Size: $row[Size_9]'>$row[Size_9]
<option value='- Size: $row[Size_10]'>$row[Size_10]
<option value='- Size: $row[Size_11]'>$row[Size_11]
<option value='- Size: $row[Size_12]'>$row[Size_12]
<option value='- Size: $row[Size_13]'>$row[Size_13]
<option value='- Size: $row[Size_14]'>$row[Size_14]
<option value='- Size: $row[Size_15]'>$row[Size_15]
<option value='- Size: $row[Size_16]'>$row[Size_16]
<option value='- Size: $row[Size_17]'>$row[Size_17]
<option value='- Size: $row[Size_18]'>$row[Size_18]
<option value='- Size: $row[Size_19]'>$row[Size_19]
<option value='- Size: $row[Size_20]'>$row[Size_20]
<option value='- Size: $row[Size_21]'>$row[Size_21]
<option value='- Size: $row[Size_22]'>$row[Size_22]
<option value='- Size: $row[Size_23]'>$row[Size_23]
<option value='- Size: $row[Size_24]'>$row[Size_24]
<option value='- Size: $row[Size_25]'>$row[Size_25]
<option value='- Size: $row[Size_26]'>$row[Size_26]
<option value='- Size: $row[Size_27]'>$row[Size_27]
<option value='- Size: $row[Size_28]'>$row[Size_28]
<option value='- Size: $row[Size_29]'>$row[Size_29]
<option value='- Size: $row[Size_30]'>$row[Size_30]
<option>_________________________
</SELECT><br>
<SELECT NAME=color Size=1>
<option value=\"\">Select Color
<option value='- Color: $row[Color_1]'>$row[Color_1]
<option value='- Color: $row[Color_2]'>$row[Color_2]
<option value='- Color: $row[Color_3]'>$row[Color_3]
<option value='- Color: $row[Color_4]'>$row[Color_4]
<option value='- Color: $row[Color_5]'>$row[Color_5]
<option value='- Color: $row[Color_6]'>$row[Color_6]
<option value='- Color: $row[Color_7]'>$row[Color_7]
<option value='- Color: $row[Color_8]'>$row[Color_8]
<option value='- Color: $row[Color_9]'>$row[Color_9]
<option value='- Color: $row[Color_10]'>$row[Color_10]
<option value='- Color: $row[Color_11]'>$row[Color_11]
<option value='- Color: $row[Color_12]'>$row[Color_12]
<option value='- Color: $row[Color_13]'>$row[Color_13]
<option value='- Color: $row[Color_14]'>$row[Color_14]
<option value='- Color: $row[Color_15]'>$row[Color_15]
<option value='- Color: $row[Color_16]'>$row[Color_16]
<option value='- Color: $row[Color_17]'>$row[Color_17]
<option value='- Color: $row[Color_18]'>$row[Color_18]
<option value='- Color: $row[Color_19]'>$row[Color_19]
<option value='- Color: $row[Color_20]'>$row[Color_20]
<option value='- Color: $row[Color_21]'>$row[Color_21]
<option value='- Color: $row[Color_22]'>$row[Color_22]
<option value='- Color: $row[Color_23]'>$row[Color_23]
<option value='- Color: $row[Color_24]'>$row[Color_24]
<option value='- Color: $row[Color_25]'>$row[Color_25]
<option>_________________________
</SELECT><br>
<INPUT TYPE=text SIZE=2 NAME=quantity VALUE=1> Qty<br>
<A HREF=\"\" onClick=\"addP$rowCat_No;return false;\"><IMG SRC=/images/cartadd.gif width=157 height=40 border=0 align=TOP></A><br><br>
");
} while($row = mysql_fetch_array($result));
} else {print "
<center><b>Sorry, no product records were found!</b></center><br><br><br>
";}
?>
