[omardealo]

Originally Posted by kh99

Yes, it's a serialized array. It may be possible to come up with a regular expression that would let you check using sql, but the easier way to do it would be to read all the records, use unserialize to make an array, then search the array. Unfortunately, you need to read all the rows from that table to do it that way.

Depending on what you're doing, you may want to use the pm table. Then you could do something like:

$check = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "pmtext as pmtext
LEFT JOIN ".TABLE_PREFIX."pm AS pm ON(pm.pmtextid=pmtext.pmtextid)
WHERE pm.userid NOT IN ( 2,4,5 ) ");

Edit: actually I'm not sure about that query since I haven't tested it.

Edit again...also, I guess that will only work for finding users who haven't deleted the pm already.

thnx brother ,
look that's Query don't make What I want to do .
Let me explain it more ...
i want make a code to sure that some moderators don't see any meassge to some users [Sending PM and PM receiving] , so i must check if These users-ids into touserarray or not .
your Query is really a good idea , i did not think of it, despite its simplicity
but result of this Query cannot exception for [receiving messages] to these users-ids . only exception for [sent messages] .
i use regular expression before , but iam not good to used it Especially if [touserarray] contain more than User like that

PHP Code:

a:1:{s:2:"cc";a:2:{i:1;s:5:"admin";i:8;s:4:"soso";}} 


So I prefer to use MySql Query ... that's okay to read all rows but as i said i don't understand use unserialize () and how i use it with result Query