Hladat PHP

<?php
require("db.php");
require("header.php");
$search = $_POST['search'];

$result = "SELECT id, cat_id, name, description, long_description, image, price, FROM products WHERE name LIKE '$search' OR description LIKE '$search' OR long_description LIKE '$search' ";
$prodcatres = mysql_query($result);

while($prodrow = mysql_fetch_assoc($prodcatres))
{
echo "<div id='product'>";
echo "<a href='product.php?id=". $prodrow['id'] . "'><h3>" . $prodrow['name'] . "</h3></a>";
if(empty($prodrow['image'])) {
echo "<center><img
src='./productimages/no_image.jpg' width='100px' height='100px'  alt='"
. $prodrow['name'] . "'></center>";
}
else {
echo "<center><img src='./productimages/" . $prodrow['image']
. "' width='100px' height='100px' alt='"
. $prodrow['name'] . "'></center>";
}
echo "<p>"  . $prodrow['description'] . " ...";
echo "<p><strong><span>PRICE&nbsp;:&nbsp;</span>&pound;"
. sprintf('%.2f', $prodrow['price']) . "</strong>";
echo "<a href='addtobasket.php?id="
. $prodrow['id'] . "'><span style='float:right;font-size:14px;font-weight:bold;text-decoration:none;'>BUY</span></a></p>";
echo "</div>";
}
require("footer.php");
?>

<?php
require("db.php");
require("header.php");
$search = $_POST['search'];

$result = "SELECT id, cat_id, name, description, long_description, image, price
           FROM products
           WHERE name LIKE '%$search%'
           OR description LIKE '%$search%'
           OR long_description LIKE '%$search%' ";
$prodcatres = mysql_query($result);
// echneme pre istotu error
echo mysql_error();

if(mysql_num_rows($prodcatres)>0) {
  while($prodrow = mysql_fetch_assoc($prodcatres))
  {
    echo "<div id='product'>";
    echo "<a href='product.php?id=". $prodrow['id'] . "'><h3>" . $prodrow['name'] . "</h3></a>";
    if(empty($prodrow['image'])) {
    echo "<center><img
    src='./productimages/no_image.jpg' width='100px' height='100px'  alt='"
    . $prodrow['name'] . "'></center>";
    }
    else {
    echo "<center><img src='./productimages/" . $prodrow['image']
    . "' width='100px' height='100px' alt='"
    . $prodrow['name'] . "'></center>";
    }
    echo "<p>"  . $prodrow['description'] . " ...";
    echo "<p><strong><span>PRICE&nbsp;:&nbsp;</span>&pound;"
    . sprintf('%.2f', $prodrow['price']) . "</strong>";
    echo "<a href='addtobasket.php?id="
    . $prodrow['id'] . "'><span style='float:right;font-size:14px;font-weight:bold;text-decoration:none;'>BUY</span></a></p>";
    echo "</div>";
  }
} else {
  echo "Nic som nenasiel";
}
require("footer.php");
?>