Posted by cover on 01/03/06 00:43

Geez, just found my syntax error - works fine now. Needed a blank
space where there wasn't one in the code on the line above. Am
posting the code just in case it might help someone else on a three
table query.

WHERE shakers.equipno = motors.equipno and shakers.equipno =
contacts.equipno "; ( <= insert space between o&" )
if ($area != "All") $query .= "and (shakers.area='$area' or
motors.area='$area' or contacts.area='$area')";



On Mon, 02 Jan 2006 14:34:29 -0800, cover
<coverlandNOSPAM914@yahoo.com> wrote:

>On Mon, 02 Jan 2006 06:18:00 GMT, L?pher Cypher
><lupher.cypher@verizon.net> wrote:
>
>>I think the problem might be that area is an ambiguous name in this
>>query (it is in both tables). Try changing it to
>>if ($area != "All") $query .= "and (shakers.area='$area' or
>>motors.area='$area')";
>
>
>Maybe this presses the envelope a little bit but if
>
>if ($area != "All") $query .= "and (shakers.area='$area' or
>motors.area='$area')";
>
>works well for two tables, why doesn't
>
>if ($area != "All") $query .= "and (shakers.area='$area' or
>motors.area='$area' or contacts.area='$area')";
>
>work for three tables? Obviousl syntax error of some kind but...

[Back to original message]