explode()

[sabret00the]

i've always managed to avoid this up until now but now i really need it.

basically i want to check is a table column has a value, if it does, i need to explode it

so up to here i gues it's

PHP Code:

if ($bbuserinfo[grps])
 {
     $grps_ids = explode(' ', trim($bbuserinfo['grps'])); 


but once it's exploded how do i check the values?

with a query i'm guessing i could've used the FIND_IN_SET but i'm really trying to limit the queries at this stage

also how would i go about updating such a column? would it simply be

PHP Code:

UPDATE user SET grps = $bbuserinfo[grps] + $newvalue 


?

[Andreas]

PHP Code:

if (in_array($grps_ids, 11)) {
  // Put some code here if 11 is in grps_ids
} 


[sql]update user set grps = if(grps='', $newvalue, concat_ws(' ', grps, $newvalue))[/sql]

[amykhar]

Given that explode puts the values in an array, could you use this:

http://us4.php.net/in_array

to see if the value is in the array?

[sabret00the]

you both helped and so close together, thank you amy thanks to the link i know exactly how it works, and thanks kirby, very swift and you helped em with the query too

[sabret00the]

Originally Posted by KirbyDE

[sql]update user set grps = if(grps='', $newvalue, concat_ws(' ', grps, $newvalue))[/sql]

how would i go about reversing this query?

[noppid]

No offense, but I was going to post a link to php.net too. Most of the questions you've asked so far on php functions are answered on top of each functions page and clearly explained. I was under the impression you didn't have that info from your questions.

and iif() is being deprecated, you shouldn't rely on it existing in future releases of vB.

[sabret00the]

i'm not usuing the iff in here though

ok i'm assuming you're talking about the other thread, i appreciate where you're comign from however asking for help in a bid to learn something should never be frowned upon, in that latest incident where i was asking about the conditional, it was actually the conditional and not the in_array() function, if you check the thread again, you'll see i actually state that i was just wondering if i could do that, also in regards to the number of threads i ask for help, i do actually in around half cases get the answers myself, it's called the process of learning.

[noppid]

Wow you're right, Sorry I said anything, you got it handled.

On the iif, you're right, I was seeing double. I didn't have my glasses on.

If() does not return anything other then true or false, I assumed iif() since you seem to be expecting a data return for that code to work.

Actually, if() does not return anything at all, it evaluates to true or false.

[sabret00the]

searching php.net, i couldn't find concat_ws that's why i came back to this thread, as the value in grps could be an array of 10 different numbers, so i want to remove the one that would be in the first post $newvalue and that's it, but not being able to find concat i can't even read up on it.

[Dean C]

concat_ws is a mysql function sabe:

http://dev.mysql.com/doc/mysql/en/string-functions.html