Anns Gift Shop Logo

www.AnnsCardsAndGifts.com Anaheim,  California
Tel (714) 900-2760

Product Search

Use keyword(s) or stocknumber
Shopping Cart Image View Shopping Cart
 Items:  0
 Total:  $0.00
Secure Checkout
Browse DVDs & Videos
  This Month's Featured DVDs
  Hallmark Hall of Fame Movies
  Hallmark Channel DVDs
  Christmas / Holiday DVDs
  Action Adventure DVDs
  Animation DVDs
  Biography DVDs
  Children's DVDs
  Classical Music DVDs
  Comedy DVDs
  Documentary DVDs
  Drama DVDs
  Elvis DVDs
  Exercise DVDs
  Family DVDs
  Foreign DVDs
  Gospel DVDs
  History DVDs
  Horror DVDs
  Instructional DVDs
  Japanimation / Anime DVDs
  Martial Arts DVDs
  Music & Concert DVDs
  Musicals
  Mystery DVDs
  Performing Arts DVDs
  Religious DVDs
  Romance DVDs
  Science Fiction DVDs
  Special Interest DVDs
  Sports DVDs
  Suspense/Thriller DVDs
  TV Show DVDs
  Urban DVDs
  War DVDs
  Western DVDs
Customer Service
  Contact Us
  Frequent Questions
  Refunds & Returns
  Terms & Conditions
  Return to Main Page

Action and Adventure DVDs

   DVDs, photo albums, collectibles, and much more...

Warning: mysql_query() [function.mysql-query]: Unable to save result set in F:\websites\annshallmarkdev\lib\dblib.php on line 78

Can't execute query

 SELECT distinct p.id, p.name, p.description, p.url, p.quantity, p.price, p.regprice, round(100* (1 - (p.price/p.regprice)), 0) as discount,
            p.stocknumber, p.on_special, p.image_path, p.tiny_image_path, p.genre, p.rating, p.street_date, p.studio, p.product_type
            FROM products p
            WHERE    p.genre in ('ACTION', 'ADVENTURE', 'ACTION ADVENTURE')  and p.item_available = 1  order by name asc  LIMIT 80, 20 

MySQL Error: Got error 134 from storage engine

This script cannot continue, terminating.