| Autor | Zpráva | ||
|---|---|---|---|
| Peter45 Profil |
#1 · Zasláno: 7. 3. 2010, 17:20:59
Podla mna je vsetko ok,tento zdrojak tak ako je mi na inom webe a db funguje,vsetko som skopiroval(zdrojaky,tabulku z DB do DB),no hadze mi to teto chyby...
Dalsiu chybu hadze ked zapisujem do DB: Table 'referencie' doesn't exist popritom tam ta tabulka je!!! Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /disk2/www/.sk/admin/referencie-list.php on line 60 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /disk2/www/.sk/admin/referencie-list.php on line 99 Zdroj: <? require("auth.php");
if ($allsearch) { $search=""; unset($_SESSION["sSearch"]); }
unset($error);
unset($message);
if (!$sAmax) $sAmax=25;
if ($search) $_SESSION["sSearch"]=$search; else $search=$_SESSION["sSearch"];
if ($rowmax) $_SESSION["sAmax"]=$rowmax;
if (!$_SESSION["asc"]) $_SESSION["asc"]=2;
if ($sort && $_SESSION["sortold"]==$sort && $_SESSION["asc"]==2) $_SESSION["asc"]=1;
elseif ($sort && $_SESSION["sortold"]==$sort && $_SESSION["asc"]==1) $_SESSION["asc"]=2;
if ($sort) $_SESSION["sortold"]=$sort;
if ($sort) $_SESSION["tovarsort"]=$sort;
if (!$_SESSION["tovarsort"]) $_SESSION["tovarsort"]="kategoria";
$table="referencie";
$editQuery.="SELECT * FROM $table WHERE id <> 0 ";
if (!$arow) $arow=0;
if ($search):
$srch = " AND ( nazov LIKE '%$search%' OR popis LIKE '%$search%' ) ";
endif;
$arowmin = $arow - $sAmax;
if ($arowmin < 0) $arowmin = 0;
$arowmax = $arow + $sAmax;
if (!$nolimit) $limiter=" LIMIT $arow,$sAmax";
$editQuery.=" $srch ";
$totalQuery=$editQuery;
$totalrows=MySQL_Num_Rows(mysql_query($totalQuery));
$editQuery.=" ORDER BY ".$_SESSION["tovarsort"];
if ($_SESSION["asc"]==1) $editQuery.= " DESC "; else $editQuery.= " ASC ";
$editQuery.= " $limiter ";
?> |
||
| Peter45 Profil |
#2 · Zasláno: 7. 3. 2010, 17:23:57
Zdrojak je len prehlad referencii...niektore scripty k tomu nepatria.Nejde mi tu editovat je daco s forom?
|
||
| Kajman_ Profil * |
#3 · Zasláno: 7. 3. 2010, 18:13:49
Vypište si sestavené dotazy a popis chyb, který vypíše mysql. viz. http://diskuse.jakpsatweb.cz/?action=vthread&forum=28&topic=37836
|
||
|
Časová prodleva: 14 let
|
|||
0