RE: query inserts from a table join and back again ina diiferent guise

2003-02-10 Thread Andrew
L PROTECTED]] >Sent: 07 February 2003 21:54 >To: MySQL-Lista >Subject: MySQL query inserts from a table join > > >I don't know whetehr this is going to make any sense! > >I have a query pulling records from MySQL tables that are joined.

query inserts from a table join

2003-02-09 Thread Andrew Maynes
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_colou