mySQL arrays

F_SH

Can a mysql database store arrays any way? I want to create an ever-growing history of value x but I don't particularly want hundreds of addtional fields. What is the data type? Is it the ENUM type? If so, is the data in it accessed like a php array?

I tried to use SET and ENUM, but it returned error 1064: Syntax error, apparently near the end. I used the following syntax:

ALTER TABLE tblcomp CHANGE SaleHistory SaleHistory ENUM NOT NULL
Error: 1064 - You have an error in your SQL syntax near 'NOT NULL' at line 1

I also tried without Not Null, putting some data in. Same result. I'm using MySQLfront, BTW...

nnichols

MySQL does not currently have native support for arrays. You can store the serialized data from an array but this is not very helpful as it is not searchable (not easily anyway).

Instead of adding lots of fields you should just have an extra table containing individual records for the history.

gtibok

Set and Enum are optional types Enum('yes', 'no') means that the field must be eighter yes or no.

to store log use a text filed and:

$get_log=mysql_query("SELECT log FROM `table` WHERE id='$id'") or die('autch');
$logz=mysql_fetch_array($get_log);
$updated="$logz[0], $new_log";
$update_log=mysql_query("UPDATE `table` SET  log='$updated' WHERE id='$id'") or die(diehard II);
echo "see ? ... it's easy";
//to select a specific log you can
explode(", ", $logz[0]);

nnichols

why not do it with just a single query if going down that root -

$sql = "UPDATE `table` SET  log=CONCAT(log,' ,$new_log') WHERE id='$id'";
$res = mysql_query($sql) or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

gtibok

I'm not that good.😕 :rolleyes:
I use many simple queries, but sure yours it's better.

F_SH

I'll try those, but I thing I'll just use a string. I know that x is always 3 digits long, so I can encode and decode my array easily enough.

thanks alot!