2. PHPRunner General questions
  3. [SOLVED]  Multiple Choice Query
This topic is locked
[SOLVED]

 Multiple Choice Query

 		7/11/2011 16:36:32
PHPRunner General questions
Osteele author

Hello all. Can this be done:
I would like to select all clients having multiple postal / zip codes and then print mailing labels.
So for eg. Select all clients having postal codes H3R 3R3 and H2H 1H1 then print all mailing labels.
Is such a thing very complicated ???
Thank you very much!
C
 		cgphp 7/12/2011

In the "Print page: Before SQL query" event:

$strWhereClause = "postal_code = 'H3R 3R3' OR postal_code = 'H2H 1H1'";
Osteele author 7/12/2011

Thank you. Much appreciated.



In the "Print page: Before SQL query" event:

$strWhereClause = "postal_code = 'H3R 3R3' OR postal_code = 'H2H 1H1'";