PHsPeed forum
How to make a correct query with simpleSQL?
-
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; -
Hi Marco,
Change the $$dbq->SetStringFieldByName('ema', $userid); into $$dbq->SetStringFieldByName(':ema', $userid);
That should work.
