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 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] 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!!!!!!!! Link to comment https://forums.phpfreaks.com/topic/56920-solved-exlude-files/#findComment-281194 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.