I have built a database to store information about wireless cusotmers we have, it all work fine until i click one of the links and get this error:
PHP error happened
Technical information
Error type 256
Error description You have an error in your SQL syntax near 'ec_name' at line 1
URL www.sutv.com/pages/wireless/equipment_list.phpmasterkey=EC001_LR
Error file /usr/local/www/data.default/pages/wireless/include/dbconnection.php
Error line 26
SQL query select `ec_name`, `ec_type`, `ec_user`, `ec_ropass`, `ec_rwpass`, `ec_mac`, `ec_serial`, `ec_ip`, `ec_comments`, `ec_pur_date`, `ec_volt`, `ec_image` From `equipment` where `ec_name`='EC001_LR' ec_name
the last part of the statement seems wrong where it says:
where `ec_name`='EC001_LR' ec_name
Why does it have the field ec_name at the end there..
if that is the problem what can i do to fix it?
thank you
p.s. if you need more information please let me know i would be happy to provide it.
