Retrieving Array From MYSQL

[OntarioEastern]

I have saved in a MySQL Table an array. When I retrieve the information, and try to list the information in the array retrieved, I am getting the error saying that the information is not an Array.

I should add that the array when saved to mySQL is actually an array, within an Array.

How do I maintain an array as an array when its been saved to MySQL, and then retrieved.

My Code is as follows...

    $dbquery = "SELECT * FROM tickets WHERE ticketid='1'";
    $result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
    $bob = mysql_fetch_array($result);
    $arraythree=$bob[note];

$cr=count($arraythree);

$i=0;
echo "<table cellpadding='0' cellspacing='0' border='1' width='400'>";
while($i!=$cr)
{
list($recorddate, $recordtime, $recordtech, $recordmessage)=$arraythree[$i];
echo "<tr><td width='100'>Date: ".$recorddate."</td><td width='100'>Time: ".$recordtime."</td><td width='200' align='right'>".$recordtech."</td></tr><tr><td colspan='3'>".$recordmessage."</td></tr>";
$i=$i+1;
echo "<tr><td height='20' colspan='3'></td></tr>";
}
echo "</table>";
?>

[sid]

$dbquery = "SELECT * FROM tickets WHERE ticketid='1'"; 
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();} 
$bob = mysql_fetch_array($result); 
$arraythree=$bob[note]; //HERE is the error - $arraythree is NO array

$cr=count($arraythree); 

$i=0; 
echo "<table cellpadding='0' cellspacing='0' border='1' width='400'>"; 
while($i!=$cr) 
{ 
list($recorddate, $recordtime, $recordtech, $recordmessage)=$arraythree[$i]; //HERE you use $arraythree as an array - it is not!
echo "<tr><td width='100'>Date: ".$recorddate."</td><td width='100'>Time: ".$recordtime."</td><td width='200' align='right'>".$recordtech."</td></tr><tr><td colspan='3'>".$recordmessage."</td></tr>"; 
$i=$i+1; 
echo "<tr><td height='20' colspan='3'></td></tr>"; 
} 
echo "</table>"; 
?>

i am not sure if you want to work with $bob or $bob[note] when using count() (do you use a 2-dimensional array?) - but i suppose with the first one, judging by what you seem to be trying to do - it wont work yet - you have to revamp the list() part - but it should help you:

$dbquery = "SELECT * FROM tickets WHERE ticketid='1'"; 
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();} 
$bob = mysql_fetch_array($result); 

$i=0; 
echo "<table cellpadding='0' cellspacing='0' border='1' width='400'>"; 
while($i!=count($bob)) 
{ 
list($recorddate, $recordtime, $recordtech, $recordmessage)=$bob[$i]; 
echo "<tr><td width='100'>Date: ".$recorddate."</td><td width='100'>Time: ".$recordtime."</td><td width='200' align='right'>".$recordtech."</td></tr><tr><td colspan='3'>".$recordmessage."</td></tr>"; 
$i=$i+1; 
echo "<tr><td height='20' colspan='3'></td></tr>"; 
} 
echo "</table>"; 
?>

[OntarioEastern]

I tried the suggestion. What I received was an output with each field from the "list" as a letter of the word "array"

so this does part of it. But the value in the database is an array, within an array.

When I originally wrote the script to learn how to use arrays within arrays and push more values into the outer arrays, it worked fine until I split the file and had the creation of the array in one file, and the display in another. Now this isnt working.

I am posting below how I create the array that is inserted into MySQL. Perhaps this will give an Idea of what I am doing.

Code:

$arrayone = array($date, $time, $tech, $messageone);
$arraytwo = array($arrayone);

    $dbquery = "insert into tickets values ( NULL , ";
    $dbquery = $dbquery."\"".addslashes(stripslashes($arraytwo))."\" ) ";
    $result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}