Jump to content


Photo

Dreamweaver and MySQL


  • Please log in to reply
1 reply to this topic

#1 ErnesTo

ErnesTo
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 25 April 2004 - 01:19 PM

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

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 26 April 2004 - 02:02 PM

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
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users