MySQL, How to add values for SMALLINT? And Than How to filter by value?

[ilya Kraft]

Hello,

For my moderation system I need following field in database table:

name: Showing
type: smallint
values: '0','1'

I tried entering '0','1' in the values of field in smallint, but it doesn't work. What is correct way to enter 0 and 1 for values in small int?

and then how can I filter content to the page. for example

if "showing" = 0 than show content on page, else show nothing.

Thank YOu )))))

[Dormilich]

I tried entering '0','1' in the values of field in smallint, but it doesn't work.

obviously, those values are strings, not integers. (integers are passed without ')

[ilya Kraft]

Oh alright )))

so for values I only put 0,1 right?
And by any chance do you know php statement that will allow to show content if it's set to 1 and not show if it's set to 0 ?

Thnx )))

[Dormilich]

a standard if() condition.

[nathj]

Hi,

I thought we were working on this discussion on a different thread

As I ahve pointed out there before you need to pass integers in which don't use ' as Dormlich has pointed out.

Dormlich is right in saying you could use a if() condition once you have all the results or you could add to the where clause of the query that returns the results.

select a.col1, a.col2, a.col3
from table a
where a.col4 = 1
 

Assuming col4 is the field that is smallint or tinyint as was originally suggested.

Hope this helps you out.
Nathj