I made these games a few months back when I first learned processing. There are some obvious little bugs, and it they were some of the first applications I'd ever really written, but I figured I'd share them just to get some input.
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 'AND `showinmenu` != 0
ORDER BY `shortname` asc' at line 4
SELECT `shortname`, `name`
FROM (`games`)
WHERE `shortname` !=
AND `showinmenu` != 0
ORDER BY `shortname` asc
Yes, you need to put quotes around the shortname argument: WHERE `shortname` != ''
AND `showinmenu` != 0 Perhaps the argument is dynamic and thus, when empty, disappears, but quotes are necessary in all cases.
Leave a comment on PhiLho's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic