IsaiahH Posted October 30, 2011 Share Posted October 30, 2011 I have a simple code that makes a call to the WHMCS database and gets information (in this case client reviews). inside that table, it only has a userid (number). Now inside the tblclients is the first name field. How can I make it display the first name of the client (from the table tblclients) instead of the userid number (from the reviews table), but it be right after the review itself? Example: "Review Goes Here" -ClientsFirstNameHere If it helps, I used the code that jbougeno provided here http://forum.whmcs.com/showthread.php?t=12127 and just modified it a bit. 0 Quote Link to comment Share on other sites More sharing options...
plusplushosting Posted November 2, 2011 Share Posted November 2, 2011 use JOIN in your queries to link tables 0 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.