I am trying to get the sizes for a product into a select list but what i have tried so far hasnt worked. I found some code from another site that someone helped me build but i cant get it to work
here is the code i am using
[php]$var1_rsProdList = “-1”;
if (isset($_GET[‘recordID’])) {
$var1_rsProdList = $_GET[‘recordID’];
}
mysql_select_db($database_poochie, $poochie);
$query_rsProdList = sprintf(“SELECT * FROM poochieProd, poochieCat WHERE poochieProd.CatID = poochieCat.CatID AND poochieProd.ProdID = %s”, GetSQLValueString($var1_rsProdList, “int”));
$query_limit_rsProdList = sprintf("%s LIMIT %d, %d", $query_rsProdList, $startRow_rsProdList, $maxRows_rsProdList);
$rsProdList = mysql_query($query_limit_rsProdList, $poochie) or die(mysql_error());
$row_rsProdList = mysql_fetch_assoc($rsProdList);
if (isset($_GET[‘totalRows_rsProdList’])) {
$totalRows_rsProdList = $_GET[‘totalRows_rsProdList’];
} else {
$all_rsProdList = mysql_query($query_rsProdList);
$totalRows_rsProdList = mysql_num_rows($all_rsProdList);
}
$totalPages_rsProdList = ceil($totalRows_rsProdList/$maxRows_rsProdList)-1;
$var3_Recordset1 = “-1”;
if (isset($_GET[‘ProdID’])) {
$var3_Recordset1 = $_GET[‘ProdID’];
}
mysql_select_db($database_poochie, $poochie);
$query_Recordset1 = sprintf(“SELECT * FROM poochieProd, poochieStock, poochieSizes WHERE poochieStock.sizeID = poochieSizes.SizeID AND poochieProd.ProdID = %s”, GetSQLValueString($var3_Recordset1, “text”));
$Recordset1 = mysql_query($query_Recordset1, $poochie) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);[/php]
and this is the select list
[php]
Select Size
<?php
$query2 = sprintf("
SELECT DISTINCT
stock.stockID, size.Size
FROM
poochieProd AS prod
LEFT JOIN pochieStock AS stock ON prod.ID = stock.ID
LEFT JOIN poochieSizes AS size ON stock.SizeID = size.SizeID
WHERE
prod.ID = ‘%s’ AND stock.Stock > 0
ORDER BY
size.SizeID ASC", GetSQLValueString($var3_Recordset1, “int”));
$results2 = mysql_query($query2);
while($row2 = mysql_fetch_array($results2)){
?>
<?php echo $row2['Size']; ?>
<?php
}
?>
</select>[/php]
please could someone tell me where i am going wrong?
thanks in advance