# ¿ can i store ARRAY on mysql database?

**URL:** <https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565>\
**Category:** programming\
**Created:** [March 26, 2003, 7:06am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565 "2003-03-26T07:06:39Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![noxious](https://avatars.discourse-cdn.com/v4/letter/n/919ad9/32.png) [@noxious](https://forum.kirupa.com/u/noxious)\
**Post date:** [March 26, 2003, 7:06am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/1 "2003-03-26T07:06:39Z")

</div>

newbieee here… wondering if he can store ARRAY(s) on mysql database? …and if possible, how can i retieve it using php…:hangover:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:09am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/2 "2003-03-26T07:09:15Z")

</div>

you can use loops :)… i’ve done that before… i’ll post the script in a sec

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:13am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/3 "2003-03-26T07:13:06Z")

</div>

woooh! that sounds good! hehhe 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:17am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/4 "2003-03-26T07:17:22Z")

</div>

```php
myarray = ['ahmed', 'noxious', 'kirupa', 'someone'];
$ii=count($myarray);
mysql_connect('localhost', 'root', 'sesame');
mysql_select_db('dbname');
for($i=0; $i<$ii; $i++){ 
    $entry = $myarray[$i];
    $query = "INSERT INTO table_name ( column_name ) VALUES ('$entry');";
    mysql_query($query);
}

```

and to retrieve the data, make a select query (like the one in my sig 😛 )

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:24am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/5 "2003-03-26T07:24:20Z")

</div>

yo da man!!! super! lol  
thanx man… now i’ll try work my way out in loading those arrays on flash… wish me luck! 🙂

yeah your sig shows what you are… an sql addict? hehehee ;)!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:26am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/6 "2003-03-26T07:26:04Z")

</div>

hehe… let me know if you needed some more help =)

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:48am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/7 "2003-03-26T07:48:52Z")

</div>

PHP:--------------------------------------------------------------------------------  
$myarray = [‘ahmed’, ‘noxious’, ‘kirupa’, ‘someone’];  
mysql\_connect(‘localhost’, ‘root’, ‘sesame’);  
mysql\_select\_db(‘dbname’);  
$query = “INSERT INTO table\_name ( column\_name ) VALUES (’$myarray’);”;  
mysql\_query($query);

* * *

ahmed, is this possible?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [March 26, 2003, 7:53am UTC](https://forum.kirupa.com/t/can-i-store-array-on-mysql-database/16565/8 "2003-03-26T07:53:03Z")

</div>

havent tried it, but i really dont think so…  
you can still try it anyways, and let me know =)