Hardwarez Posted June 16, 2008 Share Posted June 16, 2008 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted June 16, 2008 Share Posted June 16, 2008 That order by clause isn't doing anything useful, so delete that for a start Quote Link to comment Share on other sites More sharing options...
Mattyspatty Posted June 16, 2008 Share Posted June 16, 2008 what exactly isnt working about it? does it fetch no rows? does it return an error? Quote Link to comment Share on other sites More sharing options...
Hardwarez Posted June 17, 2008 Author Share Posted June 17, 2008 There is no error. It returns a single result and will not return anything else. Quote Link to comment Share on other sites More sharing options...
Hardwarez Posted June 17, 2008 Author Share Posted June 17, 2008 Ok, sorry. Stupid mistake in the while loop Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.