Re: Help with query MySQL and PHP
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 new one or add columns.
the new table should look like
ID Hair Eyes
Blond Green
Brunette Hazel
The php code is not what I want I need the query, to do exactly that.
Then I will use it in my php code, but what that is not what I am asking
at this time. Just the query to do that.
Thanks,
Rick Fitzgerald
John Meyer wrote:
It would be better to post this sort of question at
[EMAIL PROTECTED]
axis wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query MySQL and PHP
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 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 new one or add columns.
the new table should look like
ID Hair Eyes
Blond Green
Brunette Hazel
The php code is not what I want I need the query, to do exactly that.
Then I will use it in my php code, but what that is not what I am asking at
this time. Just the query to do that.
Thanks,
Rick Fitzgerald
John Meyer wrote:
It would be better to post this sort of question at
[EMAIL PROTECTED]
axis wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with query MySQL and PHP
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
