adamwhiles

Wasn't sure exactly where to post this at but here is my issue. I have a directory setup where multiple developers work on a project and they all have "group" access to the folder and files(read, write, execute) so the permissions on the php files need to be 775 so they can upload and overwrite the files via FTP. The problem is that PHP files will not work with permissions of 775 and throw a internal server error unless I change it to something lower. Is there a way to overcome this for these files?

I have a site that the purpose is for users to be able to submit php code for others to see or help with whatever. I am currently inserting the actual code into a mysql, I know this is not secure but I'm looking for the best way to do this. All I need it to do is store the php code, then be able to view that code w/ highlighting etc. on another page. It works for the most part as is right now, just looking for a better option than storing in a database. Also, it seems like that when the code is pulled back out of mysql the formatting(indents) are a little off, any suggestions there? BTW, this site is not live so I don't have any examples to show you. It just runs privately on my local test machine.

basically I have 5 tables that look like this for monday through friday CREATE TABLE IF NOT EXISTS `monday` ( `name` varchar(60) NOT NULL, `lode` int(1) NOT NULL default '0', `slot1` int(1) NOT NULL default '0', `slot2` int(1) NOT NULL default '0', `slot3` int(1) NOT NULL default '0', `slot4` int(1) NOT NULL default '0', `slot5` int(1) NOT NULL default '0', `slot6` int(1) NOT NULL default '0', `slot7` int(1) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; name represent the intructors name, load represents the number of slots the instructor is booked for on that day and each slot represents a time slot for that day

Thanks! It works somewhat now. Now it creates a lot of duplicate entries. Here is the whole code segment. $result = mysql_query("SELECT * FROM monday m, tuesday t, wednesday w, thursday th, friday f WHERE m.lode='7' OR t.lode='7' OR w.lode='7' OR th.lode='7' OR f.lode='7'") or die(mysql_error()); ?> <form action="test.php" name="unavailable_users" method="post"> <select name="listbox" size="3"> <? while ($row = mysql_fetch_assoc($result)) { ?> <option value="Option 1"><?echo "$row[name]"; ?> <? } ?> ?> </select> <input type="submit" name="edit_user_go" value="Make User Available" /> </form> <?

I'm having an issue selecting rows across multiple tables. Basically I have tables monday, tuesday, wednesday, thursday and friday and they all have a common field named lode. The field lode is not the same for each row across the tables like a primary key, lode is different in most instances. What I need to do is search all tables and find the rows where lode is equal to 7. I tried this but figured it couldn't be that easy and it didn't work. Any ideas? $result = mysql_query("SELECT * FROM monday, tuesday, wednesday, thursday, friday WHERE lode='7'") or die(mysql_error());