Re: Limit query results

SELECT DISTINCT? greets Zoltán Németh 2007. 05. 4, péntek keltezéssel 08.44-kor Dan Shirah ezt írta: > 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