-
Displays Profiles with a Similar Job Title and Industry in php
about 2 years ago
-
about 2 years ago
Hi GBose,
You just need to use another query to get all the employees with same title. Put following section inside your current while loop:$query2 = mysqli_query($connection, "SELECT cemployees.cempid, cemployees.FName,cemployees.companyID, cemployees.title, company.CompanyName FROM cemployees JOIN company ON company.companyID = cemployees.companyID WHERE cemployees.title='".$row2['title']."' LIMIT 5"); while ($relatedEmployees = mysqli_fetch_array($query2)) { //Echo your required fields here }
$query2 = mysqli_query($connection, "SELECT cemployees.cempid, cemployees.FName,cemployees.companyID, cemployees.title FROM cemployees WHERE cemployees.title='".$row2['title']."' AND cemployees.companyID=".$row2['companyID']." LIMIT 5");
Let me know if it works. -
1 Answer(s)