Untitled

Column               Type          Null       Default

ID                   int(11)       No
ArtName              tinytext      No
ArtDescription       text          No
ArtistName           tinytext      No
ArtistDescription    text          No
Price                bigint(11)    No
FileName             varchar(44)   No
ImgFile              longblob      No

<?php
error_reporting(0);
$_SESSION['currentpage']="catalog.php" ;
$artist = $_REQUEST['artist'] ;
$con=mysqli_connect('localhost','SouravBasuRoy','2525','MyteraArt');
$result = mysqli_query($con,"SELECT * FROM `paintings` WHERE `ArtistName` = '$artist'");
while($row = mysqli_fetch_array($result))
{
echo "<p>Painting Name : " . $row['ArtName'] . "<br>" . "Artist Name : "  .  $row['ArtistName'] . "<br>" .  "Price : " . $row["Price"] . "</p><br>" ;
}
?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Catalog | Mytera Art</title>
<link href="styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<section class="login">
<?php
$username = $_COOKIE['username'] ;
if ($username =="")
{
echo '<form name="login" action="login.php" method="post">
<label>Login</label>
<label for="Username">Username :<input type="text" name="username"></label>
<label for="Password">Password :<input type="password" name="password"></label>
<input type="submit">
</form>' ;
}
else
{
echo '<form action="logout.php">Logged in as : ' . $_COOKIE["username"] . ' ' . '<input  type="submit" value="Logout"></form>' ;
}
?>
</section>
<header>
<h1>Mytera Art</h1>
</header>
<nav>
<ul>
<li><a href="loggedin.php">Home</a></li>
<li><a href="catalog.php">Catalog</a></li>
<li><a href="purchase.php">Purchase</a></li>
<li><a href="aboutus.php">About Us</a></li>
<li><a href="contactus.php">Contact Us</a></li>
</ul>
</nav>
<aside>
<ol>
<li><a href="catalog.php?artist=Amedeo Modigliani">Amedeo Modigliani</a></li>
<li><a href="catalog.php?artist=Claude Monet">Claude Monet</li>
<li><a href="catalog.php?artist=Edvard Munch">Edvard Munch</li>
<li><a href="catalog.php?artist=Gustav Klimt">Gustav Klimt</li>
<li><a href="catalog.php?artist=Hans Holbein">Hans Holbein</li>
<li><a href="catalog.php?artist=Kazimir Malevich">Kazimir Malevich</li>
<li><a href="catalog.php?artist=Pablo Picasso">Pablo Picasso</li>
<li><a href="catalog.php?artist=Paul Cézanne">Paul Cézanne</li>
<li><a href="catalog.php?artist=Peter Paul Rubens">Peter Paul Rubens</li>
<li><a href="catalog.php?artist=Pierre-Auguste Renoir">Pierre-Auguste Renoir</li>
<li><a href="catalog.php?artist=Pontormo">Pontormo</li>
<li><a href="catalog.php?artist=Thomas Eakins">Thomas Eakins</li>
<li><a href="catalog.php?artist=Titian">Titian</li>
<li><a href="catalog.php?artist=Vincent van Gogh">Vincent van Gogh</li>
<li><a href="catalog.php?artist=Wang Meng">Wang Meng</li>
</ol>
</aside>
<footer>
</footer>
</body>
</html>

SELECT ImgFile FROM yourtable WHERE ArtName = 'yourname'