Preg and Sql

[Chris2k]

Hi,

here's my code:

        $naD = '@^(?:http:\/\/)?([^/]+)\.(mysiteproject\.com|qualtrics\.com|doattend\.com|ning\.com|eventzilla\.net|page\.tl|weebly\.com|espacioblog\.com|pbworks\.com|mysoulspot\.com|fora\.se|healthkicker\.com|posterous\.com|springnote\.com|renspace\.com|beep\.com|blog4ever\.com|insanejournal\.com|webs\.com|zoomshare\.com|webblogg\.se|tl|se|de|edu)@i';

        if(preg_match($naD, $surl)) {
            mysql_query("DELETE FROM wcddl_sites WHERE url='". $naD ."'");
//            header("Location: http://www.google.com");
        } 

its not working, What im tryna do is filter those urls via $naD,google says i can use:

mysql_query("DELETE FROM wcddl_sites WHERE url REGEXP '". $naD ."'");

Can ay1 tell me this ok and if this ok: mysql_query("DELETE FROM wcddl_sites WHERE url REGEXP '". $naD ."'");

?

Chris2k Reviewed by Chris2k on 21st Apr 2012. Preg and Sql Hi, here's my code: $naD = '@^(?:http:\/\/)?(+)\.(mysiteproject\.com|qualtrics\.com|doattend\.com|ning\.com|eventzilla\.net|page\.tl|weebly\.com|espacioblog\.com|pbworks\.com|mysoulspot\.com|fora\.se|healthkicker\.com|posterous\.com|springnote\.com|renspace\.com|beep\.com|blog4ever\.com|insanejournal\.com|webs\.com|zoomshare\.com|webblogg\.se|tl|se|de|edu)@i'; if(preg_match($naD, $surl)) { mysql_query("DELETE FROM wcddl_sites WHERE url='". $naD ."'"); // header("Location: Rating: 5