Help with adding element to array

grumpy

Hello-
I wrote a simple script to add an element to any array stored in a table, but it doesn't add the element. Why doesn't my code work? The code is below. Thanks for your help.

<?php

//Attempting to add the number 11 to an array in column array_test//where the row ID = 1235

$ID=1235;
$array_test[]=11;

$sql = "UPDATE table SET
array_test='$array_test'
WHERE ID=$ID
";

cgraz

does $array_test only contain one value? If so, why is it an array and not just a string?

Secondly, if it is an array, Instead of 11 you're probably just getting the word Array.

What i'd do is print $sql to see what the query looks like before it's executed.

And also, put your php code within the following tags

[ p h p ] code here [ / p h p ]

(minus the spaces). It'll highlight your code and make it much easier to read.

Cgraz

mogster

If you're gonna append another war to the array, you can use array_push():

$ID=1235; 
$narray = array_push ($array_test, "11");
$narraystring = implode(",", $narray);
$sql = "UPDATE table SET array_test='$narraystring' WHERE ID=$ID";

but if you are gonna update the db with new value, you don't need to deal with arrays at all.
Just select the value from db-field array_test (as a string), then append the new value + the separator you use:

$query = mysql_query("select array_test from table WHERE ID=$ID");
$append = mysql_fetch_array($query);
$newvalue = "11";
$updateappend = $append . "," . $newvalue;
$sql = "UPDATE table SET array_test='$updateappend' WHERE ID=$ID";

knutm

grumpy

Hello, Mogster-
Thanks for your reply. I tried both your methods and neither works. The first results in two errors:
Warning: array_push() [function.array-push]: First argument should be an array AND
Warning: implode() [function.implode]: Bad arguments

Your second method does not cause any errors but the table still is not updated.

Any other suggestions would be appreciated. Thanks

mogster

It's a while since this was posted, but I hate to leave a prob unfinished, so...

The first errors is due to that the $array_test isn't an array. I don't know how the rest of the code looks like, see? Just assumed that it was.
Correction:

$ID=1235; 
$array_test = array();
$narray = array_push ($array_test, "11");
$narraystring = implode(",", $narray);
$sql = "UPDATE table SET array_test='$narraystring' WHERE ID=$ID";

As for the other code, I guess you have to post more data here, but try first to implement the above to that code (create the $array_test with array().

knutm