Fireche The username, password and database names will of course be changed once i figure it out hahaha <img src="{SMILIES_PATH}/icon_e_wink.gif" alt=";)" title="Wink"> And there will not be anything worthwhile on there anyway. It is going to be a map for a volunteer group of people that pick litter. Interesting for hackers aye <img src="{SMILIES_PATH}/icon_e_wink.gif" alt=";)" title="Wink"> What is PDO however?
lennaert
Nowadays you should use PDO instead of mysqli or mysql: http://php.net/manual/en/mysqlinfo.api.choosing.php It's more safe and it's the future <img src="{SMILIES_PATH}/icon_razz.gif" alt=":P" title="Razz"> Also never put SQL-Statements into your query. You will get hacked easily <img src="{SMILIES_PATH}/icon_e_wink.gif" alt=";)" title="Wink">
You wrote in MYSQLI:
$stmt = $con -> prepare("SELECT id FROM members where username='$username' and password='$password'")
In PDO:
$stmt = $con -> prepare("SELECT id FROM members where username = :username and password = :password")