Prev: PHPExcel
Next: [PHP] PHP 5 Web Developer Position in Mountain View, CA
From: axis on 3 Jul 2008 11:34
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


 | 
Pages: 1
Prev: PHPExcel
Next: [PHP] PHP 5 Web Developer Position in Mountain View, CA