Moderators mark1million Posted December 27, 2009 Moderators Report Posted December 27, 2009 Hi everyone, when a user registers i have an insert statement taken from the create forum account that inserts a users ID and name in to my teamspeak db, what i currently have is this, // Insert a row of information into the table "ts2_clients " mysql_query("INSERT INTO ts2_clients (i_client_id, i_client_server_id, b_client_privilege_serveradmin, s_client_name, s_client_password, dt_client_created, dt_client_lastonline) VALUES('0', '1', '0', '".$code.$fname."', '".$pass."', '', '' ) ") So this inserts in to my teamspeak db Pilot ID and First name like this ABC0001Mark, what i am trying to do is put a space in between the id and the name so it inserts like this, ABC0001 Mark Im no coder and have been hunting about with no luck, google who normally is my best friend yields no results, any suggestions would be gratefully received. Thanks. Quote
Administrators Nabeel Posted December 27, 2009 Administrators Report Posted December 27, 2009 Try '".$code.' '.$fname."' The . is a concatentation, so you can concat any string in there, including a string with just a space Quote
Moderators mark1million Posted December 27, 2009 Author Moderators Report Posted December 27, 2009 Fantastic!!!! Thank you Nabeel. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.