Help with query MySQL and PHP

From: Date: Thu, 03 Jul 2008 15:34:17 +0000
Subject: Help with query MySQL and PHP
Groups: php.general 
Request: Send a blank email to php-general+get-276253@lists.php.net to get a copy of this message
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

« previous php.general (#276253) next »