After select the employee id in the form it should display the employee name

Question

0.00/5 (No votes)

See more:

I have two tables where the first table contain the employee id, first_name, middle_name and last_name. in the second table i have employee_id and employee_name. so second table have php page hwere it shows the employee_id and employee_name tag, so if i selec the employee_id in this it must show the employee_name which was combination of first_name + middle_name + last_name from first table.I need the mysql query for this . I am beginner in this so can anyone help to me solve this issue ?

What I have tried:

to write a mysql query to shows the employee full name from another table and display in php form.

Posted 4-Jul-19 1:26am

Ajay Gupta

Updated 4-Jul-19 3:16am

Add a Solution

Comments

Richard MacCutchan 4-Jul-19 7:59am

Why are you saving the same information in two different tables?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2019-07-04T03:17:00

MySQL CONCAT_WS() Function[^]
The above MySQL function will allow you to build the result you want:

SQL

SELECT
 CONCAT_WS(" ", first_name, middle_name, last_name) AS FullName
FROM
 Table1
WHERE
 id=(some user id);

About the way to fetch and display the result in php, you just have to search for examples here on CP, or with your favorite search engine. Some examples:
php form prepared statement[^]
PHP - Code Project[^]