Adding Buy Now Button

[mw4kids]

Hi All,

Wondering if someone can help me out. I would like to add 'Buy Now' button to all my products instead of showing Qty box. I have over 900 products, so going back and changing each individual product 'No, Don't show Qty Box' would take days. I read in another thread someone suggested this:

if you have large number of products , you may use SQL query to set them all to not show quantity box in product info ,

for that , i would ask Gurus in here to give you sql code to do this

Anyone know I can do this?

Also, I really like how this site , http://www.bigdepot.co.uk/blank-medi...3690_3697.html , has their Shopping Cart set up, so the customer see's the cart displayed and the same page as the product listing page and can continue shopping without page being redirected to shopping cart. Anyone, know i can implement this on my site?

Thanks!

[mw4kids]

Figured out Part 2 of my question- Still looking to find out how to do Part 1.

By the way, If anybody is interested i just did the following:

in 'My Store' under 'Display Cart After Adding Product' I just set it to 'False'

Then i may sure my Shopping Cart Sidebox was on in my 'Layout Boxes Controller'

Thanks!