aebstract Posted April 18, 2008 Share Posted April 18, 2008 Unknown column 'sheet' in 'where clause' $result = mysql_query("SELECT * FROM materials WHERE type=sheet ORDER BY material ASC") or DIE(mysql_error()); I've tryed a few variations with punctuation around that part of the code but keep returning the same error? Link to comment https://forums.phpfreaks.com/topic/101707-solved-unknown-column/ Share on other sites More sharing options...
jonsjava Posted April 18, 2008 Share Posted April 18, 2008 $result = mysql_query("SELECT * FROM materials WHERE type='sheet' ORDER BY material ASC") or DIE(mysql_error()); Forgot the single quotes Link to comment https://forums.phpfreaks.com/topic/101707-solved-unknown-column/#findComment-520359 Share on other sites More sharing options...
aebstract Posted April 18, 2008 Author Share Posted April 18, 2008 WOW, that is unreal.. I put single quotes around sheet about 3-4 times and it wasn't working. Well that was lame, thanks Link to comment https://forums.phpfreaks.com/topic/101707-solved-unknown-column/#findComment-520364 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.