need help on two tables to show data

Question

0.00/5 (No votes)

See more:

hi i need help to get data from two table one is hs_hr_leave and other is hs_hr_leavetype
there are the fields which are in table hs_hr_leave
leave_id
leave_date
leave_length_hours
leave_length_days
leave_status
leave_comments
leave_request_id
leave_type_id
employee_id
start_time
end_time
and table hs_hr_leavetype have
leave_type_id
leave_type_name
available_flag

i want to show leave_date , leave_status and from second table leave_type_name
and leave_type_id is common in both tables
i was using join but cant do it i need help from experts plz

i am using this
$sql ="SELECT hs_hr_leave.*, hs_hr_leavetype.leave_type_name FROM `hs_hr_leave`,`hs_hr_leavetype` JOIN `hs_hr_leavetype` ON hs_hr_leave.leave_type_id=hs_hr_leavetype.leave_type_id ";

Posted 9-Feb-11 6:19am

vicky87

Add a Solution

2 solutions

Solution 2

i think it works but not showing data using the code

XML

while ($row = mysql_fetch_array($res, MYSQL_NUM)) {
    printf("leave_id: %s - Date: %s - hours: %s - dayes: %s - stat: %s - comm: %s - req: %type - id: %s - empid: %s", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8]);
        echo '<br/>';
}
mysql_free_result($res);

and i forgot to add one thing i am getting using id and i want to show data according to id so can i usin WHERE id="id" in SQL.

plz anyone

Posted 9-Feb-11 6:28am

vicky87

Updated 9-Feb-11 7:50am

v2

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)

Sandeep Mewara · Accepted Answer · 2011-02-09T06:22:00

Solution 1

Try:

SQL

SELECT 
    hs_hr_leave.leave_date,
    hs_hr_leave.leave_status,
    hs_hr_leavetype.leave_type_name 
FROM 
    hs_hr_leave
INNER JOIN 
    hs_hr_leavetype 
ON hs_hr_leave.leave_type_id = hs_hr_leavetype.leave_type_id

Posted 9-Feb-11 6:22am

Sandeep Mewara