an array inside a mysql table
Posted: Thu Sep 30, 2004 12:14 pm
hello;
I have a table, the_table:
_____________________________
|column_1 |
|---------------------------------------|
|("index_1"=>"doo-hicky-A") |
|________________________|
that is a php associative array within a field;
ofcourse I can mysql:SELECT * FROM THE_TABLE and return it to the php script, do whatever I need to do inside the array with php, and then mysql:UPDATE THE_TABLE ... ;
however what I would like to do is have a table, ideal_table:
_______________________
|column_1 |
|-------------------------------|
|a mysql formatted array |
|______________________|
such that I can mysql:UPDATE IDEAL_TABLE SET COLUMN_1.INDEX_1 = 'DOO-HICKY-B' WHERE COLUMN_1.INDEX_1='DOO-HICKY-A'
any thoughts
thanks
Shannon Burnett
I have a table, the_table:
_____________________________
|column_1 |
|---------------------------------------|
|("index_1"=>"doo-hicky-A") |
|________________________|
that is a php associative array within a field;
ofcourse I can mysql:SELECT * FROM THE_TABLE and return it to the php script, do whatever I need to do inside the array with php, and then mysql:UPDATE THE_TABLE ... ;
however what I would like to do is have a table, ideal_table:
_______________________
|column_1 |
|-------------------------------|
|a mysql formatted array |
|______________________|
such that I can mysql:UPDATE IDEAL_TABLE SET COLUMN_1.INDEX_1 = 'DOO-HICKY-B' WHERE COLUMN_1.INDEX_1='DOO-HICKY-A'
any thoughts
thanks
Shannon Burnett