<?php

       $prodCode = "";
       $hiresLink = "";
       $thumbLink = "";
       $description = "";
       $price = "";

         $host = "mysql.gkpatherjewellers.co.za"; // Host name.
         $db_user = "gkpather"; // MySQL username.
         $db_password = "gkpath8185"; // MySQL password.
         $database = "jewellery"; // Database name.
            mysql_connect($host,$db_user,$db_password);
            mysql_select_db($database);


    if (isset($S_POST['Rings']))
        {

         $result = mysql_query("SELECT * FROM products WHERE category='ring'");

         $row=mysql_fetch_array($result);

                   $hiresLink   = $row['hires_link'];
                   $thumbLink   = $row['thumb_link'];
                   $description = $row['description'];
                   $price       = $row['price'];


        }

?>