Проблем с php кода

[smoke]

Ето кода:

<?php include("header.php"); ?>
<?php
$conn = mysql_connect("localhost", "s46t4e0n_video", "qweasdzxc");
mysql_select_db("s46t4e0n_video", $conn);
$sql = mysql_query("SELECT count(*) as broi from clips");
$pesni = mysql_fetch_array($sql);
echo " Îáùî êëèïîâå: <b>$pesni[broi]</b> ";
?>
<br /><br /><br />
<?php


mysql_connect("localhost","s46t4e0n_video","qweasdzxc") or die (mysql_error());
mysql_select_db("s46t4e0n_video") or die (mysql_error());
mysql_query("SET NAMES cp1251");

//Èçêàðâàíå íà êàòåãîðèèòå îò áàçàòà äàííè

$select_cats = mysql_query("SELECT * FROM `cats` ORDER BY `id` DESC") or die (mysql_error());
while($row = mysql_fetch_array($select_cats)) {
echo " <a href='?category=".$row['value']."'>".$row['name']."</a> | ";
}

echo "<br /><br />";

//Èçêàðâàíå íà âèäåà îò áàçàòà äàííè
$cats = $_GET['category'];

if($_GET['category']) {
$vr = mysql_query("SELECT COUNT(*) as cnt FROM `clips` WHERE `category` = '$cats' && `active` == '1'");
} else {
$vr = mysql_query("SELECT COUNT(*) as cnt FROM `clips` WHERE `active` == '1'");
}

$row = mysql_fetch_array($vr);
$max_count = $row['cnt'];
$limit = 5; //Áðîÿ íà âèäåà êîèòî èñêàø äà ñå ïîêàçâàò íà ñòðàíèöà
if((int)$_GET['page'] > 0) {
    $page = (int)$_GET['page'];
} else {
    $page = 0;
}
$max_page = ceil($max_count/$limit);

if($_GET['category']) {
$vr = mysql_query("SELECT * FROM `clips` WHERE `category` = '$cats' && `active` == '1' ORDER BY `id` DESC LIMIT ".($limit*$page).",".$limit);
} else {
$vr = mysql_query("SELECT * FROM `clips` WHERE `active` == '1' ORDER BY `id` DESC LIMIT ".($limit*$page).",".$limit);
}

$broy_redove = mysql_num_rows($vr);
while($vr_row = mysql_fetch_assoc($vr)) {
    $view_video = "<table border='2'><td><a href='view.php?id=".$vr_row['id']."'><img src='".$vr_row['pic']."' width='120' height='90' alt='".$vr_row['pic']."' /></a></td><td width='300'><center>
    ".$vr_row['ime']." </center></td></table>";

    echo $view_video;
}

if($broy_redove == 0) {
echo "Â òàçè êàòåãîðèÿ âñå îùå íÿìà äîáàâåíè âèäåà, ìîëÿ ïðîâåðåòå ïî-êúñíî.";
}

for($i=0;$i<$max_page;$i++) {
    echo "<a href='video.php?category=".$cats."&&page=".$i."'>".($i + 1)."</a> | ";
}

?>
<?php include("footer.php"); ?>

Вижте какви грешки дава:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/s46t4e0n/public_html/video/video.php on line 35

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/s46t4e0n/public_html/video/video.php on line 51

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/s46t4e0n/public_html/video/video.php on line 52

 

[Anonymous]

Имаш грешка в SQL заявката/заявките.
Добави по един or die(mysql_error() и виж какви са

if($_GET['category']) {
$vr = mysql_query("SELECT * FROM `clips` WHERE `category` = '$cats' && `active` == '1' ORDER BY `id` DESC LIMIT ".($limit*$page).",".$limit)or die(mysql_error());
} else {
$vr = mysql_query("SELECT * FROM `clips` WHERE `active` == '1' ORDER BY `id` DESC LIMIT ".($limit*$page).",".$limit)or die(mysql_error());
}