Northern Flame Posted June 24, 2007 Share Posted June 24, 2007 Hello, I am making a website and on one of my pages I want to show the data from a table on my MySQL, everything is set up fine but I want to exclude certain files from it, the page displays mp3 files and I only want certain files to be displayed, In my table I included a column, active_music, which tells my database if the file is active or not, I want to exclude the inactive music from being displayed on the page. for example lets say I had these files and title2.mp3 was labled inactive: title1.mp3 title2.mp3 title3.mp3 how can I get "title2.mp3" not to be shown? If I need to include my PHP code in order to make all this easier to answer, just let me know. P.S. I dont know if this topic should have been posted here or in the PHP Help forum, sorry if I put it in the wrong place Quote Link to comment https://forums.phpfreaks.com/topic/56920-solved-exlude-files/ Share on other sites More sharing options...
bubblegum.anarchy Posted June 24, 2007 Share Posted June 24, 2007 SELECT * FROM files WHERE active_music [code] assuming that active_music is going to be either 1 or ( 0 or null ) [/code] Quote Link to comment https://forums.phpfreaks.com/topic/56920-solved-exlude-files/#findComment-281187 Share on other sites More sharing options...
Northern Flame Posted June 24, 2007 Author Share Posted June 24, 2007 LOL dam i need 2 get some sleep, i know SQL but for some reason right now I would have NEVER came up with the answer, i've been working day and night on this project, THANKS FOR THE HELP!!!!!!!! Quote Link to comment https://forums.phpfreaks.com/topic/56920-solved-exlude-files/#findComment-281194 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.