Re: Help with query MySQL and PHP

2008-07-03 Thread Ananda Kumar
you can do some thing like this. create table new_table(id int, hair varchar(50),eyes varchar(50)) select column1,column2,...from old_table; On 7/3/08, axis <[EMAIL PROTECTED]> wrote: > > This question is strictly related to the mysql query not the php code. > I need to either create a new tab

Re: Help with query MySQL and PHP

2008-07-03 Thread axis
This question is strictly related to the mysql query not the php code. I need to either create a new table from the old one or add columns. The thing is don't know how to do it. let me simplify things up: I need a query to retrieve values from the table PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS to a ne