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

Reply via email to