Help with query MySQL and PHP
| From: | axis | 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 28with 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