kshet26

This is a new concept for me. How do you suggest I lock the directory? Can users still view the directories? Or do I have to keep a record of the files in a db and return them as needed?

I'm trying to figure out how sites with user uploaded content protect folders. I know about htaccess and htpassword, but are they really dynamically creating these files for every user? If this is indeed how they do it, how do I avoid using the login dialog box?

I need to seperate the values contained in a query result into seperate variables. How would I go about doing this? This is my query: $result = mysql_query("SELECT DISTINCT Bug.ixBug, Bug.sTitle, Person.sFullName, Area.sArea, Bug.dtOpened, Bug.ixPriority, Bug.ixPersonAssignedTo FROM `Bug`, BugEvent, Person, Area WHERE Area.ixArea = Bug.ixArea AND Person.ixPerson=Bug.ixPersonAssignedTo AND Bug.ixBug =BugEvent.ixBug AND Bug.ixStatus=1 AND Bug.fOpen=1 AND Bug.ixPriority =1 AND (Bug.ixProject = 2 OR Bug.ixProject = 4)") or die(mysql_error()); I need to get the 7 values from each row of this query and seperate it into individual variables. I though about using a foreach() statement, but I could figure out how to do the value separation. I need them in seperate varibles so I output them to a file in specific places.