I have done a search for my question but maybe useing wrong diescrption.
I have colunm called Promotype and certain products have different values and some are blank. I would like to be able to call just populated ones. Heres what i have.
$queryInfo = mysql_query("SELECT * FROM draper INNER JOIN drapernet ON drapernet.stockcode = draper.StkNumWHERE drapernet.promotype IS NOT NULL AND draper.catagory ='$catagory' ORDER BY stknum LIMIT $start, $limit");
it there a way for this
WHERE drapernet.promotype = 'true'