How to save arrays in MySQL with PHP?

If you are using the native mysql drivers in PHP, then there are no MySQL arrays, you are creating an object that you iterate over. The idea is to iterate over the object's results and put those results into an array. Observe: <?php // Connecting, selecting database $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('my_database') or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM my_table'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?> The line you are looking for is: while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) Basically, mysql_fetch_array will return an associtive array containing the column name as the key, and the data for that column into $line. Then you can further push that into an array container. var $data = array(); ... $data[] = $line; ... You cannot otherwise take a mysql result and make it an array, you must iterate over the object. FYI - I do not reccomend using the native PHP drivers. Using an abstraction library makes your code so much more portable. Using native drivers may make for quick coding, but you loose so much more in the end. I've included links to Pear::DB, ADODB, and PDO as possible libraries to look at. There are more, these are just examples. Hope that helps.

If I understand your question correctly, you want to store the content of a php array in a MySQL database. You will need to create a MySQL table with columns that represent the contents of your php array. I would recommend using phpmysqladmin to do this. Then you will need to make several MySQL insert calls to insert the data into the table. You will need the following php calls: mysql_connect mysql_select_db then one or more mysql_query calls using an argument of the form: "INSERT INTO <table> (<col1>, <col2>...) VALUES (<val1 for col1>, val1 for col2>...), (<val2 for col1>,<val2 for col2>...)...;" then mysql_close.

If I understand your question correctly, you want to store the content of a php array in a MySQL database. You will need to create a MySQL table with columns that represent the contents of your php array. I would recommend using phpmysqladmin to do this. Then you will need to make several MySQL insert calls to insert the data into the table. You will need the following php calls: mysql_connect mysql_select_db then one or more mysql_query calls using an argument of the form: "INSERT INTO <table> (<col1>, <col2>...) VALUES (<val1 for col1>, val1 for col2>...), (<val2 for col1>,<val2 for col2>...)...;" then mysql_close.

Store the "array" WITH A SPACE BEFORE THE FIRST ITEM AND AFTER THE LAST ITEM. Then you can use LIKE ' 73 '