Database Error

[kevin922 0]

Go to list all the users then click on a colum (user id, name, country) get the error:

CGI ERROR
==========================================
Error Message : Unable to query database. Reason: You have an error in your SQL syntax near 'ascend
LIMIT 0, 30
' at line 5. Query:
SELECT ID,FirstName,LastName,NickName,Region,Country,Address,City,State,ZIPcode,Phone,Fax,Email,ICQ,Website,URL,Dropzone,License,Number,Jumps,SL,AFF,IAD,Tandem,Pro,Org,Back,Chest,Seat,Lap,Rig,Main,Mainsize,Res,Ressize,AAD,Rigother,Mainother,Resother,AADother,Firstchoice,Secondchoice,Photo,Date,Userid,Modified,Category FROM Skydivers
WHERE
Userid LIKE '%'
ORDER BY 1 ascend
LIMIT 0, 30

Script Location : db.cgi
Perl Version : 5.006001
Setup File : db.cfg
User ID : 1041718160128711

Form Variables
-------------------------------------------
Userid : *
db : db
sb : 1
so : ascend
uid : 1041718160128711
view_records : 1

Environment Variables
-------------------------------------------
DOCUMENT_ROOT : /home/dropzone/dropzone.com/www
GATEWAY_INTERFACE : CGI/1.1
HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-us
HTTP_CONNECTION : Keep-Alive
HTTP_COOKIE : i1=22:42:94:1041706488:245|9:14:94:1041706483:245|19:36:3:1041706905:243|45:97:3:1041706845:243||||||||||||||||||||||||||||||||; sid=1041718160128711; Username=kevin922; cookie=set; Password=wwwusr; gforum_1022870964_session=755d573745489b7340aae45e8f08974b
HTTP_HOST : www.dropzone.com
HTTP_REFERER : http://www.dropzone.com/cgi-bin/skydivers/db.cgi?db=db&view_records=1&Userid=*
HTTP_USER_AGENT : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Hotbar 4.1.8.0)
PATH : /usr/local/ghost/bin:/usr/local/bin:/usr/bin:/bin
QUERY_STRING : db=db&sb=1&so=ascend&uid=default&view_records=1&Userid=*
REDIRECT_QUERY_STRING: db=db&sb=1&so=ascend&uid=default&view_records=1&Userid=*
REDIRECT_STATUS : 200
REDIRECT_URL : /cgi-bin/skydivers/db.cgi
REMOTE_ADDR : 68.98.162.136
REMOTE_PORT : 64987
REQUEST_METHOD : GET
REQUEST_URI : /cgi-bin/skydivers/db.cgi?db=db&sb=1&so=ascend&uid=default&view_records=1&Userid=*
SCRIPT_FILENAME : /home/dropzone/dropzone.com/cgi-bin/skydivers/db.cgi
SCRIPT_NAME : /cgi-bin/skydivers/db.cgi
SERVER_ADDR : 64.69.64.39
SERVER_ADMIN : root@localhost
SERVER_NAME : www.dropzone.com
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.1
SERVER_SOFTWARE : Apache

[narcimund 0]

looks like the:

ORDER BY 1 ascend

is missing a "$". Should be:

ORDER BY $1 ascend

First Class Citizen Twice Over

[sangiro 4]

Fixed. Field reference was wrong and changed so=ascend to so=asc.

Safe swoops
Sangiro

[narcimund 0]

Nice.

First Class Citizen Twice Over