raiseError( 101, mysql_error(), __LINE__, __FUNCTION__, __CLASS__, __FILE__ ); $row = mysql_fetch_assoc( $result ); foreach ( $row as $key => $value ) { ${$key} = htmlspecialchars( $value ); } include( "header.php" ); //check for specials $res = $SQLAuth->Query( "SELECT COUNT(DISTINCT p.`product_id`) FROM `catalog_products` p, `catalog_product_sku` s WHERE p.`product_id` = s.`product_id` AND ( (s.`sale_price` IS NOT NULL AND s.`sale_price` > 0) OR (s.`vet_sale_price` IS NOT NULL AND s.`vet_sale_price` > 0) ) " . ( ( $catalog->_CATALOG['track_inventory'] === true && $catalog->_CATALOG['show_prod_no_inventory'] === true ) ? "AND s.`inventory` > 0 AND s.`inventory` IS NOT NULL " : "" ) . ( ( $catalog->_CATALOG['show_prod_unavailable'] !== true ) ? "AND p.`status` <> 'Unavailable' " : "" ) . ( ( $catalog->_CATALOG['show_prod_out_stock'] !== true ) ? "AND p.`status` <> 'Out Of Stock' " : "" ) . "AND p.`is_active` = 'Yes' AND (p.`date_available` <= CURDATE() OR p.`date_available` IS NULL OR p.`date_available` = '') AND (p.`date_expire` > CURDATE() OR p.`date_expire` IS NULL OR p.`date_expire` = '') ORDER BY p.name ASC" ); list( $num_sale ) = mysql_fetch_row( $res ); ?>

Equine

Rood and Riddle Veterinary Pharmacy offers a full line of equine compounds, prescription medications and over-the-counter products. Whether it's breeding and foaling supplies or podiatry products, RRVP has it covered.

Small Animals

Equally as extensive, Rood and Riddle Veterinary Pharmacy offers a full line of products dedicated to companion animals. By providing superior flavor selections and convenient methods of delivery, RRVP meets the unique needs of these animals.