mysql - two condition after where clauses -


i have query not working

$lokesh = "select * license_info mac_id='$mac_id' , admin_user_name='$admin'"; 

in above query selecting record macid , admin_user_name matched

but while echo sql query show output like

select * license_info mac_id='0800279020f2' , admin_user_name='sanjay ' 

last single quotes printing in below line not able retrive record. reason of printing single quotes in below line

the reason variable $admin contains newline in end. remove , there no problem this.

you will, however, have possible sql injection attack. use parameters, not inline values.


Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -