array

[0perator]

if i were to have a table in a databse called `challeneges`

 

the fields were

 

____________________

|username | completed|

-----------------------

username    b1, b2, b3

 

 

and i have

$done = mysql_fetch_array($sql);

 

now,

$done['completed'] = b1,b2,b3

 

how do i search the array of $done['completed'] to see if it contains the string b1

 

i was thinkning explode around the ,

 

am i right?

[thebadbad]

Yes. But you must decide if the challenges (?) are separated by a comma, or by a comma and a space. Use in_array() to search the exploded string.

[0perator]

ah right yes, they will be spearated by only a comma.

 

thanks

[0perator]

okay,

 

if b1 is not in there, how do i append it to the mysql_fetch_array()

without affecting what is already there.

[thebadbad]

If you want to append to a string, simply:

 

<?php
$str = 'b2,b3';
$str .= ',b1';
echo $str;
//b2,b3,b1
?>

 

To append an element to an array:

 

<?php
$array = array('b2', 'b3');
$array[] = 'b1';
//$array is now array('b2', 'b3', 'b1');
?>