<?php

                                $host="localhost";
                            $username="root";
                            $password="";
                            $db_name="ge";

                            $con=mysqli_connect("$host", "$username", "$password","$db_name")or die("Your Connection is in error");




                            $sql="SELECT pname,catogery,email FROM quetation WHERE catogery = '$catogery'";

                            $results=mysqli_query($con,$sql);

                            $count=mysqli_num_rows($results);
                            if($count == 0)
                            {
                                    echo "<font color="#0000"><h1 align="center">No details found</h1></font>";
                            }
                            else
                            {
                               $resource=mysqli_query($con,$sql);
                               echo "<font color="#000000">
                                      <h2 align="center"></h2>

                                    <table align="center" border="1" width="50%">
                                    <tr>
                                    <td><b>ProdName</b></td>
                                    <td><b>Catogery</b></td>
                                    <td><b>Price</b></td>

        </tr> ";

                            while($result=mysqli_fetch_array($resource))
                                {
                                echo "

                                    <div class="row">
                            <div class="input-field col s12">
<tr>
                                <td>".$result[0]."</td>
                                <td>".$result[1]."</td>
                            <td><form name="abc" methos="post" action="postprice.php">

                         <input type="submit" value="send"> </td>
                            </form>




                            </div>

                        </div>

                                </tr>";
                                }echo "</table></font>";
                                }


?>