how to deal with .com in SQL query? |
I am building this string to use in a query.
$where= $where="email=".$this->session->userdata('userid')." AND campaign=".$this->session->userdata('campaign'); In my example this correctly becomes: "[email protected] AND campaign=Apple" But when I try running the following line $crud->set_relation('bus_comp','business_components','bus_comp',$where); I get an error: SELECT COUNT(*) AS `numrows` FROM `business_components` WHERE `email` = `richb201@gmail`.`com` AND `campaign` = `Apple` How do I stop the "." in the email address from being taken as just a "."?
proof that an old dog can learn new tricks
|
Messages In This Thread |
how to deal with .com in SQL query? - by richb201 - 09-10-2020, 04:15 AM
RE: how to deal with .com in SQL query? - by Omar Crespo - 09-10-2020, 04:50 AM
RE: how to deal with .com in SQL query? - by richb201 - 09-10-2020, 05:05 AM
RE: how to deal with .com in SQL query? - by Omar Crespo - 09-10-2020, 05:20 AM
RE: how to deal with .com in SQL query? - by richb201 - 09-10-2020, 09:19 AM
RE: how to deal with .com in SQL query? - by Omar Crespo - 09-10-2020, 10:34 AM
RE: how to deal with .com in SQL query? - by InsiteFX - 09-10-2020, 12:00 PM
|