I use php and mysql ....
there is about 4000 products in the database ....
during import for some reason there are a few here and there
that are missing some of there closing html tags from there descriptions .
this causes the page to look funny when viewing those items ....
looks like the ones messed up are missing
Code: Select all
</li>
</ul>
</div>
</div>cscart_product_descriptions
and the field that has the html descriptions is :
full_description
are there a way i can search the database for ones that are missing closing html tags and fix them ? does anyone have a script to do this ?
problem is not all the descriptions are supposed to have these ...
it would be best if there was a way to go through each description field
one at a time and check the description with a function for missing closing tags
and then add them if needed .
then update database....
any help ?