I'm working on login script. User user their unique numeric ID as username. Some have those IDs starting with 0 or 00 and some have no zeros at all.
I need to be able to process it regardless whether they enter initial zeros in login form or not. I can strip zeros from input like this:
$uID= ltrim($_POST['id_from_form'], "0");
but how do I strip those zeros from db query because it takes it literally?
SELECT * FROM users WHERE uid='".$uID."'