This topic is locked

dbconnection error 256

7/21/2005 11:33:33 AM
PHPRunner General questions
bobvance author

Hi Sergey. Began developing my second PHPrunner app - when I log on as admin, works fine. When I log on as a user, get this error message:
Error type 256

Error description You have an error in your SQL syntax near 'lastname' at line 1

URL www.febg.com/cgi-bin/php

Error file /m1/allan76/tracker/include/dbconnection.php

Error line 26

SQL query select `cid`, `assigned_rep`, `lastname`, `firstname`, `city`, `mailed_date`, `compliance_officer`, `del_date`, `del_meth`, `gdc`, `prod_type`, `prod_comp`, `rep_notes` From `febg_client` where `assigned_rep`='Donald Moore' lastname
Looks like it is putting 'lastname' in the wrong place in the SQL - but I looked in dbconnection.php and cannot figure out where to fix this.
Thanks!

500303 7/21/2005

Nevermind - I got it!