everythingandtwo

simple enough...I\'ll give it a shot. I double posted because I accidentally posted the first one in the wrong section. If authors had the ability to delete their own posts I would\'ve deleted one of them. Thanks for the help.

I\'m in the process of creating an employee scheduler for my boss. I have a table containing shift dates; a start date and an end date (i.e. Jan 11th, 2004 - April 10, 2004). I\'m wanting to divide the two dates up into weeks like so... Jan 11th, 2004 - Jan 17th, 2004 Jan 18th, 2004 - Jan 24th, 2004 Jan 25th, 2004 - Jan 31st, 2004 I want to do this until I get to the last week of the shift which would be April 4th, 2004 - April 10th, 2004. How could I do this with a mysql query? If this can\'t be done in mysql, can it be done with a php function of some sort? I\'ve been looking at the various date functions but nothing seems to jump out at me as being a solution. Can anyone help me out? Thanks. - Brad

If a user creates a database, is there a way to revoke all permissions for other users on that database automatically? For example, user1 creates the database named \"test\". By default, I want user2\'s permissions on \"test\" revoked. Is this possible to do? Also, what\'s the difference between flush privileges and reload privileges? Thanks. - Brad

Well, there\'s two ways you can go about this... 1.) You can just create a new folder on your server and store your test site in it. or... 2.) If you\'re wanting to run completely separate servers you can create another instance of Apache and set it to run on a different port. How you go about doing this depends on what OS you\'re using.

If I\'m wanting to select records from a database between two numbers, what would be the best way to write the SQL statement for it? Here\'s what I have currently, but for some reason it doesn\'t work... SELECT * FROM guestbook_main WHERE entry_num >= " . $min . " and entry_num <= " . $max . " ORDER BY entry_num DESC; This doesn\'t return anything, but if I take off the \"and entry_num <= $max\" part of it, it will return all of the entries. I tried using BETWEEN but it didn\'t work either. Can anyone help me out? Thanks, Brad[/code]

I\'m trying to backup a database that I have located on one server to another server on my network. So far I haven\'t had any luck. I can back the database up to a file locally, but not across the network. Here is the syntax I\'m using along with the error message... C:mysqlbin>mysqldump -u webuser -p pass --opt fonemail | mysql --host=10.192.212.34 fonemail_backup ERROR 1044: Access denied for user: \'@OSPSDEV3\' to database \'fonemail_backup\' I\'ve created a DB called fonemail_backup at the remote location and I have granted all privileges to webuser@OSPSDEV3 however it is still saying access denied. Can anyone help me out? Thanks! - Brad