Topic awaiting preservation: REGEXP

Is there any reason why $privateforum IS also matching 5?
Or perhaps somehow I can be more specific with REGEXP?
The idea is ONLY to block the numbers within $privateforum.

<BLOCKQUOTE><FONT face="Verdana, Arial">code:</font><HR><pre>$privateforum = '"<B>([3]

... and this was *what* to do with regular expressions?


Code - CGI - links - DHTML - Javascript - Perl - programming - Magic - http://www.twistedport.com
ICQ: 67751342

Again - The idea is ONLY to block the numbers within $privateforum. (MySQL uses Henry Spencer's implementation of regular expressions, which is aimed at conformance with POSIX 1003.2. MySQL uses the extended version.)

__________________

Kriek says '[SYSTEMWIDE_MESSAGE] PHP Meetup'
What we do is never understood; only praised and blamed

[This message has been edited by Kriek (edited 07-28-2003).]

Kriek: There isn't need for a regular expression here. I use something similar to this:

quote:

---

/* add the forum ids you don't want displayed here */
$block_forums = "'69', '666'";

$sql = "SELECT threadid, title, forumid, lastpost, lastposter
FROM thread
WHERE forumid NOT IN ($block_forums)
ORDER BY lastpost DESC
LIMIT 5";

---

with the vBulletin forum at the GN (to block some forums - in this case the private ones) to get the list here:
http://development.gurusnetwork.com

I would also imagine there is a field that specifies which forums are private (if you just want to block them).

___________________
Emps

FAQs: Emperor

not to mention that regexps searches kill mysql performance faster than you can say 'argh'.

in (list,of,comma,seperated,values) on a row that has an index is going to be 11000x faster.

Emp, Thank you - I really appreciate it =)

Tyberius, Argh!

__________________

Kriek says '[SYSTEMWIDE_MESSAGE] PHP Meetup'
What we do is never understood; only praised and blamed

Kriek: No worries. Its a message mr.maX repeats but as with regular expression in general there are often more efficient ways of doing things.

___________________
Emps

FAQs: Emperor

Hey! some of us love Regular Expressions!


Code - CGI - links - DHTML - Javascript - Perl - programming - Magic - http://www.twistedport.com
ICQ: 67751342

To answer the question as to why 5 was getting matched as well as 4,6,7,8,9,0 should also get matched is that the square brackets create a character set so:

[24]

creates a set of two charcters that will match 2 & 4

to do this correctly should just be something like

^(2

Bit, that absolutely makes sense - thank you!

__________________

Kriek says '[SYSTEMWIDE_MESSAGE] PHP Meetup'
What we do is never understood; only praised and blamed