Hi,
Just make a sql string testing the keys you are interested:
$sql = "SELECT ID, NAME, ADDRESS FROM users WHERE";
$where = ""';
if (isset($id) )
$where . = "id = $id"; // LOOK AT "." CONCATENATION OPERATOR
if (isset($name))
if ($where)
$where .= " AND name='$name'"
else
$where = "name='$name'";
if (isset($other))
if($where)
$where .= " AND other='$other'"
else
$where = "other='$other'";
mysql_query($sql.$where).
----- Original Message -----
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "Morten Nielsen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 06, 2002 5:41 PM
Subject: RE: [PHP-DB] Wildcards
> That query doesn't make sense... All you are looking for is to get a
> resultset containing ONLY the rows where name is John. So, just write:
>
> SELECT ID, NAME, ADDRESS FROM users WHERE NAME='John';
>
> By the way, in SQL, the wildcard character for regular expressions is the
> '%' not '*' .
>
> Gurhan
>
> -----Original Message-----
> From: Morten Nielsen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 06, 2002 4:46 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Wildcards
>
>
> 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
