Perl error in line 2086 of this code:
SQL Error in query string:You have an error in your SQL syntax near 'order by position,platz' at line 1
Query:
SELECT subid,position,platz,anzahl from subnavi where typeid= order by position,platz
at /users/local/home/support//PF.pm line 2086.
1 :
2 : MsqlConnect("vwdnews");
3 : %news = MsgData($id);
4 : if($news{alias})
5 : {
6 : MsqlSelect("copytext from items where id = $news{alias}");
7 : ($news{copytext}) = MsqlFetchRow();
8 : }
9 : else
10 : {
11 : $news{alias} = $id;
12 : }
13 : # erstmal herausfinden, wo wir sind
14 : MsqlSelect("id,base,name,alias from types where base='$which'");
15 :# MsqlSelect("id,base,name,alias from types where id=$news{type}");
16 : ($typeid,$base,$name,$alias) = MsqlFetchRow();
17 : %subNavs = ();
18 : NavBarInit($typeid);
19 : $typeid = $alias if($alias);
20 :
21 : $news{copytext} = "
$news{copytext}" if($news{tabelle});22 :
23 : $navi = MkNavi($which);
