[thelist] MySQL SELECT and INSERT not following (my) logic

Andrew Maynes andrew at humanbehaviour.co.uk
Wed Feb 12 11:42:31 CST 2003


Hi Rich

sorry this was posted after I had managed to see how to get around the problem
whilst it isn't a proper solution I am now getting the name of the colour
inserted and not the value :)

this is the function / query alterd to insert the colour name :)


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=\"$cName\">$cName</option>";
		}
	}
}




More information about the thelist mailing list