"GROUP BY whatever_id_you_want" in the SQL
Dan Shirah skrev:
Good Morning everyone.
In the below code I am pulling records from two tables. the records are
tied together by a common key in a 3rd table. Everything works correctly
down to the $result.
// Connect to the database
$connection = mssql_pconnect($host, $user, $pass) or die ('server
connection failed');
$database = mssql_select_db("$database", $connection) or die ('DB
selection failed');
// Query the table and load all of the records into an array.
$sql = "SELECT
support_payment_request.credit_card_id,
support_payment_request.status_code,
criminal_payment_request.credit_card_id,
criminal_payment_request.status_code,
credit_card_payment_request.credit_card_id,
credit_card_payment_request.date_request_received
FROM
credit_card_payment_request LEFT OUTER JOIN support_payment_request
ON support_payment_request.credit_card_id =
credit_card_payment_request.credit_card_id
LEFT OUTER JOIN criminal_payment_request
ON criminal_payment_request.credit_card_id =
credit_card_payment_request.credit_card_id
WHERE support_payment_request.status_code = 'P'
OR criminal_payment_request.status_code = 'P'";
// print_r ($sql);
$result = mssql_query($sql) or die(mssql_error());
// print_r ($result);
$number_rows= mssql_num_rows($result);
?>
<table width='780' border='1' align='center' cellpadding='2'
cellspacing='2'
bordercolor='#000000'>
<?php
if(!empty($result)) {
while ($row= mssql_fetch_array($result)) {
$id = $row['credit_card_id'];
$dateTime = $row['date_request_received'];
//print_r ($id);
?>
<tr>
<td width='88' height='13' align='center' class='tblcell'><div
align='center'><?php echo "<a href='javascript:editRecord($id)'>$id</a>"
?></div></td>
<td width='224' height='13' align='center' class='tblcell'><div
align='center'><?php echo "$dateTime" ?></div></td>
<td width='156' height='13' align='center' class='tblcell'><div
align='center'><?php echo "To Be Processed" ?></div></td>
<td width='156' height='13' align='center' class='tblcell'><div
align='center'><?php echo "Payment Type" ?></div></td>
<td width='156' height='13' align='center' class='tblcell'><div
align='center'><?php echo "Last Processed By" ?></div></td>
</tr>
<?php
}
}
?>
The picture below is what mu output looks like. BUT, what I am trying
to do
is have only ONE row returned per ID regardless of however many records may
be associated with that ID. Below record number 122 has three results, I
only want one row for record 122 to be displayed.
Any ideas?
2 <javascript:editRecord(2)>
Oct 6 2010 12:00AM
To Be Processed
Payment Type
Last Processed By
46 <javascript:editRecord(46)>
Feb 23 2007 2:27PM
To Be Processed
Payment Type
Last Processed By
66 <javascript:editRecord(66)>
Feb 26 2007 3:16PM
To Be Processed
Payment Type
Last Processed By
68 <javascript:editRecord(68)>
Feb 26 2007 3:39PM
To Be Processed
Payment Type
Last Processed By
76 <javascript:editRecord(76)>
Mar 21 2007 7:36AM
To Be Processed
Payment Type
Last Processed By
77 <javascript:editRecord(77)>
Mar 21 2007 7:40AM
To Be Processed
Payment Type
Last Processed By
78 <javascript:editRecord(78)>
Mar 21 2007 7:40AM
To Be Processed
Payment Type
Last Processed By
79 <javascript:editRecord(79)>
Mar 21 2007 7:41AM
To Be Processed
Payment Type
Last Processed By
122 <javascript:editRecord(122)>
Mar 27 2007 5:29PM
To Be Processed
Payment Type
Last Processed By
122 <javascript:editRecord(122)>
Mar 27 2007 5:29PM
To Be Processed
Payment Type
Last Processed By
122 <javascript:editRecord(122)>
Mar 27 2007 5:29PM
To Be Processed
Payment Type
Last Processed By
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
