phPay / Discussion / Help 2.0 + 2.01: You have an error in your SQL syntax near ' 9

You have an error in your SQL syntax near ' 9

Forum: Help 2.0 + 2.01

Creator: Anonymous

Created: 2002-10-15

Updated: 2002-10-16

Anonymous - 2002-10-15

Was hat das zu bedeuten???

You have an error in your SQL syntax near ' 9

DANKE!!!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andreas Kansok - 2002-10-15
 
 Meine Glaskugel verrt mir, das Du von der Artikeladministration schreibst.
 
 http://sourceforge.net/forum/message.php?msg_id=1616971
 
 If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous - 2002-10-16
 
 Wo musste der Eintrag den ungefhr hin? Ich kenn mich nicht wirklich aus!
 
 ____________________________________
 <?
 echo "\n";
 if (!isset($startlimit) || $startlimit<0) {
 $startlimit=0;
 }
 if (!isset($caller) || ($caller=="main")) { $url="main.php?sess=$sess&abt=$abt&itemgr=$itemgr&startlimit="; }
 elseif ($caller=="search") {$url="search.php?sess=$sess&lookfor=$lookfor&startlimit=";}
 
 $endlimit=$startlimit+$view_limit;
 
 if (!isset($caller) || ($caller=="main")) {
 $item_result = db_query("select item.*,iteminfo.* from item,iteminfo where item.itemgrID='$itemgr' AND iteminfo.itemID=item.ID AND iteminfo.langID='$langID' AND visible='1' order by item.orderby LIMIT $startlimit, $view_limit") or db_die();
 }
 elseif ($caller=="search") {
 $item_result = db_query("select item.*,iteminfo.* from item,iteminfo where ((iteminfo.name like '%$lookfor%') OR (iteminfo.keywords like '%$lookfor%') OR (iteminfo.longdescr like '%$lookfor%')) AND iteminfo.langID='$langID' AND item.ID=iteminfo.itemID AND visible='1' order by item.orderby LIMIT $startlimit, $view_limit") or db_die();
 }
 echo "<table width=\"100%\" border=\"0\" align=\"center\" cellspacing=\"0\" cellpadding=\"2\"><tr bgcolor=\"$bgcolor3\">\n";
 if ($startlimit!=0) {
 $prevlimit = $startlimit - $view_limit;
 echo "<td align=\"left\" width=\"15%\" nowrap><a href=\"".$url."0\">|<</a></td>\n";
 echo "<td align=\"left\" width=\"15%\" nowrap>";
 if ($prevlimit > 0) {
 echo "<a href=\"".$url."$prevlimit\"><<</a>";
 }
 echo " </td>\n";
 }
 else {
 echo "<td align=\"left\" width=\"30%\"> </td>\n";
 }
 
 $slimit=$startlimit+1;
 echo "<td align=center nowrap>$limit_navi_0 $slimit - $endlimit $limit_navi_1 $num_res</td>\n";
 
 if ($endlimit<$num_res) {
 $end = $num_res-$view_limit;
 echo "<td align=right width=\"15%\"> ";
 if ($end > $endlimit) {
 echo "<a href=\"".$url."$endlimit\">>></a>";
 }
 echo " </td>\n";
 echo "<td align=\"right\" width=\"15%\" nowrap><a href=\"".$url."$end\">>|</a></td>\n";
 }
 else {
 echo "<td align=\"left\" width=\"30%\" nowrap> </td>\n";
 }
 echo "</tr>\n";
 echo "</table>\n";
 echo "\n";
 ?>
 ________________________________________
 
 Danke!
 
 Holger
 
 If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andreas Kansok - 2002-10-16
 
 Bitte poste nicht immer die ganzen Dateien, die kennen wir alle ;-)
 
 Versuche zum Beispiel gleich in der zweiten Zeile beim if noch ein || $startlimit=="" einzufgen. Das hilft auch.
 
 Ansonsten gehrt das verstekcte Formularfeld einfach in alle Forumlare von item.php und size.php. Bei manchen ist es drin, bei einem oder zweien habe ich es vergessen :-(
 
 If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

You have an error in your SQL syntax near ' 9

Forums

Help

You have an error in your SQL syntax near ' 9 document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

You have an error in your SQL syntax near ' 9