...

View Full Version : ***Problem Displaying Full Name Not Table ID***



jigsawsoul
01-23-2010, 02:22 PM
Hey. i have a small problem i think you guys might be able to help me out with. i'm trying to call up the name of the chairperson and secretary of all the meets stored within my database at the moment is is only one meeting. i have an occurrences table, with the two fields chairperson and secretary which relate to the staff table filed named staff_id.

The problem is when i call up chairperson or secretary from the database to display i get there staff_id example 1, 2 etc.. but i need to display there full name. but i can't seem to find out for the life of me what to do. can you help?

Any more information needed please let me know?? thanks



<?php

$result = "SELECT * FROM web_meeting
LEFT JOIN web_occurrences ON web_meeting.occurrence_id =web_occurrences.occurrence_id";

$result = mysql_query ($result) or die (mysql_error());
while($row = mysql_fetch_assoc($result))
{
$meetings .= '
<div class="meeting png_bg">
<h5>'.$row['title'].'</h5>
<p>
<b>Terms of reference:</b> '.$row['reference'].' <br />
<b>Chairman:</b> '.$row['chairperson'].' - <b>Secretary:</b> '.$row['secretary'].' <br />
<b>Booked:</b> '.$row['date'].'<br />
</p>
<a herf="#">View Apologies</a> | <a herf="#">View Details</a> | <a herf="#">View Members (2)</a>
</div> <br />
';
}

?>

bdl
01-23-2010, 04:08 PM
Please show the table schema of all tables involved. Most likely you want to perform an INNER JOIN, not a LEFT (OUTER) JOIN, but if we can see your tables it would be helpful.

JAY6390
01-23-2010, 04:31 PM
According to the same post on phpfreaks this has been solved... :rolleyes:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum