Select Statement Help For Inventory Table

[artisticre]

I know what I am looking for but I don't know how to write it in code. I have an inventory table and I want a select statement to check to see if there is at least one product in inventory and if it is 0 or less to write a statement saying out of stock. Here is my table. Any ideas would be helpful because I don't quite understand IF statements with PHP

CREATE TABLE inventories (
id int(11) NOT NULL auto_increment,
parent_id int(11) NOT NULL default '0',
invsmall varchar(25) NOT NULL default '',
invmedium varchar(25) NOT NULL default '',
invlarge varchar(25) NOT NULL default '',
invXL varchar(25) NOT NULL default '',
invXXL varchar(25) NOT NULL default '',
invXXXL varchar(25) NOT NULL default '',
invXXXXL varchar(25) NOT NULL default '',
invnote varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY parent_id (parent_id),
KEY invsmall (invsmall),
KEY invmedium (invmedium),
KEY invlarge (invlarge),
KEY invXL (invXL),
KEY invXXL (invXXL),
KEY invXXXL (invXXXL),
KEY invXXXXL (invXXXXL)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

[thekidscareya]

no php if's needed

dont rely on this...but it should something along the lines of this

"SELECT invsmall FROM inventories WHERE invsmall = > 0"

if tutorial....pretty simple

if (A=😎{

echo "A=B";

}

OR

if (A=😎{

echo "A=B";

}else{

echo "A does not equal B";

}