How to make a correct query with simpleSQL?

marco, Sun Nov 08 2020, 08:35AM

I use a custom login, but get errors on the following. What am I doing wrong?

$$dbq->setSQL('select * from user where user_email=:ema');
$$dbq->SetStringFieldByName('ema', $userid);
if($$dbq->simpleOpen(true)!== false) {
  $mytoken=$$dbq->getFieldByName('user_password');
  $userid=$$dbq->getFieldByName('user_id');  
  if($mytoken==$password) {  
    setSessionVar('userid', $userid);
    return true;
} }
return false;
Re: How to make a correct query with simpleSQL?
administrator, Sun Nov 08 2020, 09:29AM

Hi Marco,

Change the $$dbq->SetStringFieldByName('ema', $userid); into $$dbq->SetStringFieldByName(':ema', $userid);

That should work.