I don't know whetehr this is going to make any sense!
I have a query pulling records from MySQL tables that are joined. The join is
for a color_id to an item...
///////////////////////////////////////////////
function showColor($item_id)
{
$query="select ref_colours.* from item_color ,ref_colours where
ref_colours.ColorID=item_color.color_id and item_color.item_id=$item_id";
$rs=mysql_query($query);
if(!$rs)
{
echo "Error while exeuting the query";
}
else
{
while($row=mysql_fetch_array($rs))
{
$color_id=$row['ColorID'];
$cName=$row['ColorName'];
echo "<option value=\"$color_id\">$cName</option>";
}
}
}
I guess without beating about the bush I just need to ask. What should the
value be set to for me to insert the color into a table along with the rest of
the chosen items details? this is the form:
echo "<SELECT name=\"cName\" value=\"$cName\">";
showSize($II);
echo "</SELECT> ";
this is the add.php insert....
mysql("$DBName","INSERT INTO CartItems VALUES
('$UID','$ItemID','$ItemQuantity','$Date','$CartItemsID','$cName')");
but this is just inserting a value of 1 everytime :(
Thank you all for reading my problem :)
Andrew
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
