I've been having this php/mysql problem that I can't seem to be able to fix. I'm displaying information from a mysql database on my site, but for some of the variables only half of the cases can have information in tehre that needs to be displayed on the site (e.g. the script is about an artist who sometimes features others in his videos and sometimes he doesn't and only if he does I want to show a "featuring" "Name" in my output). Because I'm posting all my code here I don't know if I should elaborate, so please ask me if you need to know more and if my story is too vague, please let me know what you wanna know! I really hope you can tell me how to get my script to work. My database: Example of database (I shortened the content to a couple of letters, some of the fields are still empty and I'll fill them in later, but the empty ones are not the ones of concert in the php script, only the one that does sometimes have content and sometimes it doesn't = "feat"): My script:[code]

sorry I saw my message didn't fit >> My script:[code]

sorry I don't know what I'm doing wrong but I just couldn't get the script inserted. here it is (just 2 kb or something for download) http://rapidshare.de/files/26392348/pleasehelp.txt.html