Problems with MySQL and arrays

Posted: Sat May 31, 2003 3:28 am (9 years, 11 months ago)

Hello everybody!

Is it possible to get arrays out of a mysql database (without unserialize(); )? I mean I have strings in form of

Code:

$table1 = "23.1,45.7,43.8,14.9";
$table2 = "43.6,34.7,66.6,99.1,34.8";

and want to cut them on each comma to put them into an array.
Like that:

Code:

$table1 = array(23.1,45.7,43.8,14.9);

So I can use every number.

Thx for your help!
Milchbazi

PS: It would be the best if I could use it in a function, because I need the same process a lot!

Posted: Sat May 31, 2003 3:37 am (9 years, 11 months ago)

Helped myself already!

Code:

$table1 = explode(",",$table1);

But do you have an other suggestion? let me know!

See you!
Milchbazi

Posted: Sat May 31, 2003 7:54 am (9 years, 11 months ago)

Hi Milchbazi,

That is the best way to do it that I know of, and it is the way I'm using here at 4WebHelp for tutorial authors who have multiple websites. Smile

Daniel