php db编程

Question

how to insert multiple values in single row of database using php? For example the table contains name,email,address line1,address line2,note. The Database table contains name,email,address,note. i.e for a single user address line 1,address line 2 should come under address .Please help me find out

Answer 1

You can concate address one and address two like this

$address=$addressline1.$addressline2;
$q="insert into table (name,email,address,note) values($name,$email,$address,$note)";