title: Unable to insert data into mysql using sprintf
body: <p>I'm unable to find where  I made mistake here: I could not insert data into the database when I use <code>sprintf</code> for this particular query while others can!
  Is Data type for now() and 0 value correct below?</p>
  
  <pre><code>$query2=sprintf("INSERT INTO usrinfo (UUID,Name,Phone,Email,Postcode,DateReg,Reputation,ReviewPlus,ReviewNeg,Sex,Status,ContactPermissions)VALUES('%s','%s','%s','%s','%s','%s','%u','%u','%u','%s','%u','%u')",$unique_id,$name,$phone,$email,$postcode,now(),0,0,0,$gender,0,$permission);
   $insert2=mysqli_query($conn,$query2)or die(mysqli_error($conn))
  </code></pre>
  
  <p>But when I don't use sprintf, it works! Below is the query without <code>sprintf</code></p>
  
  <pre><code>$query2="INSERT INTO usrinfo (UUID,Name,Phone,Email,Postcode,DateReg,Reputation,ReviewPlus,ReviewNeg,Sex,Status,ContactPermissions) VALUES('$unique_id','$name','$phone','$email','$postcode',now(),'0','0','0','$gender','0','$permission')";
  </code></pre>