Counting job applied person

Question

There are 3 tables:

1.users (id_user, name)
2.job_post (id_post,id_company,jobtitle)
3.apply_job_post(id_apply, id_post,id_user)

how to count particular job applied person - any one can help me

SELECT * FROM job_post INNER JOIN apply_job_post ON job_post.id_jobpost=apply_job_post.id_jobpost INNER JOIN users ON users.id_user=apply_job_post.id_user WHERE apply_job_post.id_company='2' AND id_apply='2' — Selvam Deepak, Mar 13 '19 at 11:55
only one person name will be displayed... any one can help me — Selvam Deepak, Mar 13 '19 at 11:56

score 0 · Answer 1 · answered Mar 12 '19 at 06:32

0

You need count and group them

select id_user,count(id_post) from users
left join apply_job_post on apply_job_post.id_user = users.id_user
left join job_post on apply_job_post.id_post = job_post.id_post
group by users.id_user

answered Mar 12 '19 at 06:32

Bai Nguyen

814
7
16

Notice: Trying to get property of non-object – Selvam Deepak Mar 12 '19 at 06:42

score -1 · Answer 2 · edited Mar 13 '19 at 07:35

-1

If you want to fetch the count of users get assigned a particular job then use the following query:

SELECT
    count(u.id_user)
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user
where JP.id_post=2

If you want to fetch how many jobs assigned to one particular user then you can use the following query:

The following example shows how many jobs assigned to id_user=1

SELECT
    count(u.id_user)
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user
where u.id_user=1

If you want to fetch whole data from three tables then:

SELECT
    U.*,
    JP.*,
    AJP.*
FROM apply_job_post AJP
LEFT JOIN job_post JP ON JP.id_post=AJP.id_post
LEFT JOIN users U ON AJP.id_user=U.id_user

edited Mar 13 '19 at 07:35

piet.t

11,718
21
43
52

answered Mar 12 '19 at 07:08

MjM

571
4
15

for example, two person can applied particular job ..only one person name will be display .... – Selvam Deepak Mar 12 '19 at 11:10
@Selvam Deepak The query works correctly and the problem is you are trying to get property of non-object. Run this query at your database query console you should get the count. – MjM Mar 12 '19 at 11:10
how to get the non property object..i dn't know sir help me sir – Selvam Deepak Mar 12 '19 at 11:12
are you sure $_SESSION[id_company] and $_GET[id] contains values? – MjM Mar 12 '19 at 11:26
https://stackoverflow.com/questions/5891911/trying-to-get-property-of-non-object-in check this one – MjM Mar 12 '19 at 11:29
could please update your question with the code you have written so far? – MjM Mar 12 '19 at 11:44
Check your mail inbox – MjM Mar 12 '19 at 11:53

Counting job applied person

2 Answers2