two WHERE conditions for reading

[raffael3d]

I read form a database:

$result = @("SELECT id,title,company,country,email FROM jobs WHERE approve=1 order by id desc LIMIT 3") or die ("could not read news database");

now I want to add a second WHERE. but it always cuases an error, how can I add correctly a second where condition?

[Lars_Berg]

You can't have multiple where clauses. On the other hand you may have multiple predicates in one where clause.

e.g.

$result = @mysql_query("SELECT id,title,company,country,email FROM jobs WHERE approve=1 or approve = 2 order by id desc LIMIT 3") or die ("could not read news database");

or

$result = @mysql_query("SELECT id,title,company,country,email FROM jobs WHERE approve=1 and country = 'SWEDEN' order by id desc LIMIT 3") or die ("could not read news database");

[Weedpacket]

Use either AND or OR (instead of a second WHERE) depending on which one you mean.

SQL 101[/url]