insert query example

Wed Oct 26, 2011 12:47 am

insert query example in php

Code:: function insert_user($username,$password,$firstname,$lastname,$email,$address1,$address2,$telephone,$mobile,$date_birthday,$gender,$country_code,$city,$activationkey) { $date = date("Y-m-d H:i:s"); $query =" INSERT INTO `user` VALUES (0,null,'$country_code','$username','$firstname','$lastname','$password' ,'$address1','$address2','$telephone','$mobile','$email','$city',0,'$date','$date','$date_birthday','$gender',0, '$activationkey',0)"; $result =mysql_query($query ); echo mysql_error(); return mysql_affected_rows(); }