Product images:" no_picture.gif"

[Tswift42]

If you're saying that many of your products have "no_picture.gif" IN THE DATABASE as the contents of the products_image field, then you could wipe that out by running the following SQL query via phpMyAdmin:

update products set products_image='' where products_image='no_picture.gif';

Note: that '' is two single quotes...

Byte, in PhpAdmin, I do a search for no_picture.gif and I find the location of the association to products. And in this search it finds the 1200 products that have no_picture.gif.

Now when I run your script will it remove only that information where the no_picture.gif is attached to those products?

Thanks
Tom

[DrByte]

Now when I run your script will it remove only that information where the no_picture.gif is attached to those products?

That's the plan.

As always, make a backup first.

[Tswift42]

That's the plan.

As always, make a backup first.

Thanks for your help, I was able to remove all reference to no_picture.gif with your script ideas...

Thanks to everyone for the quick response

Tom