HungryMind Posted September 10, 2011 Share Posted September 10, 2011 Hi, I've this query select id=>ID, name=>Name/h, icon=>My Picture/img, link=>Link/a, active=>Action from es_socialmedia where del='no' order by id desc limit 0,20 I just want to remove these: =>ID=>Name/h=>icon=>My Picture/img=>Link/a=>Action I'm using this preg_replace() preg_replace("@=>[a-zA-Z_(\/(.?))]*@", "", $sql); It's working perfect. But! when i'm using space between "My Picture/img"Then i'm getting error.I tried (\s) too, But it's not working :SIf i'm using "My_Picture/img" with underscore. It works perfect.Plz could anyone refine this sql query for me?Help will be appreciated. Link to comment Share on other sites More sharing options...
justsomeguy Posted September 12, 2011 Share Posted September 12, 2011 Why does the query start like that? It would probably be better to change it so that it starts correctly instead of trying to correct it after the fact. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.