Delete from HTML source <br />

using sql replace

[aff_dan]

Hello,

I have many articles that have this <br /> in my HTML source:

takes no obligation to revise the forward-looking statements contained ther<br />
ein to reflect events or circumstances after the date hereof as a result of<br />

It is ok to add:

$query = 'update wp_posts set post_content=REPLACE(post_content,"<br /> ","")';

But it doesnt delete, why?

Regards,
Dan

[inveni0]

I used strip_tags($row_Edit['Text'], '<br />'); to accomplish this.

[aff_dan]

Hi Invenio,

but how can I add
you idea in query = 'update wp_posts set post_content=REPLACE(post_content,"<br /> ","")';?

in this?
$query = 'update wp_posts set post_content=strip_tags($row_Edit["Text"], "<br />","")';;

I want to delete from html source <br />

It is ok that code?

[aff_dan]

Isnot working also:

$query = 'update wp_posts set post_content=REPLACE(post_content,"<br \/> ","")';
mysql_query($query);

WHY?

[inveni0]

Try it and see...that's how I test code. :)

[aff_dan]

I got this error:

$query = 'update wp_posts set post_content=strip_tags($row_Edit["Text"], "&lt;br /&gt;","")'

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '$query = 'update wp_posts set post_content=strip_tags($row_Edit

[inveni0]

You have to change:

"Edit["Text"]"

To match your database setup.

[aff_dan]

what is TEXT?

<br />?

[aff_dan]

I used now:

$query = 'update wp_posts set post_content=strip_tags($row_post_content["Text"], "<br />","")';
mysql_query($query);

no changes

What I need is to delete <br />

[aff_dan]

takes no obligation to revise the forward-looking statements contained ther<br />
ein to reflect events or circumstances after the date hereof as a result of<br />

If I will delete just <br /> the text will look like:

takes no obligation to revise the forward-looking statements contained ther ein to reflect events or circumstances after the date hereof as a result of

will put space between "ther ein"

[inveni0]

$row_Edit['Text']

"edit" = the name of your recordset
"text" = the name of your column

[aff_dan]

I used this
$query = 'update wp_posts set post_content=strip_tags($row_post_content["&lt;br /&gt; "], "")';

no working

[aff_dan]

$row_Edit['Text']
"edit" = the name of your recordset
"text" = the name of your column

I still I dont understand:

My tabel is: wp_posts
My columns with posts is: post_content

So will look like:

$query = 'update wp_posts set post_content=strip_tags($row_wp_posts["post_content"], "<br />","")';

I still get

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '$query = 'update wp_posts set post_content=strip_tags($row_wp_p

[inveni0]

What are you trying to do with the data once you strip those tags?

[jatar_k]

your variable isn't being parsed by php because it is between single quotes and you need to concatenate those array values into your string

you have
$query = 'update wp_posts set post_content=strip_tags($row_post_content["Text"], "<br />","")';

should be
$query = 'update wp_posts set post_content=strip_tags(' . $row_post_content["Text"] . ', "<br />","")';