Как да оправя този код

sianbg2

Registered
Код:
<?
include ("config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error()); 
$num = mysql_num_rows($select); 
$cat = secure($_GET['cat']);
$vid = secure($_GET['vid']);
$sql = mysql_query("SELECT * FROM news WHERE cat='$cat'");
$sql2 = mysql_query("SELECT * FROM news WHERE cat='$vid'");
$fail = "files/$file"; 
$size = filesize($fail); 
while($r = mysql_fetch_assoc($sql)($sql2)){
echo '
rezultati
 ';
}

?>
В този ред ми е грешката,но как да я оправя.
Код:
while($r = mysql_fetch_assoc($sql)($sql2)){

Искам при изкарване на резултати да се пиши в браузера news.php?cat=kategoriq?vid=vida или нещо такова :D
 
sianbg2 каза:
Код:
<?
include ("config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error()); 
$num = mysql_num_rows($select); 
$cat = secure($_GET['cat']);
$vid = secure($_GET['vid']);
$sql = mysql_query("SELECT * FROM news WHERE cat='$cat'  AND cat='$vid'");
$fail = "files/$file"; 
$size = filesize($fail); 
while($r = mysql_fetch_assoc($sql)){
echo '
rezultati
 ';
}

?>
 
lam3r4370 каза:
Код:
<?
include ("config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error()); 
$num = mysql_num_rows($select); 
$cat = secure($_GET['cat']);
$vid = secure($_GET['vid']);
$sql = mysql_query("SELECT * FROM news WHERE cat='$cat'  AND cat='$vid'");
$fail = "files/$file"; 
$size = filesize($fail); 
while($r = mysql_fetch_assoc($sql)){
echo '
rezultati
 ';
}

?>
Не изкарва никакви резултати дори когато напиша само news.php?cat=kategoriq
 
<?
include ("config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error());
$num = mysql_num_rows($select);
$cat = secure($_GET['cat']);
$vid = secure($_GET['vid']);
$sql = mysql_query("SELECT * FROM news WHERE cat='$cat' AND vid='$vid'") or die(mysql_error());
$fail = "files/$file";
$size = filesize($fail);
while($r = mysql_fetch_assoc($sql)){
echo '
rezultati
';
}

?>
 
sianbg2 каза:
Код:
<?
include ("config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error()); 
$num = mysql_num_rows($select); 
$cat = secure($_GET['cat']);
$vid = secure($_GET['vid']);
$sql = mysql_query("SELECT * FROM news WHERE cat='$cat'");
$sql2 = mysql_query("SELECT * FROM news WHERE cat='$vid'");
$fail = "files/$file"; 
$size = filesize($fail); 
while($r = mysql_fetch_assoc($sql) || $row= mysql_fetch_assoc($sql2)){
echo '
rezultati
 ';
}

?>
?
 

Back
Горе