jigsawsoul Posted January 23, 2010 Share Posted January 23, 2010 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 /> '; } ?> [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.