0

Hi!! I have a simple script of displaying client work history in following manner:

<?PHP

$query1=mysql_query

("SELECT 

existing_clients_work_history.history_description, 

existing_clients_work_history.history_history, 

client_master.client_name  

FROM 

existing_clients_work_history 

INNER JOIN 

client_master 

ON

existing_clients_work_history.client_id=client_master.client_id");

if(mysql_num_rows($query1) > 0)

{

echo "<table align='center' border='0' width='1000'>";

echo "<tr class='style1' align='center'>

<td>Client Name</td>

<td>Work Description</td>

<td>Work History</td>

</tr>";

while($row1=mysql_fetch_array($query1))

{

if($row1!=0)

{

echo "<tr>

<td class='style3'>"; echo $row1['client_name']; echo "</td>

<td class='style3'>"; echo $row1['history_description']; echo "</td>

<td class='style3'>"; echo $row1['history_history']; echo "</td>

</tr>";

}

}

echo "</table>";

}

else

{

echo "<div align='center' class='style1'>Sorry No Records Found..</div>";

}

?>

Problem is, there are multiple records belonging to same client.Is there any way out if I want to display client name only once & their records afterwards??

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by codewall
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.