Toate

Cautare:

if(isset($_POST['category']))
{
$catValue = $_POST['category'];
}

$search = $_POST['search'];

$catQuery = "SELECT * FROM cats ORDER BY ID";
$catResult = mysql_query($catQuery);
$catCount = mysql_num_rows($catResult);
?>

$bookQuery = "SELECT * FROM info WHERE (title LIKE '%" . $search . "%'";
$bookQuery = $bookQuery . " OR author LIKE '%" . $search . "%'";
$bookQuery = $bookQuery . " OR publisher LIKE '%" . $search . "%')";

if($catValue != 0 )
{
$bookQuery = $bookQuery . " AND category=" . $catValue;
}

/*if($search != "")
{
if($catValue!=0)
$bookQuery = $bookQuery . " title LIKE %" . $search
*/
$bookQuery = $bookQuery . " ORDER BY title";
$bookResult = mysql_query($bookQuery);
$bookCount = mysql_num_rows($bookResult);

echo '

‘;
echo ‘
‘;
echo ‘

‘;
echo ‘

‘;

for($i = 1; $i <= $bookCount; $i++) {
echo '

‘;
$row = mysql_fetch_array($bookResult, MYSQL_ASSOC);
$catQuery = ‘SELECT nume FROM cats WHERE ID=’ . $row['category'];
$catResult = mysql_query($catQuery);
$catName = mysql_fetch_array($catResult, MYSQL_ASSOC);
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
?>

Titlu	Autor	Editura	An	Pagini	ISBN	Categorie
‘. $row['title'] .’	‘. $row['author'] .’	‘. $row['publisher'] .’	‘. $row['year'] .’	‘. $row['pages'] .’	‘. $row['ISBN'] .’	‘. $catName['nume'] .’