unixmonkey

I work for a government department that stores a fair amount of private data in a database.In an attempt to secure database access, we have created a database table that contains all of the database logins and passwords. We have also created a class called "db_connect.php" which contains the login …

Do you want to have it self balancing? If you don't care (little slower) then you should write a Binary Tree class with a generic add method adds the children to the correct position by looping through the tree and checking where it goes. I guess it depends on how …

Hi Guys, This isn't really the right place to post this, but there doesn't seem to be a right place, so here it goes! I'm running a bunch of subversion repositories (one repository per project) over http (using apache). One of the repositories is a shared_classes repository that stores shared …

Hey all, I have a weird query and I'll try to explain it simply. I am building an application inventory for my work. The database includes a single master table (tb1) and many slave tables. Some of the slave tables have a language code on them (so it can store …

you may want to have a table like this: user_session 1. user_id 2. session_id 3. access (either S or T) And this one will let you have multiple instances of the same class (for example, one of the fall and one for the summer) session 1. class_id 2. datestart 3. …

I think you would be okay with that setup, but you may want to consider having a category table that is seperate and use an FK to link them. That way you can change the name of the category without worry, and you'll also save server storage that way to …

Hey All, I've been googling and phping (doesn't quite sound as good) and I can't seem to find any references or even what it is called. Here is my current situation: We have a webserver running at production.company.com In directories below that, we have web-applications such as production.company.com/timeTracker production.company.com/calculator production.company.com/geneticCloner …

This isn't really an answer to your question, but maybe a more efficient / easier way to do it. Why don't you do a use a sub-select to get the available rooms? IE: [CODE] $sql = "SELECT * FROM tb__rooms r WHERE room_id NOT IN (SELECT room_id FROM tb__bookings b …

Your default case in your switch statement will be fired if none of the other conditions are met. Would that work for you? (I've changed the final include to include register.php from default.php). [CODE]switch(isset($_REQUEST['page'])){ case "page1": include("page1.html"); break; // this should be your page name e.g, index.php?page=page1 case "page2": include("page2.php"); …

If you're running mySQL 4.1.1 you can use the timediff function. [CODE]select TIMEDIFF (timestamp1 , timestamp2) [/CODE] if you're running a mySQL version less than 4.1.1 you can use: [CODE]select UNIX_TIMESTAMP(timestamp1) - UNIX_TIMESTAMP(timestamp2)[/CODE]