[thelist] reworded MySQL query insert and back again

[Michele Foster]

----- Original Message -----
From: "rudy" <r937 at interlog.com>
>
> > echo "<SELECT name=\"ColorName\" value=\"$ColorName\">";
> > showColor($II);
> > echo "</SELECT> ";


Naw, ya haven't lost me .. I'm just slow ;)

However,

Andrew's table structure

ColorName  ColorName

blue 1
black 2
green 3


Why are there two ColorName fields?  That's definitely bound to confuse.  Is
that just a typo when you wrote it out?  I'd be surprised if any DB would
let ya name two fields the same thing in the same table.

I'd be curious to see what the HTML output is for this

echo "<SELECT name=\"ColorName\" value=\"$ColorName\">";
 showColor($II);
 echo "</SELECT> ";

Not a php'er here .. but what is "showColor($II)" showing?  column 1 or
column 2?

Mich