Re: getting rows with max values.

2001-04-19 Thread Benjamin Pflugmann
Hi. On Thu, Apr 19, 2001 at 02:27:09PM -0700, [EMAIL PROTECTED] wrote: This may have been covered in the past; but, marc.theaimsgroup isn't responding so I can't run my normal search. This is even covered in the fine manual ;-)

GETTING ROWS

2001-03-10 Thread Randy Johnson
Here is a query: $query="Select RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT 10" ; How do I change this query to skip rows if it already selected a row with that particular receiver in it? Thanks randy - Before

RE: GETTING ROWS

2001-03-10 Thread Cal Evans
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT 10" ; HTH, Cal http://www.calevans.com -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 10, 2001 9:42 AM To: [EMAIL PROTECTED] Subject: GETTING ROWS Here

Re: GETTING ROWS

2001-03-10 Thread Tac/Smokescreen Action Network
$query="Select DISTINCT RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT 10" ; - Original Message - From: "Randy Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 10, 2001 10:41 AM Subject: GETTING ROWS Here is a query: $query=&