Have you ran it by hand in MySQL from the command prompt with some test
data and gotten an error?
Adam
On Tue, 12 Nov 2002, Steve Dodkins wrote:
> if i have a statement
>
> $result = mysql_query("SELECT
> labor_id,labor_ord_no,labor_wkyr,works_orders_part_no,works_orders_qty,works
> _orders_customer_id,labor_qty,labor_time,labor_qty*parts_time+parts_setup AS
> timea FROM labor,works_orders,parts WHERE labor_ord_no=works_orders_ord_no
> AND works_orders_part_no=parts_no AND time2 = labor_wkyr ORDER BY
> labor_wkyr,works_orders_ord_no",$link);
>
> This works fine but if i add AND timea > labor_time it fails
>
>
>
> Regards
>
> Steve Dodkins
>
> IMPORTANT NOTICE The information in this e-mail is confidential and should
> only be read by those persons to whom it is addressed and is not intended to
> be relied upon by any person without subsequent written confirmation of its
> contents. ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the
> accuracy or completeness of this message as it has been transmitted over a
> public network. Furthermore, the content of this e-mail is the personal
> view of the sender and does not represent the advice, views or opinion of
> our company. Accordingly, our company disclaim all responsibility and accept
> no liability (including in negligence) for the consequences of any person
> acting, or refraining from acting, on such information prior to the receipt
> by those persons of subsequent written confirmation. In particular (but not
> by way of limitation) our company disclaims all responsibility and accepts
> no liability for any e-mails which are defamatory, offensive, racist or in
> any other way are in breach of any third party's rights, including breach of
> confidence, privacy or other rights. If you have received this e-mail
> message in error, please notify me immediately by telephone. Please also
> destroy and delete the message from your computer. Any form of reproduction,
> dissemination, copying, disclosure, modification, distribution and/or
> publication of this e-mail message is strictly prohibited. If you have
> received this E-mail in error, or suspect that the message may have been
> intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245
> 468555.
> ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ
>
>
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
