Check two table value in php mysql query

Question

I have two tables.

Customer :

id | custname | phone
---------------------
1  | abc      | 123
2  | xyz      | 456
3  | qwe      | 786
4  | asd      | 1234

Register :

id | regname  | status  |Desc
-----------------------------------
1  | abc      | 1       | text here
2  | cvw      | 0       | text here
3  | fgr      | 1       | text here
4  | asd      | 0       | text here

cust matches in regname : abc and asd

Then I want out put matches custnname for customer and register table details.

id | custname | status  |Desc
-----------------------------------
1  | abc      | 1       | text here
2  | asd      | 0       | text here

How to do it with PHP MySQL query?

Hamza Zafeer · Accepted Answer · 2018-03-13 13:21:11Z

3

Try this query with join:

"SELECT customer.custname,register.status,register.Desc 
 FROM customer 
 JOIN register ON register.regname = customer.custname"

edited Mar 13, 2018 at 13:21

Hamza Zafeer

2,45613 gold badges36 silver badges48 bronze badges

answered Mar 13, 2018 at 12:54

vikalp

3302 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jameson the dog · Accepted Answer · 2018-03-13 12:55:12Z

1

this is a simple JOIN between the 2 tables so what you want is:

SELECT customer.id,customer.custname,register.status,register.desc
FROM customer
JOIN register ON register.regname = customer.custname

since we use JOIN it acts as an inner join and will only return values that match it

for more on mysql join look here:https://dev.mysql.com/doc/refman/5.7/en/join.html

answered Mar 13, 2018 at 12:55

Jameson the dog

1,8061 gold badge12 silver badges13 bronze badges

Comments

Syscall · Accepted Answer · 2018-03-13 12:59:29Z

1

You could use INNER JOIN to keep all values that are inside customers and registers:

select c.id, c.custname, r.status, r.Desc
from customers c
inner join register r on r.regname = c.custname

Will outputs:

id | custname | status  |Desc
-----------------------------------
1  | abc      | 1       | text here
4  | asd      | 0       | text here

NB: not sure about which ID you want. You could use c.id or r.id.

edited Mar 13, 2018 at 12:59

answered Mar 13, 2018 at 12:54

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

Comments

Harsh Barach · Accepted Answer · 2018-03-13 13:59:31Z

0

You can try below code.

SELECT c.id as ID,c.custname as Customer Name,r.status as Status,r.desc as Description
FROM customer as c
INNER JOIN register as r
ON r.regname = c.custname

answered Mar 13, 2018 at 13:59

Harsh Barach

9559 silver badges18 bronze badges

Collectives™ on Stack Overflow

Check two table value in php mysql query

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related