Parašė ZW· 2011 Lap. 16 15:11:45
#7
gintulis parašė:
Dabar toki erorą gaunu:
Notice: Undefined index: rowstart in /home/webdizaina/domains/xxxxxx/public_html/dle_dizainai.php on line 33
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 5
Kad tu imestum visa failo koda... Mums butu aiskiau... ;)
Nes man atrodo neteisingai iterpi... ne ten kur reikia...
Stai visa koda istraukiau...
<?php
$items_per_page = 12;
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) {
$_GET['rowstart'] = 0;
}
$rows = dbcount("(*)", DB_NEWS," news_draft='0' AND news_cat=25");
//opentable("");
//$result = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC LIMIT 0,4");
$result = dbquery(
"SELECT * FROM ".DB_NEWS."
WHERE news_draft='0' AND news_cat=25 ORDER BY news_datestamp DESC
LIMIT ".$_GET['rowstart'].", $items_per_page"
);
Redagavo ZW· 2011 Lap. 16 15:11:07