Two inputs into one DB field

Hi there

I have a form created within DA and two of the fields capture a person's first name and last name. These go into their own respective 'first_name' and 'last_name' fields in the database, but i would also like these inputs to go both together into one extra field called 'full_name', separated by a '-'. So if 'John' is entered into 'first_name' and 'Smith' entered into 'last_name' I would like 'John-Smith' to go into the 'full_name' field.
Any advice would be greatly appreciated.

Many thanks in advance
Paul

I dont see a good reason to store the information to a new field, instead of storing to a new field, you can out put the existing fields to your page to display the data in the format you wish:

<?php echo $row_recordsetName['first_name']; ?>-<?php echo $row_recordsetName['last_name']; ?>

Hi Jason, thank you for your reply.

The reason I'm collecting them together in a second field is that this is being used within the URL of the page for SEO purposes ie. 'index.php?full_name=John-Smith' and then stripping this part of the URL down to just 'John-Smith' via mod rewrite.

Many thanks
Paul

you still dont need to store it in a new column, in the sql for the recordset, you can use the CONCAT() function to create the full_name column dynamically at run time.

SELECT CONCAT(first_name, '-', last_name) AS full_name FROM users

Hi Jason, apologies for the delay in my response - been away from the mac for a few days.
Many thanks for your advice, really appreciate it. Have to admit it's not something I've done before so the route I was looking at was just the initial solution I'd thought of.

I'll give it a try and see how I get on. Many thanks again.
Kind regards
Paul