[FX.php List] second find request

[David Ness]

Also, keep in mind if you concatenate numbers together, separate them
with a delimiter of some sort, otherwise "1123" could mean:

Section 1, Row 12, Seat 3

OR

Section 1, Row 1, Seat 13

 
 
David Allen Ness
Database Systems Programmer
Web Applications Developer
 

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Someone
Sent: Wednesday, June 27, 2007 10:23 AM
To: fx.php_list at mail.iviking.org
Subject: [FX.php List] second find request

Hi guys,
I want do a multiply find request
(
section1=102 and
row1=12 and
seat1=14
)
or
(
section2=102 and
row2=12 and
seat2=14
)

In filemaker you would create a second find request
I couldn't figure it out so I create  calculation fields
zw_ticket1 = section1 & row1 & seat1
zw_ticket2 = section2 & row2 & seat2

	$query->AddDBParam('zw_ticket1', $zw_ticket);
	$query->AddDBParam('-lop', 'or');
	$query->AddDBParam('zw_ticket2', $zw_ticket);
	$queryResult = $query->FMFind();

Any suggestion for a better method welcomed

Frank
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list