Re: sql select

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 > > > > >