[SOLVED] selecting 3 values for same item in table

[Hardwarez]

I am trying to select 3 different values from a table on the same row/entry.

 

I am using this, but it does not seem to work.  Can you tell me the correct way?

SELECT * FROM techwork WHERE assignstatus = '3' OR assignstatus='1' OR assignstatus ='0' ORDER BY '' DESC

[Barand]

That order by clause isn't doing anything useful, so delete that for a start

[Mattyspatty]

what exactly isnt working about it? does it fetch no rows? does it return an error?

[Hardwarez]

There is no error.  It returns a single result and will not return anything else.

[Hardwarez]

Ok, sorry.  Stupid mistake in the while loop 

 

Thanks!