Re: newbie question

Hi, Maybe you should use the char ' in the values: ("INSERT INTO users (nick, email, pw) VALUES('$nick', '$mail', '$pw');"); You should also copy and paste the error you are getting. Bye! ---------------------------------------------- Atentamente/Best regards Rafael Mora Cel/Mob: +58-414-493.31.39 Cel/Mob: +57-321-755.37.69 Twitter @titanve On Mon, Aug 3, 2020 at 8:06 PM Fernando Fiore <no5software@gmail.com> wrote: > why this simple database operation does not work > function AddToUsersTable($mail,$nick,$pw) // $mail is an email add > { > $db = new mysqli("localhost","root","","mydb"); > > if($db){ > $mail = $db->real_escape_string($mail); > //print($mail . "</br>"); > $nick = $db->real_escape_string($nick); > $pw = $db->real_escape_string($pw); > $q = $db->query("INSERT INTO users (nick, email, pw) VALUES($nick, > $mail, $pw);"); > if($q) > return true; > else{ /* it fails here *; > print($db->error); > return false; > } > > } > else{ > print("failed to connect to db </br>"); > return false; > } > > } > // thanks in advance >