Update TABLE with Array

jambom

Hi,

I am trying to run this query:

update users set categories in '({1,2,3,4})';

I am getting an incorrect syntax error - i am not too sure what i am doing here.

I am getting an array of numbers like above:

1,2,3,4,5,6

and i need to insert or update a record with this data.

Any ideas or help?

Many thanks in advance,

James

LordShryku

Originally posted by jambom
update users set categories in '({1,2,3,4})';

Okay now, are you updating records to this? Or are these existing records to update? If so, update to what?

leatherback

Hi,

if you update a table, you need two sets of data: One which defines which record needs to be updated. The other which holds the data to update with.

If you have an array, I would use foreach:

Your array: $myarray
$statement is the statement which defines the record to update.

foreach($myarray as $value)
  {
  echo $value;
  $update = mysql_query("update table set categories='$value' where $statement") or die(mysql_error);
  if($update)
     { echo "succes!"; }
  }

jambom

i need to be able to insert it first then update it.

I will be getting an array of numbers it could be anything from:

to:

1,2,5,7,88,554

it needs to be comma seperated as i need to put it into a varible so i can do a select e.g.:

select catname from categoried where catref in ($categoried);

LordShryku

So all you need to know is how to comma delimit your array values?
[man]implode[/man]