[thelist] mysql select statement

[Shashank Tripathi]

I assume

1. That it is Perl code
2. That I understand your intent correctly..

Anyway, the SQL could be as follows: 


SELECT 
	docId
	,docBusName
	,Email
	,docContact1
	,featPending
FROM 
	tblDockets 
WHERE 
      docPending  <> 0 
 AND  featPending <> 0
 AND	(docAccountStart=$form{'invoice'} OR featExpire=$form{'invoice'}) 



Hope this helps
Shanx

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.250 / Virus Database: 123 - Release Date: 18-Apr-01