Kod
if($_GET['article_id'])
{
$data = dbarray(dbquery("SELECT article_cat FROM ".$db_prefix."articles WHERE article_id=".$_GET['article_id'].""));
opentable("Artykuly");
$rows = dbcount("(article_id)", "articles", "article_cat=".$data['article_cat']."");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat=".$data['article_cat']." ORDER BY ".$cdata['article_cat_sorting']."");
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['article_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " <span class='small'>[".$locale['402']."]</span>";
} else {
$new = "";
}
echo "<a href='".seoname($data['article_subject'])."-r".$data['article_id'].".htm'>
".$data['article_subject']."</a>$new<br>\n".stripslashes($data['article_snippet']);
echo ($i != $numrows ? "<br><br>\n" : "\n"); $i++;
}
closetable();
}
}
{
$data = dbarray(dbquery("SELECT article_cat FROM ".$db_prefix."articles WHERE article_id=".$_GET['article_id'].""));
opentable("Artykuly");
$rows = dbcount("(article_id)", "articles", "article_cat=".$data['article_cat']."");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".$db_prefix."articles WHERE article_cat=".$data['article_cat']." ORDER BY ".$cdata['article_cat_sorting']."");
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
if ($data['article_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " <span class='small'>[".$locale['402']."]</span>";
} else {
$new = "";
}
echo "<a href='".seoname($data['article_subject'])."-r".$data['article_id'].".htm'>
".$data['article_subject']."</a>$new<br>\n".stripslashes($data['article_snippet']);
echo ($i != $numrows ? "<br><br>\n" : "\n"); $i++;
}
closetable();
}
}
Po wstawieniu w/w kodu dostaje niemiłą odpowiedź:
Cytat
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 '' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Kombinowałem z tym cudzysłowem bardzo, ale poddaje się, mógłby ktoś pomóc?
