Dreamweaver and MySQL

[ErnesTo]

Hi,

 

I'm using this script:

SELECT * FROM clientes WHERE email LIKE 'colname%'

ORDER BY email ASC

 

and I need to do it in two fields. What can I do?

 

Thanks

[shocker-z]

Try

 

SELECT * FROM clientes WHERE email LIKE 'colname%'

AND username LIKE 'whateva'

ORDER BY email ASC

 

y are u using colname as the like string? u may have got the wrong end of the stick here