mysql array

[Haris_P]

Hi,
Is it possible for a datafield in a mysql database to be an array? For example: I have a table called info, and in "info" i want to have an array of "years" so i can insert more than one year in "years."

This is what I have so far:

  //years = array of years the car was made
  //info = table
  	$years = @mysql_query('SELECT years FROM Info');
	if (!$years) 
	{
  		die('<p>Error performing query: ' . mysql_error() .
      '</p>');
	}

while ( $row = mysql_fetch_array($years) ) 
{
	echo('<p>' . $row['years'] . '</p>');
}

[tekky]

explain your reasoning behind an array.... maybe there is a more efficient way to do what you are trying....

[liquorvicar]

you can achieve this effect by creating your own serialising function.
for example:

$years = array('2002','2003','2004');
$sql_years = implode('|',$years);
$sql = "INSERT INTO table (years) VALUES ('$sql_years')";

and

$sql = "SELECT * FROM table";
$years = explode('|',$row['years']);
print_r($years);