Help with query MySQL and PHP

[axis <axis@xxxxxxxxxxxxxx>]

Hi,

I want to create a new column or table from queries of the values of 
columns I( already have.

My table is :

PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS
products_id     products_extra_fields_id     products_extra_fields_value
  1                                 
1                                         Blond
  1                                 
2                                         Green
  1                                 
3                                         1.75
   1                                 
4                                         24
   2                                 
1                                         Brunette
   2                                 
2                                         Hazel
   2                                 
3                                         1.56
   2                                 
4                                         28


with this Select query >>>

function get_extra($extra_array = '') {
  if (!is_array($extra_array)) $extra_array = array();

  $extra_query = db_query("select products_extra_fields_value from " . 
TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " where 
products_extra_fields_id = '1'");
  while ($extra = db_fetch_array($extra_query)) {
    $extra_array[] = array('id' => $extra['products_extra_fields_id'], 
'text' => $extra['products_extra_fields_value']);
  }

  return $extra_array;
}

This function uses the query: select products_extra_fields_value from 
PRODUCTS_EXTRA_FIELDS where products_extra_fields_id = 1;

and returns Rubia and Morocha which is fine, now I need to

either create a new column or table in order to be able to have those 
values in their own column

my knowledge of mysql is limited so please give me suggestions as what 
to use in order to create a function to retrieve values and add them 
automatically to my table or columns

The table or columns have to be something like:

ID     Hair             Eyes
      Blond          Green
      Brunette      Hazel

so I can call them later by selecting from a column in a table like  
TABLE_PRODUCTS_EXTRA_FIELDS_TO_PRODUCTS_EXTRA_FIELDS_VALUE

pef2pev.hair, pef2pev.eyes ... and so on

here is my current switch

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
  switch ($column_list[$i]) {
    case 'PRODUCT_LIST_MODEL':
      $select_column_list .= 'p.products_model, ';
      break;
    case 'PRODUCT_LIST_MANUFACTURER':
      $select_column_list .= 'm.manufacturers_name, ';
      break;
      // aDD eXTRA FIELdS
    case 'PRODUCT_LIST_HAIR':
               $select_column_list .= 'pef2pev.hair, ';
        break;

and so on ...

   break;
  }
}

Thanks


Rick Fitzgerald



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php