[SOLVED] sql statement confused, someone explain?

[jesushax]

hi below is my sql

 

$VACSQL = mysql_query("SELECT * FROM tblVacancies WHERE Archive='0' AND CityCat LIKE '$CAT' OR ConsCat LIKE '$CAT' ORDER BY DateAdded DESC") or die(mysql_error());

 

what im trynig to do is get all records that have

 

Archive 0

and either City Cat or ConsCat is like the variable $Cat

 

at the moment if i click a CityCat link and the above sql is run on the next page it works

 

if i click a Cons Cat Link the sql above shows all the correct ConsCat but it shows all Archive

 

but the archive says only if 0, i dont understand why

 

can anyone help me out?

Cheers

[waynew]

Try

 

$VACSQL = mysql_query("SELECT * FROM tblVacancies WHERE Archive='0' AND (CityCat LIKE '$CAT' OR ConsCat LIKE '$CAT') ORDER BY DateAdded DESC") or die(mysql_error());

[jesushax]

hey that works thanks

 

so what do the braces do in sql? and when would i use them?

 

Cheers