"select" statement

[AdrianR]

hi guys.I have a little trouble with the select statement.
I mean I have a table named 1 and in the table I have 5 fields named "a""b""c""d""e".
How can I select the content of the field "a" but only if the content of field b is "test" and the content of field c is "more test"?
:( can`t find the answer..
SELECT a from dbname where b like 'test' and c like 'more test'
dosen`t seem to work

[php_b34st]

Try:

[code]$sql = mysql_query("SELECT a
            FROM 1
            WHERE b='test' AND c='more test'");[/code]

[AdrianR]

hmm,,yes...it works.thanks a lot :)

[AdrianR]

:( oh no,it dosen`t work.i was misstaking.the script dosen`t return any information

[redarrow]

[quote name='adrianR' date='Mar 10 2006, 09:16 PM' post='353726']
:( oh no,it dosen`t work.i was misstaking.the script dosen`t return any information
[/quote]


Try this
good luck

[code]
$sql = mysql_query("SELECT a
            FROM 1
            WHERE b='test' || c='more test'");

[/code]

or

[/quote]
[code]
$sql = mysql_query("SELECT a
            FROM 1
            WHERE b='test' && c='more test'");

[/code]