It is because it is a search function where a user can enter an ID, NAME and ADDRESS to search after. If one of the fields are empty it should use the wildcard.
"Morten Nielsen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > I am trying to make a SELECT command like this: > > $qid =db_query(" > SELECT ID, NAME, ADDRESS > FROM users > WHERE ID=* AND NAME='John' > "); > > Is it somehow possible to have a wildcard, so it returns all records, where > the name is john and the ID is not important? > > Regards, > Morten > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php