RE: [PHP-DB] SQL query

Make sure that your second query is returning only one row, if it dont help, try this: $query="select email from usuarios where userName in (select username from fussv where folio = 'FUSS-130-2006')" MySQL think that you second query returns more than 1 row, that's why mysql dont accept your query, is like trying to compare vs more than one scalar value Regards! +----------------------------------------+ | Ing Edwin Cruz <ecruz@medel.com.mx>    | +----+ | Transportes Medel Rogero SA de CV      | |    | | Desk:      +52 (449) 910 30 90 x3054   | +----+ | MX Mobile: +52 (449) 111 29 03         | | Aguascalientes, Mexico                 | | http://www.medel.com.mx                | +----------------------------------------+ > -----Mensaje original----- > De: Miguel Guirao [mailto:miguel.guirao@mail.telcel.com] > Enviado el: Jueves, 28 de Septiembre de 2006 09:09 a.m. > Para: php-db@lists.php.net > Asunto: [PHP-DB] SQL query > > > > > Hello list, > > Whats wrong with my SQL query: > > $query="select email from usuarios where userName = (select > username from fussv where folio = 'FUSS-130-2006')"; > > I get an error! > I have tested the two individual sentences and they worked OK! > > --------------------------- > Miguel Guirao Aguilera > Logistica R8 TELCEL > Tel. (999) 960.7994 > > > Este mensaje es exclusivamente para el uso de la persona o > entidad a quien esta dirigido; contiene informacion > estrictamente confidencial y legalmente protegida, cuya > divulgacion es sancionada por la ley. Si el lector de este > mensaje no es a quien esta dirigido, ni se trata del empleado > o agente responsable de esta informacion, se le notifica por > medio del presente, que su reproduccion y distribucion, esta > estrictamente prohibida. Si Usted recibio este comunicado por > error, favor de notificarlo inmediatamente al remitente y > destruir el mensaje. Todas las opiniones contenidas en este > mail son propias del autor del mensaje y no necesariamente > coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna > de sus empresas controladas, controladoras, afiliadas y > subsidiarias. Este mensaje intencionalmente no contiene acentos. > > This message is for the sole use of the person or entity to > whom it is being sent. Therefore, it contains strictly > confidential and legally protected material whose disclosure > is subject to penalty by law. If the person reading this > message is not the one to whom it is being sent and/or is not > an employee or the responsible agent for this information, > this person is herein notified that any unauthorized > dissemination, distribution or copying of the materials > included in this facsimile is strictly prohibited. If you > received this document by mistake please notify immediately > to the subscriber and destroy the message. Any opinions > contained in this e-mail are those of the author of the > message and do not necessarily coincide with those of > Radiomovil Dipsa, S.A. de C.V. or any of its control, > controlled, affiliates and subsidiaries companies. No part of > this message or attachments may be used or reproduced in any > manner whatsoever. > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >