Options not displaying in menus
Hi I've followed your instructions as closely as possible and it is not displaying my options in the drop down menu I've created.
The URL parameter being passed to the product detail page is simply 'product'
I have set up the recordsets just like you said.. one thing though, I could not select the 'type: Number' only 'type:Integer'
My recordset has turned out like this - can you be so kind as to run your expert eye over it to see if I've got anything wrong?:
Recordset detail:
$paramOptionID_rs_size = " -1";
if (isset($_GET['<product>'])) {
$paramOptionID_rs_size = $_GET['<product>'];
}
mysql_select_db($database_shoei_conn, $shoei_conn);
$query_rs_size = sprintf("SELECT options.* FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID WHERE options.OptionGroupID = 2 AND productoptions.ProductID = %s", GetSQLValueString($paramOptionID_rs_size, "int"));
$rs_size = mysql_query($query_rs_size, $shoei_conn) or die(mysql_error());
$row_rs_size = mysql_fetch_assoc($rs_size);
$totalRows_rs_size = mysql_num_rows($rs_size);
Is this right?