simple sql not working?

[spires]

Hi,

 

I want to select all from my database where the months column is set to '24 Month'

and also set to ''.

 

SELECT * FROM csv_item WHERE item_contract_length='' && item_contract_length='24 Month'

 

However, every time I try it, it just brings back no results, even though both of them work on there own.

 

Any ideas please, as I really stuck.

 

Thanks

[Mchl]

Can anything be '24 month' long and empty at the same time? Use OR instead of AND

[spires]

Thanks for your help

 

OR will not work.

 

What i'm trying to do is;

In the database there are 5 options in the column - '', '6 Month', '12 Month', '24 month', '36 Month'

 

I have a dropdown list that has all of the options apart from the blank one.

If the field is empty, I want it to select the selected option i.e 24 Month AND all rows that have a black field

 

Other wise, all rows that are black will never show up in the list.

 

 

Here is the full code:

SELECT * FROM csv_item WHERE item_group='$iSearch' && item_network='$netSearch' && item_contract_length='' && item_contract_length='$clSearch' ORDER by item_internal_name AS

 

 

Any more ideas would be a great help.

 

[Mchl]

I guess you know better. Did you try at least?

http://en.wikipedia.org/wiki/Boolean_logic

 

SELECT * FROM csv_item WHERE item_group='$iSearch' AND item_network='$netSearch' AND (item_contract_length='' OR item_contract_length='$clSearch' OR item_contract_length IS NULL) ORDER by item_internal_name AS

 

[spires]

Yes,

 

I just tried. It either gives me '24 Month' OR 'blank'

 

I need to be able to select both at once: '24 Month' AND 'blank'

 

 

Any more ideas?

[spires]

Thanks for your help guys.

 

Thia is the final block of code.

It was item_contract_length IN('','$clSearch') that I was after.

 

$item_sql = "SELECT * FROM csv_item WHERE item_group='$iSearch' && item_network='$netSearch' && item_contract_length IN('','$clSearch') ORDER by item_internal_name ASC";

 

 

I needed to select both black AND month at the same time.

 

[Mchl]

Did you try the query I posted? It would work just as well.

You can't have a row that is blank AND '24 month' long at one time.

You need to select all rows that are '24 month' long OR blank

 

You can consider IN() as alternate syntax for OR (this simplifies things a little, but for this example that's irrelevant)