String Array

[Chris Clarkson]

Tweet

Hi,
Using a form I'm try to update 3 variables, all of which are arrays.
$var1 and $var2 are checkbox results and no problem, but $var3 is a text input, and I'm having trouble updating results.
eg. $var3 = text:more text:even more text:

I can create a db entry, using

    $result = sql_query("insert into ".$prefix."_blah values ('$id', '$var1', '$var2', '$var3')", $dbi); 

but can't update. Even tried Delete from and recreate entry, but still not working. I think the solution is to pass it ($var3) as a normal variable and not an array.

Sorry if this makes no sense, but any help appreciated!

Chris

[scifind]

Hi
to turn var3 from an array into a string (assuming you are using PHP)
use implode()
implode ( string glue, array pieces)


ie if your array $arr contains 3 elements a, b, c

$text_string= implode(", ", $arr);

$text_string will then = "a, b, c"

[Chris Clarkson]

Thanks scifind,
funny when I asked the question I wondered if the answer might be blindingly obvious!

Thanks very much, ended 4 days of hair pulling (not much there to begin with).

Cheers

Chris