Re: Insert using connector j?
I'm getting another error relating to the SQL syntax, it claims that this is wrong:
(ID,email,password,name,call,phone_number) VALUES ('"+ user[0] +"','"+ user[1] +"','"+ user[2] +"','"+ user[3] +"','"+ user[4] +"','"+ user[5] +"')");
but the same code works like this:
(ID,email,password,name) VALUES ('"+ user[0] +"','"+ user[1] +"','"+ user[2] +"','"+ user[3] +"')");
it's no different other than I added 2 more vaues in the exact same way :S
also,System.out.println(user[0]+user[1]+user[2]+user[3]+user[4]+user[5]);
results in
77 test.test.com a94a8fe5ccb19ba61c4c0873d391e987982fbbd3 testname yes 7095555555
as it should