Query Line

[NZ_Kiwi]

Hi,

I want to add two options to my query line,

$result = mysql_query ("SELECT * From news where BULLS = 1 order by id desc");

i need to to do a where BULLS and and Where CHC ois = 1

i guess this is simple but i've tried all the options i can think of

[sarahk]

try

$result = mysql_query ("SELECT * 
  From news 
  where BULLS = 1 
  and CHC = 1
  order by id desc");

remember though, that the query is a string and you can build it up in parts according to the data that is passed in (ie from a form)

Sarah

[NZ_Kiwi]

Originally posted by sarahk
try

$result = mysql_query ("SELECT * 
  From news 
  where BULLS = 1 
  and CHC = 1
  order by id desc");

remember though, that the query is a string and you can build it up in parts according to the data that is passed in (ie from a form)

Sarah [/B]

yeah tried that but that would mean both have to = 1. Iwant one or the other if not both

[sarahk]

then this will do

$result = mysql_query ("SELECT * 
  From news 
  where (BULLS = 1 or CHC = 1 )
  order by id desc");

and you could then have

$result = mysql_query ("SELECT * 
  From news 
  where (BULLS = 1 or CHC = 1 )
  and newsdate < now()
  order by id desc");

where i've added a column called newsdate which might record the date an item is released, so only show the items which have been released.

So the second query will show any released news from either bulls or christchurch - check out how I've used the brackets.

Sarah