flash/php/mysql
flash/php/mysql
- Started
- Last post
- 5 Responses
- ********
so i am storing values in a mysql database sent from flash via php -
suppose i want to store a big long huge array(ie mouse coordinates from various users) in mysql, should i just make a new table everytime? I'm trying to store the array as a value in a cell, but that doesn't seem to work.thanks in (2)advance(d).
- toastie0
try using serialize() to convert your arrays to something you can store in a single value.
- unfittoprint0
why don't you insert one coordinate value by user row?
- ********0
thanks the both of you. i'll look into those suggestions.
- caseyc0
You could just store your coords in a string...
x|y,x|y,x|y
Then
mycoords = phpstring.split(",");
for (var i in mycoords)
{
mycoords[i] = mycoords[i].split("|");
}
- ********0
caseyc what's the limit on string length with mysql?