SitePoint Sponsor

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 25 of 37
  1. #1
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How do I make this If then statement?

    I have the following code.. I want to say..

    If data exist under the Session_Username in this table. Then update the data. If no data exist for the Session_Username insert data. How do I do this?

    PHP Code:
    <?php
    $db_host 
    "localhost";
    $db_user "lefteh";
    $db_pwd "1234";
    $db_name "MyDB";
    mysql_connect($db_host$db_user$db_pwd);
    mysql_select_db($db_name);
    ?>
    <html>
    <head>
    <title>My first MySQL form submission</title>
    </head>
    <body>
    <?php
    if (!isset($_POST['submit'])) {
    ?>
    <form action="" method="post">
    Name: <input type="text" name="name"><br>
    Favorite Color: <input type="text" name="color"><br>
    <input type="submit" name="submit" value="Submit!">
    </form>
    <?php
    } else {
    $name $_POST['name'];
    $color $_POST['color'];
    mysql_query("INSERT INTO `colors` (name, favoriteColor) VALUES ('$name', '$color')");
    echo 
    "Success! Your favourite colour has been added!";
    }
    ?>
    </body>
    </html>

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    make name a primary key or unique kay and see this page: http://dev.mysql.com/doc/refman/5.0/...duplicate.html

  3. #3
    SitePoint Evangelist
    Join Date
    Feb 2005
    Posts
    581
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHP Code:
    $query mysql_query('SELECT * FROM users WHERE username=foo');
    if (
    mysql_num_rows($query) == 0)
      
    $query2 'INSERT INTO users...';
    else
      
    $query2 'UPDATE users...';

    mysql_query($query2); 
    Last edited by BluDragon; Aug 6, 2007 at 13:31.
    I will not flame the newbies,
    I will not flame the newbies,
    I will flame the newbies...
    Table free is the way to be!

  4. #4
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sorry double post

  5. #5
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can't get that to work...

    here is my code


    PHP Code:
    $query mysql_query('SELECT * WHERE username = $_SESSION[user_name]'); if (mysql_num_rows($query) == 0$query2 'INSERT INTO timesheet (username, monlaborcode0, monexchange0, monworkjob0, monreghours0, monovertime0, monlaborcode1, monexchange1, monworkjob1, monreghours1, monovertime1, monlaborcode2, monexchange2, monworkjob2, monreghours2, monovertime2, monlaborcode3, monexchange3, monworkjob3, monreghours3, monovertime3, monlaborcode4, monexchange4, monworkjob4, monreghours4, monovertime4, monlaborcode5, monexchange5, monworkjob5, monreghours5, monovertime5, monlaborcode6, monexchange6, monworkjob6, monreghours6, monovertime6, monlaborcode7, monexchange7, monworkjob7, monreghours7, monovertime7, monlaborcode8, monexchange8, monworkjob8, monreghours8, monovertime8, monlaborcode9, monexchange9, monworkjob9, monreghours9, monovertime9, tueslaborcode0, tuesexchange0, tuesworkjob0, tuesreghours0, tuesovertime0, tueslaborcode1, tuesexchange1, tuesworkjob1, tuesreghours1, tuesovertime1, tueslaborcode2, tuesexchange2, tuesworkjob2, tuesreghours2, tuesovertime2, tueslaborcode3, tuesexchange3, tuesworkjob3, tuesreghours3, tuesovertime3, tueslaborcode4, tuesexchange4, tuesworkjob4, tuesreghours4, tuesovertime4, tueslaborcode5, tuesexchange5, tuesworkjob5, tuesreghours5, tuesovertime5, tueslaborcode6, tuesexchange6, tuesworkjob6, tuesreghours6, tuesovertime6, tueslaborcode7, tuesexchange7, tuesworkjob7, tuesreghours7, tuesovertime7, tueslaborcode8, tuesexchange8, tuesworkjob8, tuesreghours8, tuesovertime8, tueslaborcode9, tuesexchange9, tuesworkjob9, tuesreghours9, tuesovertime9, wedlaborcode0, wedexchange0, wedworkjob0, wedreghours0, wedovertime0, wedlaborcode1, wedexchange1, wedworkjob1, wedreghours1, wedovertime1, wedlaborcode2, wedexchange2, wedworkjob2, wedreghours2, wedovertime2, wedlaborcode3, wedexchange3, wedworkjob3, wedreghours3, wedovertime3, wedlaborcode4, wedexchange4, wedworkjob4, wedreghours4, wedovertime4, wedlaborcode5, wedexchange5, wedworkjob5, wedreghours5, wedovertime5, wedlaborcode6, wedexchange6, wedworkjob6, wedreghours6, wedovertime6, wedlaborcode7, wedexchange7, wedworkjob7, wedreghours7, wedovertime7, wedlaborcode8, wedexchange8, wedworkjob8, wedreghours8, wedovertime8, wedlaborcode9, wedexchange9, wedworkjob9, wedreghours9, wedovertime9, thurslaborcode0, thursexchange0, thursworkjob0, thursreghours0, thursovertime0, thurslaborcode1, thursexchange1, thursworkjob1, thursreghours1, thursovertime1, thurslaborcode2, thursexchange2, thursworkjob2, thursreghours2, thursovertime2, thurslaborcode3, thursexchange3, thursworkjob3, thursreghours3, thursovertime3, thurslaborcode4, thursexchange4, thursworkjob4, thursreghours4, thursovertime4, thurslaborcode5, thursexchange5, thursworkjob5, thursreghours5, thursovertime5, thurslaborcode6, thursexchange6, thursworkjob6, thursreghours6, thursovertime6, thurslaborcode7, thursexchange7, thursworkjob7, thursreghours7, thursovertime7, thurslaborcode8, thursexchange8, thursworkjob8, thursreghours8, thursovertime8, thurslaborcode9, thursexchange9, thursworkjob9, thursreghours9,thursovertime9, frilaborcode0, friexchange0, friworkjob0, frireghours0, friovertime0, frilaborcode1, friexchange1, friworkjob1, frireghours1, friovertime1, frilaborcode2, friexchange2, friworkjob2, frireghours2, friovertime2, frilaborcode3, friexchange3, friworkjob3, frireghours3, friovertime3, frilaborcode4, friexchange4, friworkjob4, frireghours4, friovertime4, frilaborcode5, friexchange5, friworkjob5, frireghours5, friovertime5, frilaborcode6, friexchange6, friworkjob6, frireghours6, friovertime6, frilaborcode7, friexchange7, friworkjob7, frireghours7, friovertime7, frilaborcode8, friexchange8, friworkjob8, frireghours8, friovertime8, frilaborcode9, friexchange9, friworkjob9, frireghours9, friovertime9, satlaborcode0, satexchange0, satworkjob0, satreghours0, satovertime0, satlaborcode1, satexchange1, satworkjob1, satreghours1, satovertime1, satlaborcode2, satexchange2, satworkjob2, satreghours2, satovertime2, satlaborcode3, satexchange3, satworkjob3, satreghours3, satovertime3, satlaborcode4, satexchange4, satworkjob4, satreghours4, satovertime4, satlaborcode5, satexchange5, satworkjob5, satreghours5, satovertime5, satlaborcode6, satexchange6, satworkjob6, satreghours6, satovertime6, satlaborcode7, satexchange7, satworkjob7, satreghours7, satovertime7, satlaborcode8, satexchange8, satworkjob8, satreghours8, satovertime8, satlaborcode9, satexchange9, satworkjob9, satreghours9, satovertime9, sunlaborcode0, sunexchange0, sunworkjob0, sunreghours0, sunovertime0, sunlaborcode1, sunexchange1, sunworkjob1, sunreghours1, sunovertime1, sunlaborcode2, sunexchange2, sunworkjob2, sunreghours2, sunovertime2, sunlaborcode3, sunexchange3, sunworkjob3, sunreghours3, sunovertime3, sunlaborcode4, sunexchange4, sunworkjob4, sunreghours4, sunovertime4, sunlaborcode5, sunexchange5, sunworkjob5, sunreghours5,sunovertime5, sunlaborcode6, sunexchange6, sunworkjob6, sunreghours6, sunovertime6, sunlaborcode7, sunexchange7, sunworkjob7, sunreghours7, sunovertime7, sunlaborcode8, sunexchange8, sunworkjob8, sunreghours8, sunovertime8, sunlaborcode9, sunexchange9, sunworkjob9, sunreghours9, sunovertime9, summlaborcode0, summexchange0, summworkjob0, summreghours0, summovertime0, summlaborcode1, summexchange1, summworkjob1, summreghours1, summovertime1, summlaborcode2, summexchange2, summworkjob2, summreghours2, summovertime2, summlaborcode3, summexchange3, summworkjob3, summreghours3, summovertime3, summlaborcode4, summexchange4, summworkjob4, summreghours4, summovertime4, summlaborcode5, summexchange5, summworkjob5, summreghours5, summovertime5, summlaborcode6, summexchange6, summworkjob6, summreghours6, summovertime6, summlaborcode7, summexchange7, summworkjob7, summreghours7, summovertime7, summlaborcode8, summexchange8, summworkjob8, summreghours8, summovertime8, summlaborcode9, summexchange9, summworkjob9, summreghours9, summovertime9) VALUES ('$_SESSION[user_name]', '$monlaborcode0', '$monexchange0', '$monworkjob0', '$monreghours0', '$monovertime0', '$monlaborcode1', '$monexchange1', '$monworkjob1', '$monreghours1', '$monovertime1', '$monlaborcode2', '$monexchange2', '$monworkjob2', '$monreghours2', '$monovertime2', '$monlaborcode3', '$monexchange3', '$monworkjob3', '$monreghours3', '$monovertime3', '$monlaborcode4', '$monexchange4', '$monworkjob4', '$monreghours4', '$monovertime4', '$monlaborcode5', '$monexchange5', '$monworkjob5', '$monreghours5', '$monovertime5', '$monlaborcode6', '$monexchange6', '$monworkjob6', '$monreghours6', '$monovertime6', '$monlaborcode7', '$monexchange7', '$monworkjob7', '$monreghours7', '$monovertime7', '$monlaborcode8', '$monexchange8', '$monworkjob8', '$monreghours8', '$monovertime8', '$monlaborcode9', '$monexchange9', '$monworkjob9', '$monreghours9', '$monovertime9', '$tueslaborcode0', '$tuesexchange0', '$tuesworkjob0', '$tuesreghours0', '$tuesovertime0', '$tueslaborcode1', '$tuesexchange1', '$tuesworkjob1', '$tuesreghours1', '$tuesovertime1', '$tueslaborcode2', '$tuesexchange2', '$tuesworkjob2', '$tuesreghours2', '$tuesovertime2', '$tueslaborcode3', '$tuesexchange3', '$tuesworkjob3', '$tuesreghours3', '$tuesovertime3', '$tueslaborcode4', '$tuesexchange4', '$tuesworkjob4', '$tuesreghours4', '$tuesovertime4', '$tueslaborcode5', '$tuesexchange5', '$tuesworkjob5', '$tuesreghours5', '$tuesovertime5', '$tueslaborcode6', '$tuesexchange6', '$tuesworkjob6', '$tuesreghours6', '$tuesovertime6', '$tueslaborcode7', '$tuesexchange7', '$tuesworkjob7', '$tuesreghours7', '$tuesovertime7', '$tueslaborcode8', '$tuesexchange8', '$tuesworkjob8', '$tuesreghours8', '$tuesovertime8', '$tueslaborcode9', '$tuesexchange9', '$tuesworkjob9', '$tuesreghours9', '$tuesovertime9', '$wedlaborcode0', '$wedexchange0', '$wedworkjob0', '$wedreghours0', '$wedovertime0', '$wedlaborcode1', '$wedexchange1', '$wedworkjob1', '$wedreghours1', '$wedovertime1', '$wedlaborcode2', '$wedexchange2', '$wedworkjob2', '$wedreghours2', '$wedovertime2', '$wedlaborcode3', '$wedexchange3', '$wedworkjob3', '$wedreghours3', '$wedovertime3', '$wedlaborcode4', '$wedexchange4', '$wedworkjob4', '$wedreghours4', '$wedovertime4', '$wedlaborcode5', '$wedexchange5', '$wedworkjob5', '$wedreghours5', '$wedovertime5', '$wedlaborcode6', '$wedexchange6', '$wedworkjob6', '$wedreghours6', '$wedovertime6', '$wedlaborcode7', '$wedexchange7', '$wedworkjob7', '$wedreghours7', '$wedovertime7', '$wedlaborcode8', '$wedexchange8', '$wedworkjob8', '$wedreghours8', '$wedovertime8', '$wedlaborcode9', '$wedexchange9', '$wedworkjob9', '$wedreghours9', '$wedovertime9', '$thurslaborcode0', '$thursexchange0', '$thursworkjob0', '$thursreghours0', '$thursovertime0', '$thurslaborcode1', '$thursexchange1', '$thursworkjob1', '$thursreghours1', '$thursovertime1', '$thurslaborcode2', '$thursexchange2', '$thursworkjob2', '$thursreghours2', '$thursovertime2', '$thurslaborcode3', '$thursexchange3', '$thursworkjob3', '$thursreghours3', '$thursovertime3', '$thurslaborcode4', '$thursexchange4', '$thursworkjob4', '$thursreghours4', '$thursovertime4', '$thurslaborcode5', '$thursexchange5', '$thursworkjob5', '$thursreghours5', '$thursovertime5', '$thurslaborcode6', '$thursexchange6', '$thursworkjob6', '$thursreghours6', '$thursovertime6', '$thurslaborcode7', '$thursexchange7', '$thursworkjob7', '$thursreghours7', '$thursovertime7', '$thurslaborcode8', '$thursexchange8', '$thursworkjob8', '$thursreghours8', '$thursovertime8', '$thurslaborcode9', '$thursexchange9', '$thursworkjob9', '$thursreghours9', '$thursovertime9', '$frilaborcode0', '$friexchange0', '$friworkjob0', '$frireghours0', '$friovertime0', '$frilaborcode1', '$friexchange1', '$friworkjob1', '$frireghours1', '$friovertime1', '$frilaborcode2', '$friexchange2', '$friworkjob2', '$frireghours2', '$friovertime2', '$frilaborcode3', '$friexchange3', '$friworkjob3', '$frireghours3', '$friovertime3', '$frilaborcode4', '$friexchange4', '$friworkjob4', '$frireghours4', '$friovertime4', '$frilaborcode5', '$friexchange5', '$friworkjob5', '$frireghours5', '$friovertime5', '$frilaborcode6', '$friexchange6', '$friworkjob6', '$frireghours6', '$friovertime6', '$frilaborcode7', '$friexchange7', '$friworkjob7', '$frireghours7', '$friovertime7', '$frilaborcode8', '$friexchange8', '$friworkjob8', '$frireghours8', '$friovertime8', '$frilaborcode9', '$friexchange9', '$friworkjob9', '$frireghours9', '$friovertime9', '$satlaborcode0', '$satexchange0', '$satworkjob0', '$satreghours0', '$satovertime0', '$satlaborcode1', '$satexchange1', '$satworkjob1', '$satreghours1', '$satovertime1', '$satlaborcode2', '$satexchange2', '$satworkjob2', '$satreghours2', '$satovertime2', '$satlaborcode3', '$satexchange3', '$satworkjob3', '$satreghours3', '$satovertime3', '$satlaborcode4', '$satexchange4', '$satworkjob4', '$satreghours4', '$satovertime4', '$satlaborcode5', '$satexchange5', '$satworkjob5', '$satreghours5', '$satovertime5', '$satlaborcode6', '$satexchange6', '$satworkjob6', '$satreghours6', '$satovertime6', '$satlaborcode7', '$satexchange7', '$satworkjob7', '$satreghours7', '$satovertime7', '$satlaborcode8', '$satexchange8', '$satworkjob8', '$satreghours8', '$satovertime8', '$satlaborcode9', '$satexchange9', '$satworkjob9', '$satreghours9', '$satovertime9', '$sunlaborcode0', '$sunexchange0', '$sunworkjob0', '$sunreghours0', '$sunovertime0', '$sunlaborcode1', '$sunexchange1', '$sunworkjob1', '$sunreghours1', '$sunovertime1', '$sunlaborcode2', '$sunexchange2', '$sunworkjob2', '$sunreghours2', '$sunovertime2', '$sunlaborcode3', '$sunexchange3', '$sunworkjob3', '$sunreghours3', '$sunovertime3', '$sunlaborcode4', '$sunexchange4', '$sunworkjob4', '$sunreghours4', '$sunovertime4', '$sunlaborcode5', '$sunexchange5', '$sunworkjob5', '$sunreghours5', '$sunovertime5', '$sunlaborcode6', '$sunexchange6', '$sunworkjob6', '$sunreghours6', '$sunovertime6', '$sunlaborcode7', '$sunexchange7', '$sunworkjob7', '$sunreghours7', '$sunovertime7', '$sunlaborcode8', '$sunexchange8', '$sunworkjob8', '$sunreghours8', '$sunovertime8', '$sunlaborcode9', '$sunexchange9', '$sunworkjob9', '$sunreghours9', '$sunovertime9', '$summlaborcode0', '$summexchange0', '$summworkjob0', '$summreghours0', '$summovertime0', '$summlaborcode1', '$summexchange1', '$summworkjob1', '$summreghours1', '$summovertime1', '$summlaborcode2', '$summexchange2', '$summworkjob2', '$summreghours2', '$summovertime2', '$summlaborcode3', '$summexchange3', '$summworkjob3', '$summreghours3', '$summovertime3', '$summlaborcode4', '$summexchange4', '$summworkjob4', '$summreghours4', '$summovertime4', '$summlaborcode5', '$summexchange5', '$summworkjob5', '$summreghours5', '$summovertime5', '$summlaborcode6', '$summexchange6', '$summworkjob6', '$summreghours6', '$summovertime6', '$summlaborcode7', '$summexchange7', '$summworkjob7', '$summreghours7', '$summovertime7', '$summlaborcode8', '$summexchange8', '$summworkjob8', '$summreghours8', '$summovertime8', '$summlaborcode9', '$summexchange9', '$summworkjob9', '$summreghours9', '$summovertime9' )'; else $query2 'UPDATE timesheet 
    SET 
    monlaborcode0 = '
    $_POST['monlaborcode0']', 
    monexchange0 = '
    $_POST['monexchange0']', 
    monworkjob0 = '
    $_POST['monworkjob0']', 
    monreghours0 = '
    $_POST['monreghours0']', 
    monovertime0 = '
    $_POST['monovertime0']', 
    monlaborcode1 = '
    $_POST['monlaborcode1']', 
    monexchange1 = '
    $_POST['monexchange1']', 
    monworkjob1 = '
    $_POST['monworkjob1']', 
    monreghours1 = '
    $_POST['monreghours1']', 
    monovertime1 = '
    $_POST['monovertime1']', 
    monlaborcode2 = '
    $_POST['monlaborcode2']', 
    monexchange2 = '
    $_POST['monexchange2']', 
    monworkjob2 = '
    $_POST['monworkjob2']', 
    monreghours2 = '
    $_POST['monreghours2']', 
    monovertime2 = '
    $_POST['monovertime2']', 
    monlaborcode3 = '
    $_POST['monlaborcode3']', 
    monexchange3 = '
    $_POST['monexchange3']', 
    monworkjob3 = '
    $_POST['monworkjob3']', 
    monreghours3 = '
    $_POST['monreghours3']', 
    monovertime3 = '
    $_POST['monovertime3']', 
    monlaborcode4 = '
    $_POST['monlaborcode4']', 
    monexchange4 = '
    $_POST['monexchange4']', 
    monworkjob4 = '
    $_POST['monworkjob4']', 
    monreghours4 = '
    $_POST['monreghours4']', 
    monovertime4 = '
    $_POST['monovertime4']', 
    monlaborcode5 = '
    $_POST['monlaborcode5']', 
    monexchange5 = '
    $_POST['monexchange5']', 
    monworkjob5 = '
    $_POST['monworkjob5']', 
    monreghours5 = '
    $_POST['monreghours5']', 
    monovertime5 = '
    $_POST['monovertime5']', 
    monlaborcode6 = '
    $_POST['monlaborcode6']', 
    monexchange6 = '
    $_POST['monexchange6']', 
    monworkjob6 = '
    $_POST['monworkjob6']', 
    monreghours6 = '
    $_POST['monreghours6']', 
    monovertime6 = '
    $_POST['monovertime6']', 
    monlaborcode7 = '
    $_POST['monlaborcode7']', 
    monexchange7 = '
    $_POST['monexchange7']', 
    monworkjob7 = '
    $_POST['monworkjob7']', 
    monreghours7 = '
    $_POST['monreghours7']', 
    $monovertime7 = '
    $_POST['monovertime7']', 
    $monlaborcode8 = '
    $_POST['monlaborcode8']', 
    $monexchange8 = '
    $_POST['monexchange8']', 
    $monworkjob8 = '
    $_POST['monworkjob8']', 
    $monreghours8 = '
    $_POST['monreghours8']', 
    $monovertime8 = '
    $_POST['monovertime8']', 
    $monlaborcode9 = '
    $_POST['monlaborcode9']', 
    $monexchange9 = '
    $_POST['monexchange9']', 
    $monworkjob9 = '
    $_POST['monworkjob9']', 
    $monreghours9 = '
    $_POST['monreghours9']', 
    $monovertime9 = '
    $_POST['monovertime9']', 
    tueslaborcode0 = '
    $_POST['tueslaborcode0']', 
    tuesexchange0 = '
    $_POST['tuesexchange0']', 
    tuesworkjob0 = '
    $_POST['tuesworkjob0']', 
    tuesreghours0 = '
    $_POST['tuesreghours0']', 
    tuesovertime0 = '
    $_POST['tuesovertime0']', 
    tueslaborcode1 = '
    $_POST['tueslaborcode1']', 
    tuesexchange1 = '
    $_POST['tuesexchange1']', 
    tuesworkjob1 = '
    $_POST['tuesworkjob1']', 
    tuesreghours1 = '
    $_POST['tuesreghours1']', 
    tuesovertime1 = '
    $_POST['tuesovertime1']', 
    tueslaborcode2 = '
    $_POST['tueslaborcode2']', 
    tuesexchange2 = '
    $_POST['tuesexchange2']', 
    tuesworkjob2 = '
    $_POST['tuesworkjob2']', 
    tuesreghours2 = '
    $_POST['tuesreghours2']', 
    tuesovertime2 = '
    $_POST['tuesovertime2']', 
    tueslaborcode3 = '
    $_POST['tueslaborcode3']', 
    tuesexchange3 = '
    $_POST['tuesexchange3']', 
    tuesworkjob3 = '
    $_POST['tuesworkjob3']', 
    tuesreghours3 = '
    $_POST['tuesreghours3']', 
    tuesovertime3 = '
    $_POST['tuesovertime3']', 
    tueslaborcode4 = '
    $_POST['tueslaborcode4']', 
    tuesexchange4 = '
    $_POST['tuesexchange4']', 
    tuesworkjob4 = '
    $_POST['tuesworkjob4']', 
    tuesreghours4 = '
    $_POST['tuesreghours4']', 
    tuesovertime4 = '
    $_POST['tuesovertime4']', 
    tueslaborcode5 = '
    $_POST['tueslaborcode5']', 
    tuesexchange5 = '
    $_POST['tuesexchange5']', 
    tuesworkjob5 = '
    $_POST['tuesworkjob5']', 
    tuesreghours5 = '
    $_POST['tuesreghours5']', 
    tuesovertime5 = '
    $_POST['tuesovertime5']', 
    tueslaborcode6 = '
    $_POST['tueslaborcode6']', 
    tuesexchange6 = '
    $_POST['tuesexchange6']', 
    tuesworkjob6 = '
    $_POST['tuesworkjob6']', 
    tuesreghours6 = '
    $_POST['tuesreghours6']', 
    tuesovertime6 = '
    $_POST['tuesovertime6']', 
    tueslaborcode7 = '
    $_POST['tueslaborcode7']', 
    tuesexchange7 = '
    $_POST['tuesexchange7']', 
    tuesworkjob7 = '
    $_POST['tuesworkjob7']', 
    tuesreghours7 = '
    $_POST['tuesreghours7']', 
    tuesovertime7 = '
    $_POST['tuesovertime7']', 
    tueslaborcode8 = '
    $_POST['tueslaborcode8']', 
    tuesexchange8 = '
    $_POST['tuesexchange8']', 
    tuesworkjob8 = '
    $_POST['tuesworkjob8']', 
    tuesreghours8 = '
    $_POST['tuesreghours8']', 
    tuesovertime8 = '
    $_POST['tuesovertime8']', 
    tueslaborcode9 = '
    $_POST['tueslaborcode9']', 
    tuesexchange9 = '
    $_POST['tuesexchange9']', 
    tuesworkjob9 = '
    $_POST['tuesworkjob9']', 
    tuesreghours9 = '
    $_POST['tuesreghours9']', 
    tuesovertime9 = '
    $_POST['tuesovertime9']', 
    wedlaborcode0 = '
    $_POST['wedlaborcode0']', 
    wedexchange0 = '
    $_POST['wedexchange0']', 
    wedworkjob0 = '
    $_POST['wedworkjob0']', 
    wedreghours0 = '
    $_POST['wedreghours0']', 
    wedovertime0 = '
    $_POST['wedovertime0']', 
    wedlaborcode1 = '
    $_POST['wedlaborcode1']', 
    wedexchange1 = '
    $_POST['wedexchange1']', 
    wedworkjob1 = '
    $_POST['wedworkjob1']', 
    wedreghours1 = '
    $_POST['wedreghours1']', 
    wedovertime1 = '
    $_POST['wedovertime1']', 
    wedlaborcode2 = '
    $_POST['wedlaborcode2']', 
    wedexchange2 = '
    $_POST['wedexchange2']', 
    wedworkjob2 = '
    $_POST['wedworkjob2']', 
    wedreghours2 = '
    $_POST['wedreghours2']', 
    wedovertime2 = '
    $_POST['wedovertime2']', 
    wedlaborcode3 = '
    $_POST['wedlaborcode3']', 
    wedexchange3 = '
    $_POST['wedexchange3']', 
    wedworkjob3 = '
    $_POST['wedworkjob3']', 
    wedreghours3 = '
    $_POST['wedreghours3']', 
    wedovertime3 = '
    $_POST['wedovertime3']', 
    wedlaborcode4 = '
    $_POST['wedlaborcode4']', 
    wedexchange4 = '
    $_POST['wedexchange4']', 
    wedworkjob4 = '
    $_POST['wedworkjob4']', 
    wedreghours4 = '
    $_POST['wedreghours4']', 
    wedovertime4 = '
    $_POST['wedovertime4']', 
    wedlaborcode5 = '
    $_POST['wedlaborcode5']', 
    wedexchange5 = '
    $_POST['wedexchange5']', 
    wedworkjob5 = '
    $_POST['wedworkjob5']', 
    wedreghours5 = '
    $_POST['wedreghours5']', 
    wedovertime5 = '
    $_POST['wedovertime5']', 
    wedlaborcode6 = '
    $_POST['wedlaborcode6']', 
    wedexchange6 = '
    $_POST['wedexchange6']', 
    wedworkjob6 = '
    $_POST['wedworkjob6']', 
    wedreghours6 = '
    $_POST['wedreghours6']', 
    wedovertime6 = '
    $_POST['wedovertime6']', 
    wedlaborcode7 = '
    $_POST['wedlaborcode7']', 
    wedexchange7 = '
    $_POST['wedexchange7']', 
    wedworkjob7 = '
    $_POST['wedworkjob7']', 
    wedreghours7 = '
    $_POST['wedreghours7']', 
    wedovertime7 = '
    $_POST['wedovertime7']', 
    wedlaborcode8 = '
    $_POST['wedlaborcode8']', 
    wedexchange8 = '
    $_POST['wedexchange8']', 
    wedworkjob8 = '
    $_POST['wedworkjob8']', 
    wedreghours8 = '
    $_POST['wedreghours8']', 
    wedovertime8 = '
    $_POST['wedovertime8']', 
    wedlaborcode9 = '
    $_POST['wedlaborcode9']', 
    wedexchange9 = '
    $_POST['wedexchange9']', 
    wedworkjob9 = '
    $_POST['wedworkjob9']', 
    wedreghours9 = '
    $_POST['wedreghours9']', 
    wedovertime9 = '
    $_POST['wedovertime9']', 
    thurslaborcode0 = '
    $_POST['thurslaborcode0']', 
    thursexchange0 = '
    $_POST['thursexchange0']', 
    thursworkjob0 = '
    $_POST['thursworkjob0']', 
    thursreghours0 = '
    $_POST['thursreghours0']', 
    thursovertime0 = '
    $_POST['thursovertime0']', 
    thurslaborcode1 = '
    $_POST['thurslaborcode1']', 
    thursexchange1 = '
    $_POST['thursexchange1']', 
    thursworkjob1 = '
    $_POST['thursworkjob1']', 
    thursreghours1 = '
    $_POST['thursreghours1']', 
    thursovertime1 = '
    $_POST['thursovertime1']', 
    thurslaborcode2 = '
    $_POST['thurslaborcode2']', 
    thursexchange2 = '
    $_POST['thursexchange2']', 
    thursworkjob2 = '
    $_POST['thursworkjob2']', 
    thursreghours2 = '
    $_POST['thursreghours2']', 
    thursovertime2 = '
    $_POST['thursovertime2']', 
    thurslaborcode3 = '
    $_POST['thurslaborcode3']', 
    thursexchange3 = '
    $_POST['thursexchange3']', 
    thursworkjob3 = '
    $_POST['thursworkjob3']', 
    thursreghours3 = '
    $_POST['thursreghours3']', 
    thursovertime3 = '
    $_POST['thursovertime3']', 
    thurslaborcode4 = '
    $_POST['thurslaborcode4']', 
    thursexchange4 = '
    $_POST['thursexchange4']', 
    thursworkjob4 = '
    $_POST['thursworkjob4']', 
    thursreghours4 = '
    $_POST['thursreghours4']', 
    thursovertime4 = '
    $_POST['thursovertime4']', 
    thurslaborcode5 = '
    $_POST['thurslaborcode5']', 
    thursexchange5 = '
    $_POST['thursexchange5']', 
    thursworkjob5 = '
    $_POST['thursworkjob5']', 
    thursreghours5 = '
    $_POST['thursreghours5']', 
    thursovertime5 = '
    $_POST['thursovertime5']', 
    thurslaborcode6 = '
    $_POST['thurslaborcode6']', 
    thursexchange6 = '
    $_POST['thursexchange6']', 
    thursworkjob6 = '
    $_POST['thursworkjob6']', 
    thursreghours6 = '
    $_POST['thursreghours6']', 
    thursovertime6 = '
    $_POST['thursovertime6']', 
    thurslaborcode7 = '
    $_POST['thurslaborcode7']', 
    thursexchange7 = '
    $_POST['thursexchange7']', 
    thursworkjob7 = '
    $_POST['thursworkjob7']', 
    thursreghours7 = '
    $_POST['thursreghours7']', 
    thursovertime7 = '
    $_POST['thursovertime7']', 
    thurslaborcode8 = '
    $_POST['thurslaborcode8']', 
    thursexchange8 = '
    $_POST['thursexchange8']', 
    thursworkjob8 = '
    $_POST['thursworkjob8']', 
    thursreghours8 = '
    $_POST['thursreghours8']', 
    thursovertime8 = '
    $_POST['thursovertime8']', 
    thurslaborcode9 = '
    $_POST['thurslaborcode9']', 
    thursexchange9 = '
    $_POST['thursexchange9']', 
    thursworkjob9 = '
    $_POST['thursworkjob9']', 
    thursreghours9 = '
    $_POST['thursreghours9']', 
    thursovertime9 = '
    $_POST['thursovertime9']', 
    frilaborcode0 = '
    $_POST['frilaborcode0']', 
    friexchange0 = '
    $_POST['friexchange0']', 
    friworkjob0 = '
    $_POST['friworkjob0']', 
    frireghours0 = '
    $_POST['frireghours0']', 
    friovertime0 = '
    $_POST['friovertime0']', 
    frilaborcode1 = '
    $_POST['frilaborcode1']', 
    friexchange1 = '
    $_POST['friexchange1']', 
    friworkjob1 = '
    $_POST['friworkjob1']', 
    frireghours1 = '
    $_POST['frireghours1']', 
    friovertime1 = '
    $_POST['friovertime1']', 
    frilaborcode2 = '
    $_POST['frilaborcode2']', 
    friexchange2 = '
    $_POST['friexchange2']', 
    friworkjob2 = '
    $_POST['friworkjob2']', 
    frireghours2 = '
    $_POST['frireghours2']', 
    friovertime2 = '
    $_POST['friovertime2']', 
    frilaborcode3 = '
    $_POST['frilaborcode3']', 
    friexchange3 = '
    $_POST['friexchange3']', 
    friworkjob3 = '
    $_POST['friworkjob3']', 
    frireghours3 = '
    $_POST['frireghours3']', 
    friovertime3 = '
    $_POST['friovertime3']', 
    frilaborcode4 = '
    $_POST['frilaborcode4']', 
    friexchange4 = '
    $_POST['friexchange4']', 
    friworkjob4 = '
    $_POST['friworkjob4']', 
    frireghours4 = '
    $_POST['frireghours4']', 
    friovertime4 = '
    $_POST['friovertime4']', 
    frilaborcode5 = '
    $_POST['frilaborcode5']', 
    friexchange5 = '
    $_POST['friexchange5']', 
    friworkjob5 = '
    $_POST['friworkjob5']', 
    frireghours5 = '
    $_POST['frireghours5']', 
    friovertime5 = '
    $_POST['friovertime5']', 
    frilaborcode6 = '
    $_POST['frilaborcode6']', 
    friexchange6 = '
    $_POST['friexchange6']', 
    friworkjob6 = '
    $_POST['friworkjob6']', 
    frireghours6 = '
    $_POST['frireghours6']', 
    friovertime6 = '
    $_POST['friovertime6']', 
    frilaborcode7 = '
    $_POST['frilaborcode7']', 
    friexchange7 = '
    $_POST['friexchange7']', 
    friworkjob7 = '
    $_POST['friworkjob7']', 
    frireghours7 = '
    $_POST['frireghours7']', 
    friovertime7 = '
    $_POST['friovertime7']', 
    frilaborcode8 = '
    $_POST['frilaborcode8']', 
    friexchange8 = '
    $_POST['friexchange8']', 
    friworkjob8 = '
    $_POST['friworkjob8']', 
    frireghours8 = '
    $_POST['frireghours8']', 
    friovertime8 = '
    $_POST['friovertime8']', 
    frilaborcode9 = '
    $_POST['frilaborcode9']', 
    friexchange9 = '
    $_POST['friexchange9']', 
    friworkjob9 = '
    $_POST['friworkjob9']', 
    frireghours9 = '
    $_POST['frireghours9']', 
    friovertime9 = '
    $_POST['friovertime9']', 
    satlaborcode0 = '
    $_POST['satlaborcode0']', 
    satexchange0 = '
    $_POST['satexchange0']', 
    satworkjob0 = '
    $_POST['satworkjob0']', 
    satreghours0 = '
    $_POST['satreghours0']', 
    satovertime0 = '
    $_POST['satovertime0']', 
    satlaborcode1 = '
    $_POST['satlaborcode1']', 
    satexchange1 = '
    $_POST['satexchange1']', 
    satworkjob1 = '
    $_POST['satworkjob1']', 
    satreghours1 = '
    $_POST['satreghours1']', 
    satovertime1 = '
    $_POST['satovertime1']', 
    satlaborcode2 = '
    $_POST['satlaborcode2']', 
    satexchange2 = '
    $_POST['satexchange2']', 
    satworkjob2 = '
    $_POST['satworkjob2']', 
    satreghours2 = '
    $_POST['satreghours2']', 
    satovertime2 = '
    $_POST['satovertime2']', 
    satlaborcode3 = '
    $_POST['satlaborcode3']', 
    satexchange3 = '
    $_POST['satexchange3']', 
    satworkjob3 = '
    $_POST['satworkjob3']', 
    satreghours3 = '
    $_POST['satreghours3']', 
    satovertime3 = '
    $_POST['satovertime3']', 
    satlaborcode4 = '
    $_POST['satlaborcode4']', 
    satexchange4 = '
    $_POST['satexchange4']', 
    satworkjob4 = '
    $_POST['satworkjob4']', 
    satreghours4 = '
    $_POST['satreghours4']', 
    satovertime4 = '
    $_POST['satovertime4']', 
    satlaborcode5 = '
    $_POST['satlaborcode5']', 
    satexchange5 = '
    $_POST['satexchange5']', 
    satworkjob5 = '
    $_POST['satworkjob5']', 
    satreghours5 = '
    $_POST['satreghours5']', 
    satovertime5 = '
    $_POST['satovertime5']', 
    satlaborcode6 = '
    $_POST['satlaborcode6']', 
    satexchange6 = '
    $_POST['satexchange6']', 
    satworkjob6 = '
    $_POST['satworkjob6']', 
    satreghours6 = '
    $_POST['satreghours6']', 
    satovertime6 = '
    $_POST['satovertime6']', 
    satlaborcode7 = '
    $_POST['satlaborcode7']', 
    satexchange7 = '
    $_POST['satexchange7']', 
    satworkjob7 = '
    $_POST['satworkjob7']', 
    satreghours7 = '
    $_POST['satreghours7']', 
    satovertime7 = '
    $_POST['satovertime7']', 
    satlaborcode8 = '
    $_POST['satlaborcode8']', 
    satexchange8 = '
    $_POST['satexchange8']', 
    satworkjob8 = '
    $_POST['satworkjob8']', 
    satreghours8 = '
    $_POST['satreghours8']', 
    satovertime8 = '
    $_POST['satovertime8']', 
    satlaborcode9 = '
    $_POST['satlaborcode9']', 
    satexchange9 = '
    $_POST['satexchange9']', 
    satworkjob9 = '
    $_POST['satworkjob9']', 
    satreghours9 = '
    $_POST['satreghours9']', 
    satovertime9 = '
    $_POST['satovertime9']', 
    sunlaborcode0 = '
    $_POST['sunlaborcode0']', 
    sunexchange0 = '
    $_POST['sunexchange0']', 
    sunworkjob0 = '
    $_POST['sunworkjob0']', 
    sunreghours0 = '
    $_POST['sunreghours0']', 
    sunovertime0 = '
    $_POST['sunovertime0']', 
    sunlaborcode1 = '
    $_POST['sunlaborcode1']', 
    sunexchange1 = '
    $_POST['sunexchange1']', 
    sunworkjob1 = '
    $_POST['sunworkjob1']', 
    sunreghours1 = '
    $_POST['sunreghours1']', 
    sunovertime1 = '
    $_POST['sunovertime1']', 
    sunlaborcode2 = '
    $_POST['sunlaborcode2']', 
    sunexchange2 = '
    $_POST['sunexchange2']', 
    sunworkjob2 = '
    $_POST['sunworkjob2']', 
    sunreghours2 = '
    $_POST['sunreghours2']', 
    sunovertime2 = '
    $_POST['sunovertime2']', 
    sunlaborcode3 = '
    $_POST['sunlaborcode3']', 
    sunexchange3 = '
    $_POST['sunexchange3']', 
    sunworkjob3 = '
    $_POST['sunworkjob3']', 
    sunreghours3 = '
    $_POST['sunreghours3']', 
    sunovertime3 = '
    $_POST['sunovertime3']', 
    sunlaborcode4 = '
    $_POST['sunlaborcode4']', 
    sunexchange4 = '
    $_POST['sunexchange4']', 
    sunworkjob4 = '
    $_POST['sunworkjob4']', 
    sunreghours4 = '
    $_POST['sunreghours4']', 
    sunovertime4 = '
    $_POST['sunovertime4']', 
    sunlaborcode5 = '
    $_POST['sunlaborcode5']', 
    sunexchange5 = '
    $_POST['sunexchange5']', 
    sunworkjob5 = '
    $_POST['sunworkjob5']', 
    sunreghours5 = '
    $_POST['sunreghours5']', 
    sunovertime5 = '
    $_POST['sunovertime5']', 
    sunlaborcode6 = '
    $_POST['sunlaborcode6']', 
    sunexchange6 = '
    $_POST['sunexchange6']', 
    sunworkjob6 = '
    $_POST['sunworkjob6']', 
    sunreghours6 = '
    $_POST['sunreghours6']', 
    sunovertime6 = '
    $_POST['sunovertime6']', 
    sunlaborcode7 = '
    $_POST['sunlaborcode7']', 
    sunexchange7 = '
    $_POST['sunexchange7']', 
    sunworkjob7 = '
    $_POST['sunworkjob7']', 
    sunreghours7 = '
    $_POST['sunreghours7']', 
    sunovertime7 = '
    $_POST['sunovertime7']', 
    sunlaborcode8 = '
    $_POST['sunlaborcode8']', 
    sunexchange8 = '
    $_POST['sunexchange8']', 
    sunworkjob8 = '
    $_POST['sunworkjob8']', 
    sunreghours8 = '
    $_POST['sunreghours8']', 
    sunovertime8 = '
    $_POST['sunovertime8']', 
    sunlaborcode9 = '
    $_POST['sunlaborcode9']', 
    sunexchange9 = '
    $_POST['sunexchange9']', 
    sunworkjob9 = '
    $_POST['sunworkjob9']', 
    sunreghours9 = '
    $_POST['sunreghours9']', 
    sunovertime9 = '
    $_POST['sunovertime9']', 
    summlaborcode0 = '
    $_POST['summlaborcode0']', 
    summexchange0 = '
    $_POST['summexchange0']', 
    summworkjob0 = '
    $_POST['summworkjob0']', 
    summreghours0 = '
    $_POST['summreghours0']', 
    summovertime0 = '
    $_POST['summovertime0']', 
    summlaborcode1 = '
    $_POST['summlaborcode1']', 
    summexchange1 = '
    $_POST['summexchange1']', 
    summworkjob1 = '
    $_POST['summworkjob1']', 
    summreghours1 = '
    $_POST['summreghours1']', 
    summovertime1 = '
    $_POST['summovertime1']', 
    summlaborcode2 = '
    $_POST['summlaborcode2']', 
    summexchange2 = '
    $_POST['summexchange2']', 
    summworkjob2 = '
    $_POST['summworkjob2']', 
    summreghours2 = '
    $_POST['summreghours2']', 
    summovertime2 = '
    $_POST['summovertime2']', 
    summlaborcode3 = '
    $_POST['summlaborcode3']', 
    summexchange3 = '
    $_POST['summexchange3']', 
    summworkjob3 = '
    $_POST['summworkjob3']', 
    summreghours3 = '
    $_POST['summreghours3']', 
    summovertime3 = '
    $_POST['summovertime3']', 
    summlaborcode4 = '
    $_POST['summlaborcode4']', 
    summexchange4 = '
    $_POST['summexchange4']', 
    summworkjob4 = '
    $_POST['summworkjob4']', 
    summreghours4 = '
    $_POST['summreghours4']', 
    summovertime4 = '
    $_POST['summovertime4']', 
    summlaborcode5 = '
    $_POST['summlaborcode5']', 
    summexchange5 = '
    $_POST['summexchange5']', 
    summworkjob5 = '
    $_POST['summworkjob5']', 
    summreghours5 = '
    $_POST['summreghours5']', 
    summovertime5 = '
    $_POST['summovertime5']', 
    summlaborcode6 = '
    $_POST['summlaborcode6']', 
    summexchange6 = '
    $_POST['summexchange6']', 
    summworkjob6 = '
    $_POST['summworkjob6']', 
    summreghours6 = '
    $_POST['summreghours6']', 
    summovertime6 = '
    $_POST['summovertime6']', 
    summlaborcode7 = '
    $_POST['summlaborcode7']', 
    summexchange7 = '
    $_POST['summexchange7']', 
    summworkjob7 = '
    $_POST['summworkjob7']', 
    summreghours7 = '
    $_POST['summreghours7']', 
    summovertime7 = '
    $_POST['summovertime7']', 
    summlaborcode8 = '
    $_POST['summlaborcode8']', 
    summexchange8 = '
    $_POST['summexchange8']', 
    summworkjob8 = '
    $_POST['summworkjob8']', 
    summreghours8 = '
    $_POST['summreghours8']', 
    summovertime8 = '
    $_POST['summovertime8']', 
    summlaborcode9 = '
    $_POST['summlaborcode9']', 
    summexchange9 = '
    $_POST['summexchange9']', 
    summworkjob9 = '
    $_POST['summworkjob9']', 
    summreghours9 = '
    $_POST['summreghours9']', 
    summovertime9 = '
    $_POST['summovertime9'



    Where username $_SESSION[user_name];'; mysql_query($query2); 

  6. #6
    . shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    Is that your table...my god...you need to seriously rethink the design of that table.

    PHP Code:
    $query mysql_query('SELECT * WHERE username = $_SESSION[user_name]'); 
    This SQL statement is missing "FROM tablename"
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.


  7. #7
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That is my table, I didn't make it modular for a reason that is really hard to explain. So there is no rethinking.

  8. #8
    . shoooo... silver trophy logic_earth's Avatar
    Join Date
    Oct 2005
    Location
    CA
    Posts
    9,013
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)
    A reason hard to explain is not an excuse, it is not about being modular it is about being able to maintain and keep data integrity.

    I am serious when I tell you, you need to redesign your database that code you have now is just far too much to go through.

    This is how errors and problems happen. Far too complex code and data structures.
    Logic without the fatal effects.
    All code snippets are licensed under WTFPL.


  9. #9
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There are still more errors. It's showing a blank page.

  10. #10
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I understand your reasoning behind making it simpler, however I can not do that at this point. Perhaps I can go clean up the code later. I just need to get this ironed out first. Thanks for your understanding.

  11. #11
    SitePoint Evangelist
    Join Date
    Feb 2005
    Posts
    581
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can tell you right now one of your major issues is with your use of quotes. Refactoring that DB may actually be the best way to figure out and fix your problems. Until you do some refactoring, I will not touch your code with a ten foot pole.
    I will not flame the newbies,
    I will not flame the newbies,
    I will flame the newbies...
    Table free is the way to be!

  12. #12
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know the quotes are all right in the insert statement, it's just the update statement where the problems are I bet.

    What if I gave you a 12 foot pole?

  13. #13
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Still need help on this.

  14. #14
    SitePoint Zealot
    Join Date
    May 2007
    Location
    West Midlands, UK
    Posts
    173
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The quotes are an issue. You really need to rethink and redesign what your doing.

    Code:
    summlaborcode9 = '$_POST['summlaborcode9']',
    should be

    Code:
    summlaborcode9 = "$_POST['summlaborcode9']",

  15. #15
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,807
    Mentioned
    158 Post(s)
    Tagged
    3 Thread(s)
    OK, I'm not going to mention the table design, you know it's not the best way...
    But your quotes really are a problem, you also have some variables in the second $query2 statement.

    I have reformatted the code, see if it runs
    PHP Code:
    <?php
    $query 
    mysql_query("SELECT * WHERE username = '" $_SESSION['user_name'] ."'") or die(mysql_error()); 
        if (
    mysql_num_rows($query) == 0)) {
        
    $query2 "INSERT INTO timesheet (username, monlaborcode0, monexchange0, monworkjob0, monreghours0, monovertime0, monlaborcode1, monexchange1, monworkjob1, monreghours1, monovertime1, monlaborcode2, monexchange2, monworkjob2, monreghours2, monovertime2, monlaborcode3, monexchange3, monworkjob3, monreghours3, monovertime3, monlaborcode4, monexchange4, monworkjob4, monreghours4, monovertime4, monlaborcode5, monexchange5, monworkjob5, monreghours5, monovertime5, monlaborcode6, monexchange6, monworkjob6, monreghours6, monovertime6, monlaborcode7, monexchange7, monworkjob7, monreghours7, monovertime7, monlaborcode8, monexchange8, monworkjob8, monreghours8, monovertime8, monlaborcode9, monexchange9, monworkjob9, monreghours9, monovertime9, tueslaborcode0, tuesexchange0, tuesworkjob0, tuesreghours0, tuesovertime0, tueslaborcode1, tuesexchange1, tuesworkjob1, tuesreghours1, tuesovertime1, tueslaborcode2, tuesexchange2, tuesworkjob2, tuesreghours2, tuesovertime2, tueslaborcode3, tuesexchange3, tuesworkjob3, tuesreghours3, tuesovertime3, tueslaborcode4, tuesexchange4, tuesworkjob4, tuesreghours4, tuesovertime4, tueslaborcode5, tuesexchange5, tuesworkjob5, tuesreghours5, tuesovertime5, tueslaborcode6, tuesexchange6, tuesworkjob6, tuesreghours6, tuesovertime6, tueslaborcode7, tuesexchange7, tuesworkjob7, tuesreghours7, tuesovertime7, tueslaborcode8, tuesexchange8, tuesworkjob8, tuesreghours8, tuesovertime8, tueslaborcode9, tuesexchange9, tuesworkjob9, tuesreghours9, tuesovertime9, wedlaborcode0, wedexchange0, wedworkjob0, wedreghours0, wedovertime0, wedlaborcode1, wedexchange1, wedworkjob1, wedreghours1, wedovertime1, wedlaborcode2, wedexchange2, wedworkjob2, wedreghours2, wedovertime2, wedlaborcode3, wedexchange3, wedworkjob3, wedreghours3, wedovertime3, wedlaborcode4, wedexchange4, wedworkjob4, wedreghours4, wedovertime4, wedlaborcode5, wedexchange5, wedworkjob5, wedreghours5, wedovertime5, wedlaborcode6, wedexchange6, wedworkjob6, wedreghours6, wedovertime6, wedlaborcode7, wedexchange7, wedworkjob7, wedreghours7, wedovertime7, wedlaborcode8, wedexchange8, wedworkjob8, wedreghours8, wedovertime8, wedlaborcode9, wedexchange9, wedworkjob9, wedreghours9, wedovertime9, thurslaborcode0, thursexchange0, thursworkjob0, thursreghours0, thursovertime0, thurslaborcode1, thursexchange1, thursworkjob1, thursreghours1, thursovertime1, thurslaborcode2, thursexchange2, thursworkjob2, thursreghours2, thursovertime2, thurslaborcode3, thursexchange3, thursworkjob3, thursreghours3, thursovertime3, thurslaborcode4, thursexchange4, thursworkjob4, thursreghours4, thursovertime4, thurslaborcode5, thursexchange5, thursworkjob5, thursreghours5, thursovertime5, thurslaborcode6, thursexchange6, thursworkjob6, thursreghours6, thursovertime6, thurslaborcode7, thursexchange7, thursworkjob7, thursreghours7, thursovertime7, thurslaborcode8, thursexchange8, thursworkjob8, thursreghours8, thursovertime8, thurslaborcode9, thursexchange9, thursworkjob9, thursreghours9,thursovertime9, frilaborcode0, friexchange0, friworkjob0, frireghours0, friovertime0, frilaborcode1, friexchange1, friworkjob1, frireghours1, friovertime1, frilaborcode2, friexchange2, friworkjob2, frireghours2, friovertime2, frilaborcode3, friexchange3, friworkjob3, frireghours3, friovertime3, frilaborcode4, friexchange4, friworkjob4, frireghours4, friovertime4, frilaborcode5, friexchange5, friworkjob5, frireghours5, friovertime5, frilaborcode6, friexchange6, friworkjob6, frireghours6, friovertime6, frilaborcode7, friexchange7, friworkjob7, frireghours7, friovertime7, frilaborcode8, friexchange8, friworkjob8, frireghours8, friovertime8, frilaborcode9, friexchange9, friworkjob9, frireghours9, friovertime9, satlaborcode0, satexchange0, satworkjob0, satreghours0, satovertime0, satlaborcode1, satexchange1, satworkjob1, satreghours1, satovertime1, satlaborcode2, satexchange2, satworkjob2, satreghours2, satovertime2, satlaborcode3, satexchange3, satworkjob3, satreghours3, satovertime3, satlaborcode4, satexchange4, satworkjob4, satreghours4, satovertime4, satlaborcode5, satexchange5, satworkjob5, satreghours5, satovertime5, satlaborcode6, satexchange6, satworkjob6, satreghours6, satovertime6, satlaborcode7, satexchange7, satworkjob7, satreghours7, satovertime7, satlaborcode8, satexchange8, satworkjob8, satreghours8, satovertime8, satlaborcode9, satexchange9, satworkjob9, satreghours9, satovertime9, sunlaborcode0, sunexchange0, sunworkjob0, sunreghours0, sunovertime0, sunlaborcode1, sunexchange1, sunworkjob1, sunreghours1, sunovertime1, sunlaborcode2, sunexchange2, sunworkjob2, sunreghours2, sunovertime2, sunlaborcode3, sunexchange3, sunworkjob3, sunreghours3, sunovertime3, sunlaborcode4, sunexchange4, sunworkjob4, sunreghours4, sunovertime4, sunlaborcode5, sunexchange5, sunworkjob5, sunreghours5,sunovertime5, sunlaborcode6, sunexchange6, sunworkjob6, sunreghours6, sunovertime6, sunlaborcode7, sunexchange7, sunworkjob7, sunreghours7, sunovertime7, sunlaborcode8, sunexchange8, sunworkjob8, sunreghours8, sunovertime8, sunlaborcode9, sunexchange9, sunworkjob9, sunreghours9, sunovertime9, summlaborcode0, summexchange0, summworkjob0, summreghours0, summovertime0, summlaborcode1, summexchange1, summworkjob1, summreghours1, summovertime1, summlaborcode2, summexchange2, summworkjob2, summreghours2, summovertime2, summlaborcode3, summexchange3, summworkjob3, summreghours3, summovertime3, summlaborcode4, summexchange4, summworkjob4, summreghours4, summovertime4, summlaborcode5, summexchange5, summworkjob5, summreghours5, summovertime5, summlaborcode6, summexchange6, summworkjob6, summreghours6, summovertime6, summlaborcode7, summexchange7, summworkjob7, summreghours7, summovertime7, summlaborcode8, summexchange8, summworkjob8, summreghours8, summovertime8, summlaborcode9, summexchange9, summworkjob9, summreghours9, summovertime9) VALUES ('"$_SESSION['user_name'] ."', '"$monlaborcode0 ."', '"$monexchange0 ."', '"$monworkjob0 ."', '"$monreghours0 ."', '"$monovertime0 ."', '"$monlaborcode1', '$monexchange1 ."', '"$monworkjob1 ."', '"$monreghours1 ."', '"$monovertime1 ."', '"$monlaborcode2 ."', '"$monexchange2 ."', '"$monworkjob2 ."', '"$monreghours2 ."', '"$monovertime2 ."', '"$monlaborcode3 ."', '"$monexchange3 ."', '"$monworkjob3 ."', '"$monreghours3 ."', '"$monovertime3 ."', '"$monlaborcode4 ."', '"$monexchange4 ."', '"$monworkjob4 ."', '"$monreghours4 ."', '"$monovertime4 ."', '"$monlaborcode5 ."', '"$monexchange5 ."', '"$monworkjob5 ."', '"$monreghours5 ."', '"$monovertime5 ."', '"$monlaborcode6 ."', '"$monexchange6 ."', '"$monworkjob6 ."', '"$monreghours6 ."', '"$monovertime6 ."', '"$monlaborcode7 ."', '"$monexchange7 ."', '"$monworkjob7 ."', '"$monreghours7 ."', '"$monovertime7 ."', '"$monlaborcode8 ."', '"$monexchange8 ."', '"$monworkjob8 ."', '"$monreghours8 ."', '"$monovertime8 ."', '"$monlaborcode9 ."', '"$monexchange9 ."', '"$monworkjob9 ."', '"$monreghours9 ."', '"$monovertime9 ."', '"$tueslaborcode0 ."', '"$tuesexchange0 ."', '"$tuesworkjob0 ."', '"$tuesreghours0 ."', '"$tuesovertime0 ."', '"$tueslaborcode1 ."', '"$tuesexchange1 ."', '"$tuesworkjob1 ."', '"$tuesreghours1 ."', '"$tuesovertime1 ."', '"$tueslaborcode2 ."', '"$tuesexchange2 ."', '"$tuesworkjob2 ."', '"$tuesreghours2 ."', '"$tuesovertime2 ."', '"$tueslaborcode3 ."', '"$tuesexchange3 ."', '"$tuesworkjob3 ."', '"$tuesreghours3 ."', '"$tuesovertime3 ."', '"$tueslaborcode4 ."', '"$tuesexchange4 ."', '"$tuesworkjob4 ."', '"$tuesreghours4 ."', '"$tuesovertime4 ."', '"$tueslaborcode5 ."', '"$tuesexchange5 ."', '"$tuesworkjob5 ."', '"$tuesreghours5 ."', '"$tuesovertime5 ."', '"$tueslaborcode6 ."', '"$tuesexchange6 ."', '"$tuesworkjob6 ."', '"$tuesreghours6 ."', '"$tuesovertime6 ."', '"$tueslaborcode7 ."', '"$tuesexchange7 ."', '"$tuesworkjob7 ."', '"$tuesreghours7 ."', '"$tuesovertime7 ."', '"$tueslaborcode8 ."', '"$tuesexchange8 ."', '"$tuesworkjob8 ."', '"$tuesreghours8 ."', '"$tuesovertime8 ."', '"$tueslaborcode9 ."', '"$tuesexchange9 ."', '"$tuesworkjob9 ."', '"$tuesreghours9 ."', '"$tuesovertime9 ."', '"$wedlaborcode0 ."', '"$wedexchange0 ."', '"$wedworkjob0 ."', '"$wedreghours0 ."', '"$wedovertime0 ."', '"$wedlaborcode1 ."', '"$wedexchange1 ."', '"$wedworkjob1 ."', '"$wedreghours1 ."', '"$wedovertime1 ."', '"$wedlaborcode2 ."', '"$wedexchange2 ."', '"$wedworkjob2 ."', '"$wedreghours2 ."', '"$wedovertime2 ."', '"$wedlaborcode3 ."', '"$wedexchange3 ."', '"$wedworkjob3 ."', '"$wedreghours3 ."', '"$wedovertime3 ."', '"$wedlaborcode4 ."', '"$wedexchange4 ."', '"$wedworkjob4 ."', '"$wedreghours4 ."', '"$wedovertime4 ."', '"$wedlaborcode5 ."', '"$wedexchange5 ."', '"$wedworkjob5 ."', '"$wedreghours5 ."', '"$wedovertime5 ."', '"$wedlaborcode6 ."', '"$wedexchange6 ."', '"$wedworkjob6 ."', '"$wedreghours6 ."', '"$wedovertime6 ."', '"$wedlaborcode7 ."', '"$wedexchange7 ."', '"$wedworkjob7 ."', '"$wedreghours7 ."', '"$wedovertime7 ."', '"$wedlaborcode8 ."', '"$wedexchange8 ."', '"$wedworkjob8 ."', '"$wedreghours8 ."', '"$wedovertime8 ."', '"$wedlaborcode9 ."', '"$wedexchange9 ."', '"$wedworkjob9 ."', '"$wedreghours9 ."', '"$wedovertime9 ."', '"$thurslaborcode0 ."', '"$thursexchange0 ."', '"$thursworkjob0 ."', '"$thursreghours0 ."', '"$thursovertime0 ."', '"$thurslaborcode1 ."', '"$thursexchange1 ."', '"$thursworkjob1 ."', '"$thursreghours1 ."', '"$thursovertime1 ."', '"$thurslaborcode2 ."', '"$thursexchange2 ."', '"$thursworkjob2 ."', '"$thursreghours2 ."', '"$thursovertime2 ."', '"$thurslaborcode3 ."', '"$thursexchange3 ."', '"$thursworkjob3 ."', '"$thursreghours3 ."', '"$thursovertime3 ."', '"$thurslaborcode4 ."', '"$thursexchange4 ."', '"$thursworkjob4 ."', '"$thursreghours4 ."', '"$thursovertime4 ."', '"$thurslaborcode5 ."', '"$thursexchange5 ."', '"$thursworkjob5 ."', '"$thursreghours5 ."', '"$thursovertime5 ."', '"$thurslaborcode6 ."', '"$thursexchange6 ."', '"$thursworkjob6 ."', '"$thursreghours6 ."', '"$thursovertime6 ."', '"$thurslaborcode7 ."', '"$thursexchange7 ."', '"$thursworkjob7 ."', '"$thursreghours7 ."', '"$thursovertime7 ."', '"$thurslaborcode8 ."', '"$thursexchange8 ."', '"$thursworkjob8 ."', '"$thursreghours8 ."', '"$thursovertime8 ."', '"$thurslaborcode9 ."', '"$thursexchange9 ."', '"$thursworkjob9 ."', '"$thursreghours9 ."', '"$thursovertime9 ."', '"$frilaborcode0 ."', '"$friexchange0 ."', '"$friworkjob0 ."', '"$frireghours0 ."', '"$friovertime0 ."', '"$frilaborcode1 ."', '"$friexchange1 ."', '"$friworkjob1 ."', '"$frireghours1 ."', '"$friovertime1 ."', '"$frilaborcode2 ."', '"$friexchange2 ."', '"$friworkjob2 ."', '"$frireghours2 ."', '"$friovertime2 ."', '"$frilaborcode3 ."', '"$friexchange3 ."', '"$friworkjob3 ."', '"$frireghours3 ."', '"$friovertime3 ."', '"$frilaborcode4 ."', '"$friexchange4 ."', '"$friworkjob4 ."', '"$frireghours4 ."', '"$friovertime4 ."', '"$frilaborcode5 ."', '"$friexchange5 ."', '"$friworkjob5 ."', '"$frireghours5 ."', '"$friovertime5 ."', '"$frilaborcode6 ."', '"$friexchange6 ."', '"$friworkjob6 ."', '"$frireghours6 ."', '"$friovertime6 ."', '"$frilaborcode7 ."', '"$friexchange7 ."', '"$friworkjob7 ."', '"$frireghours7 ."', '"$friovertime7 ."', '"$frilaborcode8 ."', '"$friexchange8 ."', '"$friworkjob8 ."', '"$frireghours8 ."', '"$friovertime8 ."', '"$frilaborcode9 ."', '"$friexchange9 ."', '"$friworkjob9 ."', '"$frireghours9 ."', '"$friovertime9 ."', '"$satlaborcode0 ."', '"$satexchange0 ."', '"$satworkjob0 ."', '"$satreghours0 ."', '"$satovertime0 ."', '"$satlaborcode1 ."', '"$satexchange1 ."', '"$satworkjob1 ."', '"$satreghours1 ."', '"$satovertime1 ."', '"$satlaborcode2 ."', '"$satexchange2 ."', '"$satworkjob2 ."', '"$satreghours2 ."', '"$satovertime2 ."', '"$satlaborcode3 ."', '"$satexchange3 ."', '"$satworkjob3 ."', '"$satreghours3 ."', '"$satovertime3 ."', '"$satlaborcode4 ."', '"$satexchange4 ."', '"$satworkjob4 ."', '"$satreghours4 ."', '"$satovertime4 ."', '"$satlaborcode5 ."', '"$satexchange5 ."', '"$satworkjob5 ."', '"$satreghours5 ."', '"$satovertime5 ."', '"$satlaborcode6 ."', '"$satexchange6 ."', '"$satworkjob6 ."', '"$satreghours6 ."', '"$satovertime6 ."', '"$satlaborcode7 ."', '"$satexchange7 ."', '"$satworkjob7 ."', '"$satreghours7 ."', '"$satovertime7 ."', '"$satlaborcode8 ."', '"$satexchange8 ."', '"$satworkjob8 ."', '"$satreghours8 ."', '"$satovertime8 ."', '"$satlaborcode9 ."', '"$satexchange9 ."', '"$satworkjob9 ."', '"$satreghours9 ."', '"$satovertime9 ."', '"$sunlaborcode0 ."', '"$sunexchange0 ."', '"$sunworkjob0 ."', '"$sunreghours0 ."', '"$sunovertime0 ."', '"$sunlaborcode1 ."', '"$sunexchange1 ."', '"$sunworkjob1 ."', '"$sunreghours1 ."', '"$sunovertime1 ."', '"$sunlaborcode2 ."', '"$sunexchange2 ."', '"$sunworkjob2 ."', '"$sunreghours2 ."', '"$sunovertime2 ."', '"$sunlaborcode3 ."', '"$sunexchange3 ."', '"$sunworkjob3 ."', '"$sunreghours3 ."', '"$sunovertime3 ."', '"$sunlaborcode4 ."', '"$sunexchange4 ."', '"$sunworkjob4 ."', '"$sunreghours4 ."', '"$sunovertime4 ."', '"$sunlaborcode5 ."', '"$sunexchange5 ."', '"$sunworkjob5 ."', '"$sunreghours5 ."', '"$sunovertime5 ."', '"$sunlaborcode6 ."', '"$sunexchange6 ."', '"$sunworkjob6 ."', '"$sunreghours6 ."', '"$sunovertime6 ."', '"$sunlaborcode7 ."', '"$sunexchange7 ."', '"$sunworkjob7 ."', '"$sunreghours7 ."', '"$sunovertime7 ."', '"$sunlaborcode8 ."', '"$sunexchange8 ."', '"$sunworkjob8 ."', '"$sunreghours8 ."', '"$sunovertime8 ."', '"$sunlaborcode9 ."', '"$sunexchange9 ."', '"$sunworkjob9 ."', '"$sunreghours9 ."', '"$sunovertime9 ."', '"$summlaborcode0 ."', '"$summexchange0 ."', '"$summworkjob0 ."', '"$summreghours0 ."', '"$summovertime0 ."', '"$summlaborcode1 ."', '"$summexchange1 ."', '"$summworkjob1 ."', '"$summreghours1 ."', '"$summovertime1 ."', '"$summlaborcode2 ."', '"$summexchange2 ."', '"$summworkjob2 ."', '"$summreghours2 ."', '"$summovertime2 ."', '"$summlaborcode3 ."', '"$summexchange3 ."', '"$summworkjob3 ."', '"$summreghours3 ."', '"$summovertime3 ."', '"$summlaborcode4 ."', '"$summexchange4 ."', '"$summworkjob4 ."', '"$summreghours4 ."', '"$summovertime4 ."', '"$summlaborcode5 ."', '"$summexchange5 ."', '"$summworkjob5 ."', '"$summreghours5 ."', '"$summovertime5 ."', '"$summlaborcode6 ."', '"$summexchange6 ."', '"$summworkjob6 ."', '"$summreghours6 ."', '"$summovertime6 ."', '"$summlaborcode7 ."', '"$summexchange7 ."', '"$summworkjob7 ."', '"$summreghours7 ."', '"$summovertime7 ."', '"$summlaborcode8 ."', '"$summexchange8 ."', '"$summworkjob8 ."', '"$summreghours8 ."', '"$summovertime8 ."', '"$summlaborcode9 ."', '"$summexchange9 ."', '"$summworkjob9 ."', '"$summreghours9 ."', '"$summovertime9 ."')"
        } else  {
    $query2 "UPDATE timesheet 
    SET 
    monlaborcode0 = '"
    $_POST['monlaborcode0'] ."', 
    monexchange0 = '"
    $_POST['monexchange0'] ."', 
    monworkjob0 = '"
    $_POST['monworkjob0'] ."', 
    monreghours0 = '"
    $_POST['monreghours0'] ."', 
    monovertime0 = '"
    $_POST['monovertime0'] ."', 
    monlaborcode1 = '"
    $_POST['monlaborcode1'] ."', 
    monexchange1 = '"
    $_POST['monexchange1'] ."', 
    monworkjob1 = '"
    $_POST['monworkjob1'] ."', 
    monreghours1 = '"
    $_POST['monreghours1'] ."', 
    monovertime1 = '"
    $_POST['monovertime1'] ."', 
    monlaborcode2 = '"
    $_POST['monlaborcode2'] ."', 
    monexchange2 = '"
    $_POST['monexchange2'] ."', 
    monworkjob2 = '"
    $_POST['monworkjob2'] ."', 
    monreghours2 = '"
    $_POST['monreghours2'] ."', 
    monovertime2 = '"
    $_POST['monovertime2'] ."', 
    monlaborcode3 = '"
    $_POST['monlaborcode3'] ."', 
    monexchange3 = '"
    $_POST['monexchange3'] ."', 
    monworkjob3 = '"
    $_POST['monworkjob3'] ."', 
    monreghours3 = '"
    $_POST['monreghours3'] ."', 
    monovertime3 = '"
    $_POST['monovertime3'] ."', 
    monlaborcode4 = '"
    $_POST['monlaborcode4'] ."', 
    monexchange4 = '"
    $_POST['monexchange4'] ."', 
    monworkjob4 = '"
    $_POST['monworkjob4'] ."', 
    monreghours4 = '"
    $_POST['monreghours4'] ."', 
    monovertime4 = '"
    $_POST['monovertime4'] ."', 
    monlaborcode5 = '"
    $_POST['monlaborcode5'] ."', 
    monexchange5 = '"
    $_POST['monexchange5'] ."', 
    monworkjob5 = '"
    $_POST['monworkjob5'] ."', 
    monreghours5 = '"
    $_POST['monreghours5'] ."', 
    monovertime5 = '"
    $_POST['monovertime5'] ."', 
    monlaborcode6 = '"
    $_POST['monlaborcode6'] ."', 
    monexchange6 = '"
    $_POST['monexchange6'] ."', 
    monworkjob6 = '"
    $_POST['monworkjob6'] ."', 
    monreghours6 = '"
    $_POST['monreghours6'] ."', 
    monovertime6 = '"
    $_POST['monovertime6'] ."', 
    monlaborcode7 = '"
    $_POST['monlaborcode7'] ."', 
    monexchange7 = '"
    $_POST['monexchange7'] ."', 
    monworkjob7 = '"
    $_POST['monworkjob7'] ."', 
    monreghours7 = '"
    $_POST['monreghours7'] ."', 
    monovertime7 = '"
    $_POST['monovertime7'] ."', 
    monlaborcode8 = '"
    $_POST['monlaborcode8'] ."', 
    monexchange8 = '"
    $_POST['monexchange8'] ."', 
    monworkjob8 = '"
    $_POST['monworkjob8'] ."', 
    monreghours8 = '"
    $_POST['monreghours8'] ."', 
    monovertime8 = '"
    $_POST['monovertime8'] ."', 
    monlaborcode9 = '"
    $_POST['monlaborcode9'] ."', 
    monexchange9 = '"
    $_POST['monexchange9'] ."', 
    monworkjob9 = '"
    $_POST['monworkjob9'] ."', 
    monreghours9 = '"
    $_POST['monreghours9'] ."', 
    monovertime9 = '"
    $_POST['monovertime9'] ."', 
    tueslaborcode0 = '"
    $_POST['tueslaborcode0'] ."', 
    tuesexchange0 = '"
    $_POST['tuesexchange0'] ."', 
    tuesworkjob0 = '"
    $_POST['tuesworkjob0'] ."', 
    tuesreghours0 = '"
    $_POST['tuesreghours0'] ."', 
    tuesovertime0 = '"
    $_POST['tuesovertime0'] ."', 
    tueslaborcode1 = '"
    $_POST['tueslaborcode1'] ."', 
    tuesexchange1 = '"
    $_POST['tuesexchange1'] ."', 
    tuesworkjob1 = '"
    $_POST['tuesworkjob1'] ."', 
    tuesreghours1 = '"
    $_POST['tuesreghours1'] ."', 
    tuesovertime1 = '"
    $_POST['tuesovertime1'] ."', 
    tueslaborcode2 = '"
    $_POST['tueslaborcode2'] ."', 
    tuesexchange2 = '"
    $_POST['tuesexchange2'] ."', 
    tuesworkjob2 = '"
    $_POST['tuesworkjob2'] ."', 
    tuesreghours2 = '"
    $_POST['tuesreghours2'] ."', 
    tuesovertime2 = '"
    $_POST['tuesovertime2'] ."', 
    tueslaborcode3 = '"
    $_POST['tueslaborcode3'] ."', 
    tuesexchange3 = '"
    $_POST['tuesexchange3'] ."', 
    tuesworkjob3 = '"
    $_POST['tuesworkjob3'] ."', 
    tuesreghours3 = '"
    $_POST['tuesreghours3'] ."', 
    tuesovertime3 = '"
    $_POST['tuesovertime3'] ."', 
    tueslaborcode4 = '"
    $_POST['tueslaborcode4'] ."', 
    tuesexchange4 = '"
    $_POST['tuesexchange4'] ."', 
    tuesworkjob4 = '"
    $_POST['tuesworkjob4'] ."', 
    tuesreghours4 = '"
    $_POST['tuesreghours4'] ."', 
    tuesovertime4 = '"
    $_POST['tuesovertime4'] ."', 
    tueslaborcode5 = '"
    $_POST['tueslaborcode5'] ."', 
    tuesexchange5 = '"
    $_POST['tuesexchange5'] ."', 
    tuesworkjob5 = '"
    $_POST['tuesworkjob5'] ."', 
    tuesreghours5 = '"
    $_POST['tuesreghours5'] ."', 
    tuesovertime5 = '"
    $_POST['tuesovertime5'] ."', 
    tueslaborcode6 = '"
    $_POST['tueslaborcode6'] ."', 
    tuesexchange6 = '"
    $_POST['tuesexchange6'] ."', 
    tuesworkjob6 = '"
    $_POST['tuesworkjob6'] ."', 
    tuesreghours6 = '"
    $_POST['tuesreghours6'] ."', 
    tuesovertime6 = '"
    $_POST['tuesovertime6'] ."', 
    tueslaborcode7 = '"
    $_POST['tueslaborcode7'] ."', 
    tuesexchange7 = '"
    $_POST['tuesexchange7'] ."', 
    tuesworkjob7 = '"
    $_POST['tuesworkjob7'] ."', 
    tuesreghours7 = '"
    $_POST['tuesreghours7'] ."', 
    tuesovertime7 = '"
    $_POST['tuesovertime7'] ."', 
    tueslaborcode8 = '"
    $_POST['tueslaborcode8'] ."', 
    tuesexchange8 = '"
    $_POST['tuesexchange8'] ."', 
    tuesworkjob8 = '"
    $_POST['tuesworkjob8'] ."', 
    tuesreghours8 = '"
    $_POST['tuesreghours8'] ."', 
    tuesovertime8 = '"
    $_POST['tuesovertime8'] ."', 
    tueslaborcode9 = '"
    $_POST['tueslaborcode9'] ."', 
    tuesexchange9 = '"
    $_POST['tuesexchange9'] ."', 
    tuesworkjob9 = '"
    $_POST['tuesworkjob9'] ."', 
    tuesreghours9 = '"
    $_POST['tuesreghours9'] ."', 
    tuesovertime9 = '"
    $_POST['tuesovertime9'] ."', 
    wedlaborcode0 = '"
    $_POST['wedlaborcode0'] ."', 
    wedexchange0 = '"
    $_POST['wedexchange0'] ."', 
    wedworkjob0 = '"
    $_POST['wedworkjob0'] ."', 
    wedreghours0 = '"
    $_POST['wedreghours0'] ."', 
    wedovertime0 = '"
    $_POST['wedovertime0'] ."', 
    wedlaborcode1 = '"
    $_POST['wedlaborcode1'] ."', 
    wedexchange1 = '"
    $_POST['wedexchange1'] ."', 
    wedworkjob1 = '"
    $_POST['wedworkjob1'] ."', 
    wedreghours1 = '"
    $_POST['wedreghours1'] ."', 
    wedovertime1 = '"
    $_POST['wedovertime1'] ."', 
    wedlaborcode2 = '"
    $_POST['wedlaborcode2'] ."', 
    wedexchange2 = '"
    $_POST['wedexchange2'] ."', 
    wedworkjob2 = '"
    $_POST['wedworkjob2'] ."', 
    wedreghours2 = '"
    $_POST['wedreghours2'] ."', 
    wedovertime2 = '"
    $_POST['wedovertime2'] ."', 
    wedlaborcode3 = '"
    $_POST['wedlaborcode3'] ."', 
    wedexchange3 = '"
    $_POST['wedexchange3'] ."', 
    wedworkjob3 = '"
    $_POST['wedworkjob3'] ."', 
    wedreghours3 = '"
    $_POST['wedreghours3'] ."', 
    wedovertime3 = '"
    $_POST['wedovertime3'] ."', 
    wedlaborcode4 = '"
    $_POST['wedlaborcode4'] ."', 
    wedexchange4 = '"
    $_POST['wedexchange4'] ."', 
    wedworkjob4 = '"
    $_POST['wedworkjob4'] ."', 
    wedreghours4 = '"
    $_POST['wedreghours4'] ."', 
    wedovertime4 = '"
    $_POST['wedovertime4'] ."', 
    wedlaborcode5 = '"
    $_POST['wedlaborcode5'] ."', 
    wedexchange5 = '"
    $_POST['wedexchange5'] ."', 
    wedworkjob5 = '"
    $_POST['wedworkjob5'] ."', 
    wedreghours5 = '"
    $_POST['wedreghours5'] ."', 
    wedovertime5 = '"
    $_POST['wedovertime5'] ."', 
    wedlaborcode6 = '"
    $_POST['wedlaborcode6'] ."', 
    wedexchange6 = '"
    $_POST['wedexchange6'] ."', 
    wedworkjob6 = '"
    $_POST['wedworkjob6'] ."', 
    wedreghours6 = '"
    $_POST['wedreghours6'] ."', 
    wedovertime6 = '"
    $_POST['wedovertime6'] ."', 
    wedlaborcode7 = '"
    $_POST['wedlaborcode7'] ."', 
    wedexchange7 = '"
    $_POST['wedexchange7'] ."', 
    wedworkjob7 = '"
    $_POST['wedworkjob7'] ."', 
    wedreghours7 = '"
    $_POST['wedreghours7'] ."', 
    wedovertime7 = '"
    $_POST['wedovertime7'] ."', 
    wedlaborcode8 = '"
    $_POST['wedlaborcode8'] ."', 
    wedexchange8 = '"
    $_POST['wedexchange8'] ."', 
    wedworkjob8 = '"
    $_POST['wedworkjob8'] ."', 
    wedreghours8 = '"
    $_POST['wedreghours8'] ."', 
    wedovertime8 = '"
    $_POST['wedovertime8'] ."', 
    wedlaborcode9 = '"
    $_POST['wedlaborcode9'] ."', 
    wedexchange9 = '"
    $_POST['wedexchange9'] ."', 
    wedworkjob9 = '"
    $_POST['wedworkjob9'] ."', 
    wedreghours9 = '"
    $_POST['wedreghours9'] ."', 
    wedovertime9 = '"
    $_POST['wedovertime9'] ."', 
    thurslaborcode0 = '"
    $_POST['thurslaborcode0'] ."', 
    thursexchange0 = '"
    $_POST['thursexchange0'] ."', 
    thursworkjob0 = '"
    $_POST['thursworkjob0'] ."', 
    thursreghours0 = '"
    $_POST['thursreghours0'] ."', 
    thursovertime0 = '"
    $_POST['thursovertime0'] ."', 
    thurslaborcode1 = '"
    $_POST['thurslaborcode1'] ."', 
    thursexchange1 = '"
    $_POST['thursexchange1'] ."', 
    thursworkjob1 = '"
    $_POST['thursworkjob1'] ."', 
    thursreghours1 = '"
    $_POST['thursreghours1'] ."', 
    thursovertime1 = '"
    $_POST['thursovertime1'] ."', 
    thurslaborcode2 = '"
    $_POST['thurslaborcode2'] ."', 
    thursexchange2 = '"
    $_POST['thursexchange2'] ."', 
    thursworkjob2 = '"
    $_POST['thursworkjob2'] ."', 
    thursreghours2 = '"
    $_POST['thursreghours2'] ."', 
    thursovertime2 = '"
    $_POST['thursovertime2'] ."', 
    thurslaborcode3 = '"
    $_POST['thurslaborcode3'] ."', 
    thursexchange3 = '"
    $_POST['thursexchange3'] ."', 
    thursworkjob3 = '"
    $_POST['thursworkjob3'] ."', 
    thursreghours3 = '"
    $_POST['thursreghours3'] ."', 
    thursovertime3 = '"
    $_POST['thursovertime3'] ."', 
    thurslaborcode4 = '"
    $_POST['thurslaborcode4'] ."', 
    thursexchange4 = '"
    $_POST['thursexchange4'] ."', 
    thursworkjob4 = '"
    $_POST['thursworkjob4'] ."', 
    thursreghours4 = '"
    $_POST['thursreghours4'] ."', 
    thursovertime4 = '"
    $_POST['thursovertime4'] ."', 
    thurslaborcode5 = '"
    $_POST['thurslaborcode5'] ."', 
    thursexchange5 = '"
    $_POST['thursexchange5'] ."', 
    thursworkjob5 = '"
    $_POST['thursworkjob5'] ."', 
    thursreghours5 = '"
    $_POST['thursreghours5'] ."', 
    thursovertime5 = '"
    $_POST['thursovertime5'] ."', 
    thurslaborcode6 = '"
    $_POST['thurslaborcode6'] ."', 
    thursexchange6 = '"
    $_POST['thursexchange6'] ."', 
    thursworkjob6 = '"
    $_POST['thursworkjob6'] ."', 
    thursreghours6 = '"
    $_POST['thursreghours6'] ."', 
    thursovertime6 = '"
    $_POST['thursovertime6'] ."', 
    thurslaborcode7 = '"
    $_POST['thurslaborcode7'] ."', 
    thursexchange7 = '"
    $_POST['thursexchange7'] ."', 
    thursworkjob7 = '"
    $_POST['thursworkjob7'] ."', 
    thursreghours7 = '"
    $_POST['thursreghours7'] ."', 
    thursovertime7 = '"
    $_POST['thursovertime7'] ."', 
    thurslaborcode8 = '"
    $_POST['thurslaborcode8'] ."', 
    thursexchange8 = '"
    $_POST['thursexchange8'] ."', 
    thursworkjob8 = '"
    $_POST['thursworkjob8'] ."', 
    thursreghours8 = '"
    $_POST['thursreghours8'] ."', 
    thursovertime8 = '"
    $_POST['thursovertime8'] ."', 
    thurslaborcode9 = '"
    $_POST['thurslaborcode9'] ."', 
    thursexchange9 = '"
    $_POST['thursexchange9'] ."', 
    thursworkjob9 = '"
    $_POST['thursworkjob9'] ."', 
    thursreghours9 = '"
    $_POST['thursreghours9'] ."', 
    thursovertime9 = '"
    $_POST['thursovertime9'] ."', 
    frilaborcode0 = '"
    $_POST['frilaborcode0'] ."', 
    friexchange0 = '"
    $_POST['friexchange0'] ."', 
    friworkjob0 = '"
    $_POST['friworkjob0'] ."', 
    frireghours0 = '"
    $_POST['frireghours0'] ."', 
    friovertime0 = '"
    $_POST['friovertime0'] ."', 
    frilaborcode1 = '"
    $_POST['frilaborcode1'] ."', 
    friexchange1 = '"
    $_POST['friexchange1'] ."', 
    friworkjob1 = '"
    $_POST['friworkjob1'] ."', 
    frireghours1 = '"
    $_POST['frireghours1'] ."', 
    friovertime1 = '"
    $_POST['friovertime1'] ."', 
    frilaborcode2 = '"
    $_POST['frilaborcode2'] ."', 
    friexchange2 = '"
    $_POST['friexchange2'] ."', 
    friworkjob2 = '"
    $_POST['friworkjob2'] ."', 
    frireghours2 = '"
    $_POST['frireghours2'] ."', 
    friovertime2 = '"
    $_POST['friovertime2'] ."', 
    frilaborcode3 = '"
    $_POST['frilaborcode3'] ."', 
    friexchange3 = '"
    $_POST['friexchange3'] ."', 
    friworkjob3 = '"
    $_POST['friworkjob3'] ."', 
    frireghours3 = '"
    $_POST['frireghours3'] ."', 
    friovertime3 = '"
    $_POST['friovertime3'] ."', 
    frilaborcode4 = '"
    $_POST['frilaborcode4'] ."', 
    friexchange4 = '"
    $_POST['friexchange4'] ."', 
    friworkjob4 = '"
    $_POST['friworkjob4'] ."', 
    frireghours4 = '"
    $_POST['frireghours4'] ."', 
    friovertime4 = '"
    $_POST['friovertime4'] ."', 
    frilaborcode5 = '"
    $_POST['frilaborcode5'] ."', 
    friexchange5 = '"
    $_POST['friexchange5'] ."', 
    friworkjob5 = '"
    $_POST['friworkjob5'] ."', 
    frireghours5 = '"
    $_POST['frireghours5'] ."', 
    friovertime5 = '"
    $_POST['friovertime5'] ."', 
    frilaborcode6 = '"
    $_POST['frilaborcode6'] ."', 
    friexchange6 = '"
    $_POST['friexchange6'] ."', 
    friworkjob6 = '"
    $_POST['friworkjob6'] ."', 
    frireghours6 = '"
    $_POST['frireghours6'] ."', 
    friovertime6 = '"
    $_POST['friovertime6'] ."', 
    frilaborcode7 = '"
    $_POST['frilaborcode7'] ."', 
    friexchange7 = '"
    $_POST['friexchange7'] ."', 
    friworkjob7 = '"
    $_POST['friworkjob7'] ."', 
    frireghours7 = '"
    $_POST['frireghours7'] ."', 
    friovertime7 = '"
    $_POST['friovertime7'] ."', 
    frilaborcode8 = '"
    $_POST['frilaborcode8'] ."', 
    friexchange8 = '"
    $_POST['friexchange8'] ."', 
    friworkjob8 = '"
    $_POST['friworkjob8'] ."', 
    frireghours8 = '"
    $_POST['frireghours8'] ."', 
    friovertime8 = '"
    $_POST['friovertime8'] ."', 
    frilaborcode9 = '"
    $_POST['frilaborcode9'] ."', 
    friexchange9 = '"
    $_POST['friexchange9'] ."', 
    friworkjob9 = '"
    $_POST['friworkjob9'] ."', 
    frireghours9 = '"
    $_POST['frireghours9'] ."', 
    friovertime9 = '"
    $_POST['friovertime9'] ."', 
    satlaborcode0 = '"
    $_POST['satlaborcode0'] ."', 
    satexchange0 = '"
    $_POST['satexchange0'] ."', 
    satworkjob0 = '"
    $_POST['satworkjob0'] ."', 
    satreghours0 = '"
    $_POST['satreghours0'] ."', 
    satovertime0 = '"
    $_POST['satovertime0'] ."', 
    satlaborcode1 = '"
    $_POST['satlaborcode1'] ."', 
    satexchange1 = '"
    $_POST['satexchange1'] ."', 
    satworkjob1 = '"
    $_POST['satworkjob1'] ."', 
    satreghours1 = '"
    $_POST['satreghours1'] ."', 
    satovertime1 = '"
    $_POST['satovertime1'] ."', 
    satlaborcode2 = '"
    $_POST['satlaborcode2'] ."', 
    satexchange2 = '"
    $_POST['satexchange2'] ."', 
    satworkjob2 = '"
    $_POST['satworkjob2'] ."', 
    satreghours2 = '"
    $_POST['satreghours2'] ."', 
    satovertime2 = '"
    $_POST['satovertime2'] ."', 
    satlaborcode3 = '"
    $_POST['satlaborcode3'] ."', 
    satexchange3 = '"
    $_POST['satexchange3'] ."', 
    satworkjob3 = '"
    $_POST['satworkjob3'] ."', 
    satreghours3 = '"
    $_POST['satreghours3'] ."', 
    satovertime3 = '"
    $_POST['satovertime3'] ."', 
    satlaborcode4 = '"
    $_POST['satlaborcode4'] ."', 
    satexchange4 = '"
    $_POST['satexchange4'] ."', 
    satworkjob4 = '"
    $_POST['satworkjob4'] ."', 
    satreghours4 = '"
    $_POST['satreghours4'] ."', 
    satovertime4 = '"
    $_POST['satovertime4'] ."', 
    satlaborcode5 = '"
    $_POST['satlaborcode5'] ."', 
    satexchange5 = '"
    $_POST['satexchange5'] ."', 
    satworkjob5 = '"
    $_POST['satworkjob5'] ."', 
    satreghours5 = '"
    $_POST['satreghours5'] ."', 
    satovertime5 = '"
    $_POST['satovertime5'] ."', 
    satlaborcode6 = '"
    $_POST['satlaborcode6'] ."', 
    satexchange6 = '"
    $_POST['satexchange6'] ."', 
    satworkjob6 = '"
    $_POST['satworkjob6'] ."', 
    satreghours6 = '"
    $_POST['satreghours6'] ."', 
    satovertime6 = '"
    $_POST['satovertime6'] ."', 
    satlaborcode7 = '"
    $_POST['satlaborcode7'] ."', 
    satexchange7 = '"
    $_POST['satexchange7'] ."', 
    satworkjob7 = '"
    $_POST['satworkjob7'] ."', 
    satreghours7 = '"
    $_POST['satreghours7'] ."', 
    satovertime7 = '"
    $_POST['satovertime7'] ."', 
    satlaborcode8 = '"
    $_POST['satlaborcode8'] ."', 
    satexchange8 = '"
    $_POST['satexchange8'] ."', 
    satworkjob8 = '"
    $_POST['satworkjob8'] ."', 
    satreghours8 = '"
    $_POST['satreghours8'] ."', 
    satovertime8 = '"
    $_POST['satovertime8'] ."', 
    satlaborcode9 = '"
    $_POST['satlaborcode9'] ."', 
    satexchange9 = '"
    $_POST['satexchange9'] ."', 
    satworkjob9 = '"
    $_POST['satworkjob9'] ."', 
    satreghours9 = '"
    $_POST['satreghours9'] ."', 
    satovertime9 = '"
    $_POST['satovertime9'] ."', 
    sunlaborcode0 = '"
    $_POST['sunlaborcode0'] ."', 
    sunexchange0 = '"
    $_POST['sunexchange0'] ."', 
    sunworkjob0 = '"
    $_POST['sunworkjob0'] ."', 
    sunreghours0 = '"
    $_POST['sunreghours0'] ."', 
    sunovertime0 = '"
    $_POST['sunovertime0'] ."', 
    sunlaborcode1 = '"
    $_POST['sunlaborcode1'] ."', 
    sunexchange1 = '"
    $_POST['sunexchange1'] ."', 
    sunworkjob1 = '"
    $_POST['sunworkjob1'] ."', 
    sunreghours1 = '"
    $_POST['sunreghours1'] ."', 
    sunovertime1 = '"
    $_POST['sunovertime1'] ."', 
    sunlaborcode2 = '"
    $_POST['sunlaborcode2'] ."', 
    sunexchange2 = '"
    $_POST['sunexchange2'] ."', 
    sunworkjob2 = '"
    $_POST['sunworkjob2'] ."', 
    sunreghours2 = '"
    $_POST['sunreghours2'] ."', 
    sunovertime2 = '"
    $_POST['sunovertime2'] ."', 
    sunlaborcode3 = '"
    $_POST['sunlaborcode3'] ."', 
    sunexchange3 = '"
    $_POST['sunexchange3'] ."', 
    sunworkjob3 = '"
    $_POST['sunworkjob3'] ."', 
    sunreghours3 = '"
    $_POST['sunreghours3'] ."', 
    sunovertime3 = '"
    $_POST['sunovertime3'] ."', 
    sunlaborcode4 = '"
    $_POST['sunlaborcode4'] ."', 
    sunexchange4 = '"
    $_POST['sunexchange4'] ."', 
    sunworkjob4 = '"
    $_POST['sunworkjob4'] ."', 
    sunreghours4 = '"
    $_POST['sunreghours4'] ."', 
    sunovertime4 = '"
    $_POST['sunovertime4'] ."', 
    sunlaborcode5 = '"
    $_POST['sunlaborcode5'] ."', 
    sunexchange5 = '"
    $_POST['sunexchange5'] ."', 
    sunworkjob5 = '"
    $_POST['sunworkjob5'] ."', 
    sunreghours5 = '"
    $_POST['sunreghours5'] ."', 
    sunovertime5 = '"
    $_POST['sunovertime5'] ."', 
    sunlaborcode6 = '"
    $_POST['sunlaborcode6'] ."', 
    sunexchange6 = '"
    $_POST['sunexchange6'] ."', 
    sunworkjob6 = '"
    $_POST['sunworkjob6'] ."', 
    sunreghours6 = '"
    $_POST['sunreghours6'] ."', 
    sunovertime6 = '"
    $_POST['sunovertime6'] ."', 
    sunlaborcode7 = '"
    $_POST['sunlaborcode7'] ."', 
    sunexchange7 = '"
    $_POST['sunexchange7'] ."', 
    sunworkjob7 = '"
    $_POST['sunworkjob7'] ."', 
    sunreghours7 = '"
    $_POST['sunreghours7'] ."', 
    sunovertime7 = '"
    $_POST['sunovertime7'] ."', 
    sunlaborcode8 = '"
    $_POST['sunlaborcode8'] ."', 
    sunexchange8 = '"
    $_POST['sunexchange8'] ."', 
    sunworkjob8 = '"
    $_POST['sunworkjob8'] ."', 
    sunreghours8 = '"
    $_POST['sunreghours8'] ."', 
    sunovertime8 = '"
    $_POST['sunovertime8'] ."', 
    sunlaborcode9 = '"
    $_POST['sunlaborcode9'] ."', 
    sunexchange9 = '"
    $_POST['sunexchange9'] ."', 
    sunworkjob9 = '"
    $_POST['sunworkjob9'] ."', 
    sunreghours9 = '"
    $_POST['sunreghours9'] ."', 
    sunovertime9 = '"
    $_POST['sunovertime9'] ."', 
    summlaborcode0 = '"
    $_POST['summlaborcode0'] ."', 
    summexchange0 = '"
    $_POST['summexchange0'] ."', 
    summworkjob0 = '"
    $_POST['summworkjob0'] ."', 
    summreghours0 = '"
    $_POST['summreghours0'] ."', 
    summovertime0 = '"
    $_POST['summovertime0'] ."', 
    summlaborcode1 = '"
    $_POST['summlaborcode1'] ."', 
    summexchange1 = '"
    $_POST['summexchange1'] ."', 
    summworkjob1 = '"
    $_POST['summworkjob1'] ."', 
    summreghours1 = '"
    $_POST['summreghours1'] ."', 
    summovertime1 = '"
    $_POST['summovertime1'] ."', 
    summlaborcode2 = '"
    $_POST['summlaborcode2'] ."', 
    summexchange2 = '"
    $_POST['summexchange2'] ."', 
    summworkjob2 = '"
    $_POST['summworkjob2'] ."', 
    summreghours2 = '"
    $_POST['summreghours2'] ."', 
    summovertime2 = '"
    $_POST['summovertime2'] ."', 
    summlaborcode3 = '"
    $_POST['summlaborcode3'] ."', 
    summexchange3 = '"
    $_POST['summexchange3'] ."', 
    summworkjob3 = '"
    $_POST['summworkjob3'] ."', 
    summreghours3 = '"
    $_POST['summreghours3'] ."', 
    summovertime3 = '"
    $_POST['summovertime3'] ."', 
    summlaborcode4 = '"
    $_POST['summlaborcode4'] ."', 
    summexchange4 = '"
    $_POST['summexchange4'] ."', 
    summworkjob4 = '"
    $_POST['summworkjob4'] ."', 
    summreghours4 = '"
    $_POST['summreghours4'] ."', 
    summovertime4 = '"
    $_POST['summovertime4'] ."', 
    summlaborcode5 = '"
    $_POST['summlaborcode5'] ."', 
    summexchange5 = '"
    $_POST['summexchange5'] ."', 
    summworkjob5 = '"
    $_POST['summworkjob5'] ."', 
    summreghours5 = '"
    $_POST['summreghours5'] ."', 
    summovertime5 = '"
    $_POST['summovertime5'] ."', 
    summlaborcode6 = '"
    $_POST['summlaborcode6'] ."', 
    summexchange6 = '"
    $_POST['summexchange6'] ."', 
    summworkjob6 = '"
    $_POST['summworkjob6'] ."', 
    summreghours6 = '"
    $_POST['summreghours6'] ."', 
    summovertime6 = '"
    $_POST['summovertime6'] ."', 
    summlaborcode7 = '"
    $_POST['summlaborcode7'] ."', 
    summexchange7 = '"
    $_POST['summexchange7'] ."', 
    summworkjob7 = '"
    $_POST['summworkjob7'] ."', 
    summreghours7 = '"
    $_POST['summreghours7'] ."', 
    summovertime7 = '"
    $_POST['summovertime7'] ."', 
    summlaborcode8 = '"
    $_POST['summlaborcode8'] ."', 
    summexchange8 = '"
    $_POST['summexchange8'] ."', 
    summworkjob8 = '"
    $_POST['summworkjob8'] ."', 
    summreghours8 = '"
    $_POST['summreghours8'] ."', 
    summovertime8 = '"
    $_POST['summovertime8'] ."', 
    summlaborcode9 = '"
    $_POST['summlaborcode9'] ."', 
    summexchange9 = '"
    $_POST['summexchange9'] ."', 
    summworkjob9 = '"
    $_POST['summworkjob9'] ."', 
    summreghours9 = '"
    $_POST['summreghours9'] ."', 
    summovertime9 = '"
    $_POST['summovertime9'] ."'

    Where username = '"
    $_SESSION['user_name'] ."'";
    }
    $query2 mysql_query($query2) or die(mysql_error());
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  16. #16
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Still bombing out.

  17. #17
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    What error messages? Where in the code is it failing? (Which section?)

    For the INSERT query, have the values of $monlaborcode0 etc already been defined previously in the code?
    Ian Anderson
    www.siteguru.co.uk

  18. #18
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The variables have been defined. It's not showing error message at all. Just a blank page.

  19. #19
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Which suggests that the code is fundamentally working, unless you have error_reporting set off. Is there any HTML code that should be displayed? (The SQL part of the code you show would not put any display in the browser).
    Ian Anderson
    www.siteguru.co.uk

  20. #20
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes there is a huge html table, that is not being displayed.

  21. #21
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Can you copy your file, save it as .phps extension then host it online where we can see? (Change/mask any sensitive info like database login/password details etc., then give us the link to the page. This page won't run - it will just show us the PHP code).

    I reckon we need to see the whole thing to have any chance of working out what is the problem.

    Also, you didn't respond as to whether error_reporting was set off. Create a PHP file with only the following in it, then run it on your server - you should see a PHP config page that will tell you the error_reporting setting.

    PHP Code:
    <?php phpinfo() ?>
    Ian Anderson
    www.siteguru.co.uk

  22. #22
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've got it narrowed down for the error:

    If i take out

    PHP Code:
    <?php
    if (!isset($_POST['submit'])) {
    ?>
    At the top of the form, and then the below code at the bottom. It loads. I think it has something do that it starts with an if statement... but then in the below code I don't follow up with an else..

    PHP Code:
    <?php
    $username 
    $_POST['username'];
    $monlaborcode0 $_POST['monlaborcode0'];
    $monexchange0 $_POST['monexchange0'];
    $monworkjob0 $_POST['monworkjob0'];
    $monreghours0 $_POST['monreghours0'];
    $monovertime0 $_POST['monovertime0'];
    $monlaborcode1 $_POST['monlaborcode1'];
    $monexchange1 $_POST['monexchange1'];
    $monworkjob1 $_POST['monworkjob1'];
    $monreghours1 $_POST['monreghours1'];
    $monovertime1 $_POST['monovertime1'];
    $monlaborcode2 $_POST['monlaborcode2'];
    $monexchange2 $_POST['monexchange2'];
    $monworkjob2 $_POST['monworkjob2'];
    $monreghours2 $_POST['monreghours2'];
    $monovertime2 $_POST['monovertime2'];
    $monlaborcode3 $_POST['monlaborcode3'];
    $monexchange3 $_POST['monexchange3'];
    $monworkjob3 $_POST['monworkjob3'];
    $monreghours3 $_POST['monreghours3'];
    $monovertime3 $_POST['monovertime3'];
    $monlaborcode4 $_POST['monlaborcode4'];
    $monexchange4 $_POST['monexchange4'];
    $monworkjob4 $_POST['monworkjob4'];
    $monreghours4 $_POST['monreghours4'];
    $monovertime4 $_POST['monovertime4'];
    $monlaborcode5 $_POST['monlaborcode5'];
    $monexchange5 $_POST['monexchange5'];
    $monworkjob5 $_POST['monworkjob5'];
    $monreghours5 $_POST['monreghours5'];
    $monovertime5 $_POST['monovertime5'];
    $monlaborcode6 $_POST['monlaborcode6'];
    $monexchange6 $_POST['monexchange6'];
    $monworkjob6 $_POST['monworkjob6'];
    $monreghours6 $_POST['monreghours6'];
    $monovertime6 $_POST['monovertime6'];
    $monlaborcode7 $_POST['monlaborcode7'];
    $monexchange7 $_POST['monexchange7'];
    $monworkjob7 $_POST['monworkjob7'];
    $monreghours7 $_POST['monreghours7'];
    $monovertime7 $_POST['monovertime7'];
    $monlaborcode8 $_POST['monlaborcode8'];
    $monexchange8 $_POST['monexchange8'];
    $monworkjob8 $_POST['monworkjob8'];
    $monreghours8 $_POST['monreghours8'];
    $monovertime8 $_POST['monovertime8'];
    $monlaborcode9 $_POST['monlaborcode9'];
    $monexchange9 $_POST['monexchange9'];
    $monworkjob9 $_POST['monworkjob9'];
    $monreghours9 $_POST['monreghours9'];
    $monovertime9 $_POST['monovertime9'];
    $tueslaborcode0 $_POST['tueslaborcode0'];
    $tuesexchange0 $_POST['tuesexchange0'];
    $tuesworkjob0 $_POST['tuesworkjob0'];
    $tuesreghours0 $_POST['tuesreghours0'];
    $tuesovertime0 $_POST['tuesovertime0'];
    $tueslaborcode1 $_POST['tueslaborcode1'];
    $tuesexchange1 $_POST['tuesexchange1'];
    $tuesworkjob1 $_POST['tuesworkjob1'];
    $tuesreghours1 $_POST['tuesreghours1'];
    $tuesovertime1 $_POST['tuesovertime1'];
    $tueslaborcode2 $_POST['tueslaborcode2'];
    $tuesexchange2 $_POST['tuesexchange2'];
    $tuesworkjob2 $_POST['tuesworkjob2'];
    $tuesreghours2 $_POST['tuesreghours2'];
    $tuesovertime2 $_POST['tuesovertime2'];
    $tueslaborcode3 $_POST['tueslaborcode3'];
    $tuesexchange3 $_POST['tuesexchange3'];
    $tuesworkjob3 $_POST['tuesworkjob3'];
    $tuesreghours3 $_POST['tuesreghours3'];
    $tuesovertime3 $_POST['tuesovertime3'];
    $tueslaborcode4 $_POST['tueslaborcode4'];
    $tuesexchange4 $_POST['tuesexchange4'];
    $tuesworkjob4 $_POST['tuesworkjob4'];
    $tuesreghours4 $_POST['tuesreghours4'];
    $tuesovertime4 $_POST['tuesovertime4'];
    $tueslaborcode5 $_POST['tueslaborcode5'];
    $tuesexchange5 $_POST['tuesexchange5'];
    $tuesworkjob5 $_POST['tuesworkjob5'];
    $tuesreghours5 $_POST['tuesreghours5'];
    $tuesovertime5 $_POST['tuesovertime5'];
    $tueslaborcode6 $_POST['tueslaborcode6'];
    $tuesexchange6 $_POST['tuesexchange6'];
    $tuesworkjob6 $_POST['tuesworkjob6'];
    $tuesreghours6 $_POST['tuesreghours6'];
    $tuesovertime6 $_POST['tuesovertime6'];
    $tueslaborcode7 $_POST['tueslaborcode7'];
    $tuesexchange7 $_POST['tuesexchange7'];
    $tuesworkjob7 $_POST['tuesworkjob7'];
    $tuesreghours7 $_POST['tuesreghours7'];
    $tuesovertime7 $_POST['tuesovertime7'];
    $tueslaborcode8 $_POST['tueslaborcode8'];
    $tuesexchange8 $_POST['tuesexchange8'];
    $tuesworkjob8 $_POST['tuesworkjob8'];
    $tuesreghours8 $_POST['tuesreghours8'];
    $tuesovertime8 $_POST['tuesovertime8'];
    $tueslaborcode9 $_POST['tueslaborcode9'];
    $tuesexchange9 $_POST['tuesexchange9'];
    $tuesworkjob9 $_POST['tuesworkjob9'];
    $tuesreghours9 $_POST['tuesreghours9'];
    $tuesovertime9 $_POST['tuesovertime9'];
    $wedlaborcode0 $_POST['wedlaborcode0'];
    $wedexchange0 $_POST['wedexchange0'];
    $wedworkjob0 $_POST['wedworkjob0'];
    $wedreghours0 $_POST['wedreghours0'];
    $wedovertime0 $_POST['wedovertime0'];
    $wedlaborcode1 $_POST['wedlaborcode1'];
    $wedexchange1 $_POST['wedexchange1'];
    $wedworkjob1 $_POST['wedworkjob1'];
    $wedreghours1 $_POST['wedreghours1'];
    $wedovertime1 $_POST['wedovertime1'];
    $wedlaborcode2 $_POST['wedlaborcode2'];
    $wedexchange2 $_POST['wedexchange2'];
    $wedworkjob2 $_POST['wedworkjob2'];
    $wedreghours2 $_POST['wedreghours2'];
    $wedovertime2 $_POST['wedovertime2'];
    $wedlaborcode3 $_POST['wedlaborcode3'];
    $wedexchange3 $_POST['wedexchange3'];
    $wedworkjob3 $_POST['wedworkjob3'];
    $wedreghours3 $_POST['wedreghours3'];
    $wedovertime3 $_POST['wedovertime3'];
    $wedlaborcode4 $_POST['wedlaborcode4'];
    $wedexchange4 $_POST['wedexchange4'];
    $wedworkjob4 $_POST['wedworkjob4'];
    $wedreghours4 $_POST['wedreghours4'];
    $wedovertime4 $_POST['wedovertime4'];
    $wedlaborcode5 $_POST['wedlaborcode5'];
    $wedexchange5 $_POST['wedexchange5'];
    $wedworkjob5 $_POST['wedworkjob5'];
    $wedreghours5 $_POST['wedreghours5'];
    $wedovertime5 $_POST['wedovertime5'];
    $wedlaborcode6 $_POST['wedlaborcode6'];
    $wedexchange6 $_POST['wedexchange6'];
    $wedworkjob6 $_POST['wedworkjob6'];
    $wedreghours6 $_POST['wedreghours6'];
    $wedovertime6 $_POST['wedovertime6'];
    $wedlaborcode7 $_POST['wedlaborcode7'];
    $wedexchange7 $_POST['wedexchange7'];
    $wedworkjob7 $_POST['wedworkjob7'];
    $wedreghours7 $_POST['wedreghours7'];
    $wedovertime7 $_POST['wedovertime7'];
    $wedlaborcode8 $_POST['wedlaborcode8'];
    $wedexchange8 $_POST['wedexchange8'];
    $wedworkjob8 $_POST['wedworkjob8'];
    $wedreghours8 $_POST['wedreghours8'];
    $wedovertime8 $_POST['wedovertime8'];
    $wedlaborcode9 $_POST['wedlaborcode9'];
    $wedexchange9 $_POST['wedexchange9'];
    $wedworkjob9 $_POST['wedworkjob9'];
    $wedreghours9 $_POST['wedreghours9'];
    $wedovertime9 $_POST['wedovertime9'];
    $thurslaborcode0 $_POST['thurslaborcode0'];
    $thursexchange0 $_POST['thursexchange0'];
    $thursworkjob0 $_POST['thursworkjob0'];
    $thursreghours0 $_POST['thursreghours0'];
    $thursovertime0 $_POST['thursovertime0'];
    $thurslaborcode1 $_POST['thurslaborcode1'];
    $thursexchange1 $_POST['thursexchange1'];
    $thursworkjob1 $_POST['thursworkjob1'];
    $thursreghours1 $_POST['thursreghours1'];
    $thursovertime1 $_POST['thursovertime1'];
    $thurslaborcode2 $_POST['thurslaborcode2'];
    $thursexchange2 $_POST['thursexchange2'];
    $thursworkjob2 $_POST['thursworkjob2'];
    $thursreghours2 $_POST['thursreghours2'];
    $thursovertime2 $_POST['thursovertime2'];
    $thurslaborcode3 $_POST['thurslaborcode3'];
    $thursexchange3 $_POST['thursexchange3'];
    $thursworkjob3 $_POST['thursworkjob3'];
    $thursreghours3 $_POST['thursreghours3'];
    $thursovertime3 $_POST['thursovertime3'];
    $thurslaborcode4 $_POST['thurslaborcode4'];
    $thursexchange4 $_POST['thursexchange4'];
    $thursworkjob4 $_POST['thursworkjob4'];
    $thursreghours4 $_POST['thursreghours4'];
    $thursovertime4 $_POST['thursovertime4'];
    $thurslaborcode5 $_POST['thurslaborcode5'];
    $thursexchange5 $_POST['thursexchange5'];
    $thursworkjob5 $_POST['thursworkjob5'];
    $thursreghours5 $_POST['thursreghours5'];
    $thursovertime5 $_POST['thursovertime5'];
    $thurslaborcode6 $_POST['thurslaborcode6'];
    $thursexchange6 $_POST['thursexchange6'];
    $thursworkjob6 $_POST['thursworkjob6'];
    $thursreghours6 $_POST['thursreghours6'];
    $thursovertime6 $_POST['thursovertime6'];
    $thurslaborcode7 $_POST['thurslaborcode7'];
    $thursexchange7 $_POST['thursexchange7'];
    $thursworkjob7 $_POST['thursworkjob7'];
    $thursreghours7 $_POST['thursreghours7'];
    $thursovertime7 $_POST['thursovertime7'];
    $thurslaborcode8 $_POST['thurslaborcode8'];
    $thursexchange8 $_POST['thursexchange8'];
    $thursworkjob8 $_POST['thursworkjob8'];
    $thursreghours8 $_POST['thursreghours8'];
    $thursovertime8 $_POST['thursovertime8'];
    $thurslaborcode9 $_POST['thurslaborcode9'];
    $thursexchange9 $_POST['thursexchange9'];
    $thursworkjob9 $_POST['thursworkjob9'];
    $thursreghours9 $_POST['thursreghours9'];
    $thursovertime9 $_POST['thursovertime9'];
    $frilaborcode0 $_POST['frilaborcode0'];
    $friexchange0 $_POST['friexchange0'];
    $friworkjob0 $_POST['friworkjob0'];
    $frireghours0 $_POST['frireghours0'];
    $friovertime0 $_POST['friovertime0'];
    $frilaborcode1 $_POST['frilaborcode1'];
    $friexchange1 $_POST['friexchange1'];
    $friworkjob1 $_POST['friworkjob1'];
    $frireghours1 $_POST['frireghours1'];
    $friovertime1 $_POST['friovertime1'];
    $frilaborcode2 $_POST['frilaborcode2'];
    $friexchange2 $_POST['friexchange2'];
    $friworkjob2 $_POST['friworkjob2'];
    $frireghours2 $_POST['frireghours2'];
    $friovertime2 $_POST['friovertime2'];
    $frilaborcode3 $_POST['frilaborcode3'];
    $friexchange3 $_POST['friexchange3'];
    $friworkjob3 $_POST['friworkjob3'];
    $frireghours3 $_POST['frireghours3'];
    $friovertime3 $_POST['friovertime3'];
    $frilaborcode4 $_POST['frilaborcode4'];
    $friexchange4 $_POST['friexchange4'];
    $friworkjob4 $_POST['friworkjob4'];
    $frireghours4 $_POST['frireghours4'];
    $friovertime4 $_POST['friovertime4'];
    $frilaborcode5 $_POST['frilaborcode5'];
    $friexchange5 $_POST['friexchange5'];
    $friworkjob5 $_POST['friworkjob5'];
    $frireghours5 $_POST['frireghours5'];
    $friovertime5 $_POST['friovertime5'];
    $frilaborcode6 $_POST['frilaborcode6'];
    $friexchange6 $_POST['friexchange6'];
    $friworkjob6 $_POST['friworkjob6'];
    $frireghours6 $_POST['frireghours6'];
    $friovertime6 $_POST['friovertime6'];
    $frilaborcode7 $_POST['frilaborcode7'];
    $friexchange7 $_POST['friexchange7'];
    $friworkjob7 $_POST['friworkjob7'];
    $frireghours7 $_POST['frireghours7'];
    $friovertime7 $_POST['friovertime7'];
    $frilaborcode8 $_POST['frilaborcode8'];
    $friexchange8 $_POST['friexchange8'];
    $friworkjob8 $_POST['friworkjob8'];
    $frireghours8 $_POST['frireghours8'];
    $friovertime8 $_POST['friovertime8'];
    $frilaborcode9 $_POST['frilaborcode9'];
    $friexchange9 $_POST['friexchange9'];
    $friworkjob9 $_POST['friworkjob9'];
    $frireghours9 $_POST['frireghours9'];
    $friovertime9 $_POST['friovertime9'];
    $satlaborcode0 $_POST['satlaborcode0'];
    $satexchange0 $_POST['satexchange0'];
    $satworkjob0 $_POST['satworkjob0'];
    $satreghours0 $_POST['satreghours0'];
    $satovertime0 $_POST['satovertime0'];
    $satlaborcode1 $_POST['satlaborcode1'];
    $satexchange1 $_POST['satexchange1'];
    $satworkjob1 $_POST['satworkjob1'];
    $satreghours1 $_POST['satreghours1'];
    $satovertime1 $_POST['satovertime1'];
    $satlaborcode2 $_POST['satlaborcode2'];
    $satexchange2 $_POST['satexchange2'];
    $satworkjob2 $_POST['satworkjob2'];
    $satreghours2 $_POST['satreghours2'];
    $satovertime2 $_POST['satovertime2'];
    $satlaborcode3 $_POST['satlaborcode3'];
    $satexchange3 $_POST['satexchange3'];
    $satworkjob3 $_POST['satworkjob3'];
    $satreghours3 $_POST['satreghours3'];
    $satovertime3 $_POST['satovertime3'];
    $satlaborcode4 $_POST['satlaborcode4'];
    $satexchange4 $_POST['satexchange4'];
    $satworkjob4 $_POST['satworkjob4'];
    $satreghours4 $_POST['satreghours4'];
    $satovertime4 $_POST['satovertime4'];
    $satlaborcode5 $_POST['satlaborcode5'];
    $satexchange5 $_POST['satexchange5'];
    $satworkjob5 $_POST['satworkjob5'];
    $satreghours5 $_POST['satreghours5'];
    $satovertime5 $_POST['satovertime5'];
    $satlaborcode6 $_POST['satlaborcode6'];
    $satexchange6 $_POST['satexchange6'];
    $satworkjob6 $_POST['satworkjob6'];
    $satreghours6 $_POST['satreghours6'];
    $satovertime6 $_POST['satovertime6'];
    $satlaborcode7 $_POST['satlaborcode7'];
    $satexchange7 $_POST['satexchange7'];
    $satworkjob7 $_POST['satworkjob7'];
    $satreghours7 $_POST['satreghours7'];
    $satovertime7 $_POST['satovertime7'];
    $satlaborcode8 $_POST['satlaborcode8'];
    $satexchange8 $_POST['satexchange8'];
    $satworkjob8 $_POST['satworkjob8'];
    $satreghours8 $_POST['satreghours8'];
    $satovertime8 $_POST['satovertime8'];
    $satlaborcode9 $_POST['satlaborcode9'];
    $satexchange9 $_POST['satexchange9'];
    $satworkjob9 $_POST['satworkjob9'];
    $satreghours9 $_POST['satreghours9'];
    $satovertime9 $_POST['satovertime9'];
    $sunlaborcode0 $_POST['sunlaborcode0'];
    $sunexchange0 $_POST['sunexchange0'];
    $sunworkjob0 $_POST['sunworkjob0'];
    $sunreghours0 $_POST['sunreghours0'];
    $sunovertime0 $_POST['sunovertime0'];
    $sunlaborcode1 $_POST['sunlaborcode1'];
    $sunexchange1 $_POST['sunexchange1'];
    $sunworkjob1 $_POST['sunworkjob1'];
    $sunreghours1 $_POST['sunreghours1'];
    $sunovertime1 $_POST['sunovertime1'];
    $sunlaborcode2 $_POST['sunlaborcode2'];
    $sunexchange2 $_POST['sunexchange2'];
    $sunworkjob2 $_POST['sunworkjob2'];
    $sunreghours2 $_POST['sunreghours2'];
    $sunovertime2 $_POST['sunovertime2'];
    $sunlaborcode3 $_POST['sunlaborcode3'];
    $sunexchange3 $_POST['sunexchange3'];
    $sunworkjob3 $_POST['sunworkjob3'];
    $sunreghours3 $_POST['sunreghours3'];
    $sunovertime3 $_POST['sunovertime3'];
    $sunlaborcode4 $_POST['sunlaborcode4'];
    $sunexchange4 $_POST['sunexchange4'];
    $sunworkjob4 $_POST['sunworkjob4'];
    $sunreghours4 $_POST['sunreghours4'];
    $sunovertime4 $_POST['sunovertime4'];
    $sunlaborcode5 $_POST['sunlaborcode5'];
    $sunexchange5 $_POST['sunexchange5'];
    $sunworkjob5 $_POST['sunworkjob5'];
    $sunreghours5 $_POST['sunreghours5'];
    $sunovertime5 $_POST['sunovertime5'];
    $sunlaborcode6 $_POST['sunlaborcode6'];
    $sunexchange6 $_POST['sunexchange6'];
    $sunworkjob6 $_POST['sunworkjob6'];
    $sunreghours6 $_POST['sunreghours6'];
    $sunovertime6 $_POST['sunovertime6'];
    $sunlaborcode7 $_POST['sunlaborcode7'];
    $sunexchange7 $_POST['sunexchange7'];
    $sunworkjob7 $_POST['sunworkjob7'];
    $sunreghours7 $_POST['sunreghours7'];
    $sunovertime7 $_POST['sunovertime7'];
    $sunlaborcode8 $_POST['sunlaborcode8'];
    $sunexchange8 $_POST['sunexchange8'];
    $sunworkjob8 $_POST['sunworkjob8'];
    $sunreghours8 $_POST['sunreghours8'];
    $sunovertime8 $_POST['sunovertime8'];
    $sunlaborcode9 $_POST['sunlaborcode9'];
    $sunexchange9 $_POST['sunexchange9'];
    $sunworkjob9 $_POST['sunworkjob9'];
    $sunreghours9 $_POST['sunreghours9'];
    $sunovertime9 $_POST['sunovertime9'];
    $summlaborcode0 $_POST['summlaborcode0'];
    $summexchange0 $_POST['summexchange0'];
    $summworkjob0 $_POST['summworkjob0'];
    $summreghours0 $_POST['summreghours0'];
    $summovertime0 $_POST['summovertime0'];
    $summlaborcode1 $_POST['summlaborcode1'];
    $summexchange1 $_POST['summexchange1'];
    $summworkjob1 $_POST['summworkjob1'];
    $summreghours1 $_POST['summreghours1'];
    $summovertime1 $_POST['summovertime1'];
    $summlaborcode2 $_POST['summlaborcode2'];
    $summexchange2 $_POST['summexchange2'];
    $summworkjob2 $_POST['summworkjob2'];
    $summreghours2 $_POST['summreghours2'];
    $summovertime2 $_POST['summovertime2'];
    $summlaborcode3 $_POST['summlaborcode3'];
    $summexchange3 $_POST['summexchange3'];
    $summworkjob3 $_POST['summworkjob3'];
    $summreghours3 $_POST['summreghours3'];
    $summovertime3 $_POST['summovertime3'];
    $summlaborcode4 $_POST['summlaborcode4'];
    $summexchange4 $_POST['summexchange4'];
    $summworkjob4 $_POST['summworkjob4'];
    $summreghours4 $_POST['summreghours4'];
    $summovertime4 $_POST['summovertime4'];
    $summlaborcode5 $_POST['summlaborcode5'];
    $summexchange5 $_POST['summexchange5'];
    $summworkjob5 $_POST['summworkjob5'];
    $summreghours5 $_POST['summreghours5'];
    $summovertime5 $_POST['summovertime5'];
    $summlaborcode6 $_POST['summlaborcode6'];
    $summexchange6 $_POST['summexchange6'];
    $summworkjob6 $_POST['summworkjob6'];
    $summreghours6 $_POST['summreghours6'];
    $summovertime6 $_POST['summovertime6'];
    $summlaborcode7 $_POST['summlaborcode7'];
    $summexchange7 $_POST['summexchange7'];
    $summworkjob7 $_POST['summworkjob7'];
    $summreghours7 $_POST['summreghours7'];
    $summovertime7 $_POST['summovertime7'];
    $summlaborcode8 $_POST['summlaborcode8'];
    $summexchange8 $_POST['summexchange8'];
    $summworkjob8 $_POST['summworkjob8'];
    $summreghours8 $_POST['summreghours8'];
    $summovertime8 $_POST['summovertime8'];
    $summlaborcode9 $_POST['summlaborcode9'];
    $summexchange9 $_POST['summexchange9'];
    $summworkjob9 $_POST['summworkjob9'];
    $summreghours9 $_POST['summreghours9'];
    $summovertime9 $_POST['summovertime9'];

    $query mysql_query("SELECT * WHERE username = '" $_SESSION['user_name'] ."'") or die(mysql_error()); 
    if (
    mysql_num_rows($query) == 0)) { 
    $query2 "INSERT INTO timesheet (username, monlaborcode0, monexchange0, monworkjob0, monreghours0, monovertime0, monlaborcode1, monexchange1, monworkjob1, monreghours1, monovertime1, monlaborcode2, monexchange2, monworkjob2, monreghours2, monovertime2, monlaborcode3, monexchange3, monworkjob3, monreghours3, monovertime3, monlaborcode4, monexchange4, monworkjob4, monreghours4, monovertime4, monlaborcode5, monexchange5, monworkjob5, monreghours5, monovertime5, monlaborcode6, monexchange6, monworkjob6, monreghours6, monovertime6, monlaborcode7, monexchange7, monworkjob7, monreghours7, monovertime7, monlaborcode8, monexchange8, monworkjob8, monreghours8, monovertime8, monlaborcode9, monexchange9, monworkjob9, monreghours9, monovertime9, tueslaborcode0, tuesexchange0, tuesworkjob0, tuesreghours0, tuesovertime0, tueslaborcode1, tuesexchange1, tuesworkjob1, tuesreghours1, tuesovertime1, tueslaborcode2, tuesexchange2, tuesworkjob2, tuesreghours2, tuesovertime2, tueslaborcode3, tuesexchange3, tuesworkjob3, tuesreghours3, tuesovertime3, tueslaborcode4, tuesexchange4, tuesworkjob4, tuesreghours4, tuesovertime4, tueslaborcode5, tuesexchange5, tuesworkjob5, tuesreghours5, tuesovertime5, tueslaborcode6, tuesexchange6, tuesworkjob6, tuesreghours6, tuesovertime6, tueslaborcode7, tuesexchange7, tuesworkjob7, tuesreghours7, tuesovertime7, tueslaborcode8, tuesexchange8, tuesworkjob8, tuesreghours8, tuesovertime8, tueslaborcode9, tuesexchange9, tuesworkjob9, tuesreghours9, tuesovertime9, wedlaborcode0, wedexchange0, wedworkjob0, wedreghours0, wedovertime0, wedlaborcode1, wedexchange1, wedworkjob1, wedreghours1, wedovertime1, wedlaborcode2, wedexchange2, wedworkjob2, wedreghours2, wedovertime2, wedlaborcode3, wedexchange3, wedworkjob3, wedreghours3, wedovertime3, wedlaborcode4, wedexchange4, wedworkjob4, wedreghours4, wedovertime4, wedlaborcode5, wedexchange5, wedworkjob5, wedreghours5, wedovertime5, wedlaborcode6, wedexchange6, wedworkjob6, wedreghours6, wedovertime6, wedlaborcode7, wedexchange7, wedworkjob7, wedreghours7, wedovertime7, wedlaborcode8, wedexchange8, wedworkjob8, wedreghours8, wedovertime8, wedlaborcode9, wedexchange9, wedworkjob9, wedreghours9, wedovertime9, thurslaborcode0, thursexchange0, thursworkjob0, thursreghours0, thursovertime0, thurslaborcode1, thursexchange1, thursworkjob1, thursreghours1, thursovertime1, thurslaborcode2, thursexchange2, thursworkjob2, thursreghours2, thursovertime2, thurslaborcode3, thursexchange3, thursworkjob3, thursreghours3, thursovertime3, thurslaborcode4, thursexchange4, thursworkjob4, thursreghours4, thursovertime4, thurslaborcode5, thursexchange5, thursworkjob5, thursreghours5, thursovertime5, thurslaborcode6, thursexchange6, thursworkjob6, thursreghours6, thursovertime6, thurslaborcode7, thursexchange7, thursworkjob7, thursreghours7, thursovertime7, thurslaborcode8, thursexchange8, thursworkjob8, thursreghours8, thursovertime8, thurslaborcode9, thursexchange9, thursworkjob9, thursreghours9,thursovertime9, frilaborcode0, friexchange0, friworkjob0, frireghours0, friovertime0, frilaborcode1, friexchange1, friworkjob1, frireghours1, friovertime1, frilaborcode2, friexchange2, friworkjob2, frireghours2, friovertime2, frilaborcode3, friexchange3, friworkjob3, frireghours3, friovertime3, frilaborcode4, friexchange4, friworkjob4, frireghours4, friovertime4, frilaborcode5, friexchange5, friworkjob5, frireghours5, friovertime5, frilaborcode6, friexchange6, friworkjob6, frireghours6, friovertime6, frilaborcode7, friexchange7, friworkjob7, frireghours7, friovertime7, frilaborcode8, friexchange8, friworkjob8, frireghours8, friovertime8, frilaborcode9, friexchange9, friworkjob9, frireghours9, friovertime9, satlaborcode0, satexchange0, satworkjob0, satreghours0, satovertime0, satlaborcode1, satexchange1, satworkjob1, satreghours1, satovertime1, satlaborcode2, satexchange2, satworkjob2, satreghours2, satovertime2, satlaborcode3, satexchange3, satworkjob3, satreghours3, satovertime3, satlaborcode4, satexchange4, satworkjob4, satreghours4, satovertime4, satlaborcode5, satexchange5, satworkjob5, satreghours5, satovertime5, satlaborcode6, satexchange6, satworkjob6, satreghours6, satovertime6, satlaborcode7, satexchange7, satworkjob7, satreghours7, satovertime7, satlaborcode8, satexchange8, satworkjob8, satreghours8, satovertime8, satlaborcode9, satexchange9, satworkjob9, satreghours9, satovertime9, sunlaborcode0, sunexchange0, sunworkjob0, sunreghours0, sunovertime0, sunlaborcode1, sunexchange1, sunworkjob1, sunreghours1, sunovertime1, sunlaborcode2, sunexchange2, sunworkjob2, sunreghours2, sunovertime2, sunlaborcode3, sunexchange3, sunworkjob3, sunreghours3, sunovertime3, sunlaborcode4, sunexchange4, sunworkjob4, sunreghours4, sunovertime4, sunlaborcode5, sunexchange5, sunworkjob5, sunreghours5,sunovertime5, sunlaborcode6, sunexchange6, sunworkjob6, sunreghours6, sunovertime6, sunlaborcode7, sunexchange7, sunworkjob7, sunreghours7, sunovertime7, sunlaborcode8, sunexchange8, sunworkjob8, sunreghours8, sunovertime8, sunlaborcode9, sunexchange9, sunworkjob9, sunreghours9, sunovertime9, summlaborcode0, summexchange0, summworkjob0, summreghours0, summovertime0, summlaborcode1, summexchange1, summworkjob1, summreghours1, summovertime1, summlaborcode2, summexchange2, summworkjob2, summreghours2, summovertime2, summlaborcode3, summexchange3, summworkjob3, summreghours3, summovertime3, summlaborcode4, summexchange4, summworkjob4, summreghours4, summovertime4, summlaborcode5, summexchange5, summworkjob5, summreghours5, summovertime5, summlaborcode6, summexchange6, summworkjob6, summreghours6, summovertime6, summlaborcode7, summexchange7, summworkjob7, summreghours7, summovertime7, summlaborcode8, summexchange8, summworkjob8, summreghours8, summovertime8, summlaborcode9, summexchange9, summworkjob9, summreghours9, summovertime9) VALUES ('"$_SESSION['user_name'] ."', '"$monlaborcode0 ."', '"$monexchange0 ."', '"$monworkjob0 ."', '"$monreghours0 ."', '"$monovertime0 ."', '"$monlaborcode1', '$monexchange1 ."', '"$monworkjob1 ."', '"$monreghours1 ."', '"$monovertime1 ."', '"$monlaborcode2 ."', '"$monexchange2 ."', '"$monworkjob2 ."', '"$monreghours2 ."', '"$monovertime2 ."', '"$monlaborcode3 ."', '"$monexchange3 ."', '"$monworkjob3 ."', '"$monreghours3 ."', '"$monovertime3 ."', '"$monlaborcode4 ."', '"$monexchange4 ."', '"$monworkjob4 ."', '"$monreghours4 ."', '"$monovertime4 ."', '"$monlaborcode5 ."', '"$monexchange5 ."', '"$monworkjob5 ."', '"$monreghours5 ."', '"$monovertime5 ."', '"$monlaborcode6 ."', '"$monexchange6 ."', '"$monworkjob6 ."', '"$monreghours6 ."', '"$monovertime6 ."', '"$monlaborcode7 ."', '"$monexchange7 ."', '"$monworkjob7 ."', '"$monreghours7 ."', '"$monovertime7 ."', '"$monlaborcode8 ."', '"$monexchange8 ."', '"$monworkjob8 ."', '"$monreghours8 ."', '"$monovertime8 ."', '"$monlaborcode9 ."', '"$monexchange9 ."', '"$monworkjob9 ."', '"$monreghours9 ."', '"$monovertime9 ."', '"$tueslaborcode0 ."', '"$tuesexchange0 ."', '"$tuesworkjob0 ."', '"$tuesreghours0 ."', '"$tuesovertime0 ."', '"$tueslaborcode1 ."', '"$tuesexchange1 ."', '"$tuesworkjob1 ."', '"$tuesreghours1 ."', '"$tuesovertime1 ."', '"$tueslaborcode2 ."', '"$tuesexchange2 ."', '"$tuesworkjob2 ."', '"$tuesreghours2 ."', '"$tuesovertime2 ."', '"$tueslaborcode3 ."', '"$tuesexchange3 ."', '"$tuesworkjob3 ."', '"$tuesreghours3 ."', '"$tuesovertime3 ."', '"$tueslaborcode4 ."', '"$tuesexchange4 ."', '"$tuesworkjob4 ."', '"$tuesreghours4 ."', '"$tuesovertime4 ."', '"$tueslaborcode5 ."', '"$tuesexchange5 ."', '"$tuesworkjob5 ."', '"$tuesreghours5 ."', '"$tuesovertime5 ."', '"$tueslaborcode6 ."', '"$tuesexchange6 ."', '"$tuesworkjob6 ."', '"$tuesreghours6 ."', '"$tuesovertime6 ."', '"$tueslaborcode7 ."', '"$tuesexchange7 ."', '"$tuesworkjob7 ."', '"$tuesreghours7 ."', '"$tuesovertime7 ."', '"$tueslaborcode8 ."', '"$tuesexchange8 ."', '"$tuesworkjob8 ."', '"$tuesreghours8 ."', '"$tuesovertime8 ."', '"$tueslaborcode9 ."', '"$tuesexchange9 ."', '"$tuesworkjob9 ."', '"$tuesreghours9 ."', '"$tuesovertime9 ."', '"$wedlaborcode0 ."', '"$wedexchange0 ."', '"$wedworkjob0 ."', '"$wedreghours0 ."', '"$wedovertime0 ."', '"$wedlaborcode1 ."', '"$wedexchange1 ."', '"$wedworkjob1 ."', '"$wedreghours1 ."', '"$wedovertime1 ."', '"$wedlaborcode2 ."', '"$wedexchange2 ."', '"$wedworkjob2 ."', '"$wedreghours2 ."', '"$wedovertime2 ."', '"$wedlaborcode3 ."', '"$wedexchange3 ."', '"$wedworkjob3 ."', '"$wedreghours3 ."', '"$wedovertime3 ."', '"$wedlaborcode4 ."', '"$wedexchange4 ."', '"$wedworkjob4 ."', '"$wedreghours4 ."', '"$wedovertime4 ."', '"$wedlaborcode5 ."', '"$wedexchange5 ."', '"$wedworkjob5 ."', '"$wedreghours5 ."', '"$wedovertime5 ."', '"$wedlaborcode6 ."', '"$wedexchange6 ."', '"$wedworkjob6 ."', '"$wedreghours6 ."', '"$wedovertime6 ."', '"$wedlaborcode7 ."', '"$wedexchange7 ."', '"$wedworkjob7 ."', '"$wedreghours7 ."', '"$wedovertime7 ."', '"$wedlaborcode8 ."', '"$wedexchange8 ."', '"$wedworkjob8 ."', '"$wedreghours8 ."', '"$wedovertime8 ."', '"$wedlaborcode9 ."', '"$wedexchange9 ."', '"$wedworkjob9 ."', '"$wedreghours9 ."', '"$wedovertime9 ."', '"$thurslaborcode0 ."', '"$thursexchange0 ."', '"$thursworkjob0 ."', '"$thursreghours0 ."', '"$thursovertime0 ."', '"$thurslaborcode1 ."', '"$thursexchange1 ."', '"$thursworkjob1 ."', '"$thursreghours1 ."', '"$thursovertime1 ."', '"$thurslaborcode2 ."', '"$thursexchange2 ."', '"$thursworkjob2 ."', '"$thursreghours2 ."', '"$thursovertime2 ."', '"$thurslaborcode3 ."', '"$thursexchange3 ."', '"$thursworkjob3 ."', '"$thursreghours3 ."', '"$thursovertime3 ."', '"$thurslaborcode4 ."', '"$thursexchange4 ."', '"$thursworkjob4 ."', '"$thursreghours4 ."', '"$thursovertime4 ."', '"$thurslaborcode5 ."', '"$thursexchange5 ."', '"$thursworkjob5 ."', '"$thursreghours5 ."', '"$thursovertime5 ."', '"$thurslaborcode6 ."', '"$thursexchange6 ."', '"$thursworkjob6 ."', '"$thursreghours6 ."', '"$thursovertime6 ."', '"$thurslaborcode7 ."', '"$thursexchange7 ."', '"$thursworkjob7 ."', '"$thursreghours7 ."', '"$thursovertime7 ."', '"$thurslaborcode8 ."', '"$thursexchange8 ."', '"$thursworkjob8 ."', '"$thursreghours8 ."', '"$thursovertime8 ."', '"$thurslaborcode9 ."', '"$thursexchange9 ."', '"$thursworkjob9 ."', '"$thursreghours9 ."', '"$thursovertime9 ."', '"$frilaborcode0 ."', '"$friexchange0 ."', '"$friworkjob0 ."', '"$frireghours0 ."', '"$friovertime0 ."', '"$frilaborcode1 ."', '"$friexchange1 ."', '"$friworkjob1 ."', '"$frireghours1 ."', '"$friovertime1 ."', '"$frilaborcode2 ."', '"$friexchange2 ."', '"$friworkjob2 ."', '"$frireghours2 ."', '"$friovertime2 ."', '"$frilaborcode3 ."', '"$friexchange3 ."', '"$friworkjob3 ."', '"$frireghours3 ."', '"$friovertime3 ."', '"$frilaborcode4 ."', '"$friexchange4 ."', '"$friworkjob4 ."', '"$frireghours4 ."', '"$friovertime4 ."', '"$frilaborcode5 ."', '"$friexchange5 ."', '"$friworkjob5 ."', '"$frireghours5 ."', '"$friovertime5 ."', '"$frilaborcode6 ."', '"$friexchange6 ."', '"$friworkjob6 ."', '"$frireghours6 ."', '"$friovertime6 ."', '"$frilaborcode7 ."', '"$friexchange7 ."', '"$friworkjob7 ."', '"$frireghours7 ."', '"$friovertime7 ."', '"$frilaborcode8 ."', '"$friexchange8 ."', '"$friworkjob8 ."', '"$frireghours8 ."', '"$friovertime8 ."', '"$frilaborcode9 ."', '"$friexchange9 ."', '"$friworkjob9 ."', '"$frireghours9 ."', '"$friovertime9 ."', '"$satlaborcode0 ."', '"$satexchange0 ."', '"$satworkjob0 ."', '"$satreghours0 ."', '"$satovertime0 ."', '"$satlaborcode1 ."', '"$satexchange1 ."', '"$satworkjob1 ."', '"$satreghours1 ."', '"$satovertime1 ."', '"$satlaborcode2 ."', '"$satexchange2 ."', '"$satworkjob2 ."', '"$satreghours2 ."', '"$satovertime2 ."', '"$satlaborcode3 ."', '"$satexchange3 ."', '"$satworkjob3 ."', '"$satreghours3 ."', '"$satovertime3 ."', '"$satlaborcode4 ."', '"$satexchange4 ."', '"$satworkjob4 ."', '"$satreghours4 ."', '"$satovertime4 ."', '"$satlaborcode5 ."', '"$satexchange5 ."', '"$satworkjob5 ."', '"$satreghours5 ."', '"$satovertime5 ."', '"$satlaborcode6 ."', '"$satexchange6 ."', '"$satworkjob6 ."', '"$satreghours6 ."', '"$satovertime6 ."', '"$satlaborcode7 ."', '"$satexchange7 ."', '"$satworkjob7 ."', '"$satreghours7 ."', '"$satovertime7 ."', '"$satlaborcode8 ."', '"$satexchange8 ."', '"$satworkjob8 ."', '"$satreghours8 ."', '"$satovertime8 ."', '"$satlaborcode9 ."', '"$satexchange9 ."', '"$satworkjob9 ."', '"$satreghours9 ."', '"$satovertime9 ."', '"$sunlaborcode0 ."', '"$sunexchange0 ."', '"$sunworkjob0 ."', '"$sunreghours0 ."', '"$sunovertime0 ."', '"$sunlaborcode1 ."', '"$sunexchange1 ."', '"$sunworkjob1 ."', '"$sunreghours1 ."', '"$sunovertime1 ."', '"$sunlaborcode2 ."', '"$sunexchange2 ."', '"$sunworkjob2 ."', '"$sunreghours2 ."', '"$sunovertime2 ."', '"$sunlaborcode3 ."', '"$sunexchange3 ."', '"$sunworkjob3 ."', '"$sunreghours3 ."', '"$sunovertime3 ."', '"$sunlaborcode4 ."', '"$sunexchange4 ."', '"$sunworkjob4 ."', '"$sunreghours4 ."', '"$sunovertime4 ."', '"$sunlaborcode5 ."', '"$sunexchange5 ."', '"$sunworkjob5 ."', '"$sunreghours5 ."', '"$sunovertime5 ."', '"$sunlaborcode6 ."', '"$sunexchange6 ."', '"$sunworkjob6 ."', '"$sunreghours6 ."', '"$sunovertime6 ."', '"$sunlaborcode7 ."', '"$sunexchange7 ."', '"$sunworkjob7 ."', '"$sunreghours7 ."', '"$sunovertime7 ."', '"$sunlaborcode8 ."', '"$sunexchange8 ."', '"$sunworkjob8 ."', '"$sunreghours8 ."', '"$sunovertime8 ."', '"$sunlaborcode9 ."', '"$sunexchange9 ."', '"$sunworkjob9 ."', '"$sunreghours9 ."', '"$sunovertime9 ."', '"$summlaborcode0 ."', '"$summexchange0 ."', '"$summworkjob0 ."', '"$summreghours0 ."', '"$summovertime0 ."', '"$summlaborcode1 ."', '"$summexchange1 ."', '"$summworkjob1 ."', '"$summreghours1 ."', '"$summovertime1 ."', '"$summlaborcode2 ."', '"$summexchange2 ."', '"$summworkjob2 ."', '"$summreghours2 ."', '"$summovertime2 ."', '"$summlaborcode3 ."', '"$summexchange3 ."', '"$summworkjob3 ."', '"$summreghours3 ."', '"$summovertime3 ."', '"$summlaborcode4 ."', '"$summexchange4 ."', '"$summworkjob4 ."', '"$summreghours4 ."', '"$summovertime4 ."', '"$summlaborcode5 ."', '"$summexchange5 ."', '"$summworkjob5 ."', '"$summreghours5 ."', '"$summovertime5 ."', '"$summlaborcode6 ."', '"$summexchange6 ."', '"$summworkjob6 ."', '"$summreghours6 ."', '"$summovertime6 ."', '"$summlaborcode7 ."', '"$summexchange7 ."', '"$summworkjob7 ."', '"$summreghours7 ."', '"$summovertime7 ."', '"$summlaborcode8 ."', '"$summexchange8 ."', '"$summworkjob8 ."', '"$summreghours8 ."', '"$summovertime8 ."', '"$summlaborcode9 ."', '"$summexchange9 ."', '"$summworkjob9 ."', '"$summreghours9 ."', '"$summovertime9 ."')"
    } else { 
    $query3  "UPDATE timesheet 
    SET 
    monlaborcode0 = '"
    $_POST['monlaborcode0'] ."', 
    monexchange0 = '"
    $_POST['monexchange0'] ."', 
    monworkjob0 = '"
    $_POST['monworkjob0'] ."', 
    monreghours0 = '"
    $_POST['monreghours0'] ."', 
    monovertime0 = '"
    $_POST['monovertime0'] ."', 
    monlaborcode1 = '"
    $_POST['monlaborcode1'] ."', 
    monexchange1 = '"
    $_POST['monexchange1'] ."', 
    monworkjob1 = '"
    $_POST['monworkjob1'] ."', 
    monreghours1 = '"
    $_POST['monreghours1'] ."', 
    monovertime1 = '"
    $_POST['monovertime1'] ."', 
    monlaborcode2 = '"
    $_POST['monlaborcode2'] ."', 
    monexchange2 = '"
    $_POST['monexchange2'] ."', 
    monworkjob2 = '"
    $_POST['monworkjob2'] ."', 
    monreghours2 = '"
    $_POST['monreghours2'] ."', 
    monovertime2 = '"
    $_POST['monovertime2'] ."', 
    monlaborcode3 = '"
    $_POST['monlaborcode3'] ."', 
    monexchange3 = '"
    $_POST['monexchange3'] ."', 
    monworkjob3 = '"
    $_POST['monworkjob3'] ."', 
    monreghours3 = '"
    $_POST['monreghours3'] ."', 
    monovertime3 = '"
    $_POST['monovertime3'] ."', 
    monlaborcode4 = '"
    $_POST['monlaborcode4'] ."', 
    monexchange4 = '"
    $_POST['monexchange4'] ."', 
    monworkjob4 = '"
    $_POST['monworkjob4'] ."', 
    monreghours4 = '"
    $_POST['monreghours4'] ."', 
    monovertime4 = '"
    $_POST['monovertime4'] ."', 
    monlaborcode5 = '"
    $_POST['monlaborcode5'] ."', 
    monexchange5 = '"
    $_POST['monexchange5'] ."', 
    monworkjob5 = '"
    $_POST['monworkjob5'] ."', 
    monreghours5 = '"
    $_POST['monreghours5'] ."', 
    monovertime5 = '"
    $_POST['monovertime5'] ."', 
    monlaborcode6 = '"
    $_POST['monlaborcode6'] ."', 
    monexchange6 = '"
    $_POST['monexchange6'] ."', 
    monworkjob6 = '"
    $_POST['monworkjob6'] ."', 
    monreghours6 = '"
    $_POST['monreghours6'] ."', 
    monovertime6 = '"
    $_POST['monovertime6'] ."', 
    monlaborcode7 = '"
    $_POST['monlaborcode7'] ."', 
    monexchange7 = '"
    $_POST['monexchange7'] ."', 
    monworkjob7 = '"
    $_POST['monworkjob7'] ."', 
    monreghours7 = '"
    $_POST['monreghours7'] ."', 
    monovertime7 = '"
    $_POST['monovertime7'] ."', 
    monlaborcode8 = '"
    $_POST['monlaborcode8'] ."', 
    monexchange8 = '"
    $_POST['monexchange8'] ."', 
    monworkjob8 = '"
    $_POST['monworkjob8'] ."', 
    monreghours8 = '"
    $_POST['monreghours8'] ."', 
    monovertime8 = '"
    $_POST['monovertime8'] ."', 
    monlaborcode9 = '"
    $_POST['monlaborcode9'] ."', 
    monexchange9 = '"
    $_POST['monexchange9'] ."', 
    monworkjob9 = '"
    $_POST['monworkjob9'] ."', 
    monreghours9 = '"
    $_POST['monreghours9'] ."', 
    monovertime9 = '"
    $_POST['monovertime9'] ."', 
    tueslaborcode0 = '"
    $_POST['tueslaborcode0'] ."', 
    tuesexchange0 = '"
    $_POST['tuesexchange0'] ."', 
    tuesworkjob0 = '"
    $_POST['tuesworkjob0'] ."', 
    tuesreghours0 = '"
    $_POST['tuesreghours0'] ."', 
    tuesovertime0 = '"
    $_POST['tuesovertime0'] ."', 
    tueslaborcode1 = '"
    $_POST['tueslaborcode1'] ."', 
    tuesexchange1 = '"
    $_POST['tuesexchange1'] ."', 
    tuesworkjob1 = '"
    $_POST['tuesworkjob1'] ."', 
    tuesreghours1 = '"
    $_POST['tuesreghours1'] ."', 
    tuesovertime1 = '"
    $_POST['tuesovertime1'] ."', 
    tueslaborcode2 = '"
    $_POST['tueslaborcode2'] ."', 
    tuesexchange2 = '"
    $_POST['tuesexchange2'] ."', 
    tuesworkjob2 = '"
    $_POST['tuesworkjob2'] ."', 
    tuesreghours2 = '"
    $_POST['tuesreghours2'] ."', 
    tuesovertime2 = '"
    $_POST['tuesovertime2'] ."', 
    tueslaborcode3 = '"
    $_POST['tueslaborcode3'] ."', 
    tuesexchange3 = '"
    $_POST['tuesexchange3'] ."', 
    tuesworkjob3 = '"
    $_POST['tuesworkjob3'] ."', 
    tuesreghours3 = '"
    $_POST['tuesreghours3'] ."', 
    tuesovertime3 = '"
    $_POST['tuesovertime3'] ."', 
    tueslaborcode4 = '"
    $_POST['tueslaborcode4'] ."', 
    tuesexchange4 = '"
    $_POST['tuesexchange4'] ."', 
    tuesworkjob4 = '"
    $_POST['tuesworkjob4'] ."', 
    tuesreghours4 = '"
    $_POST['tuesreghours4'] ."', 
    tuesovertime4 = '"
    $_POST['tuesovertime4'] ."', 
    tueslaborcode5 = '"
    $_POST['tueslaborcode5'] ."', 
    tuesexchange5 = '"
    $_POST['tuesexchange5'] ."', 
    tuesworkjob5 = '"
    $_POST['tuesworkjob5'] ."', 
    tuesreghours5 = '"
    $_POST['tuesreghours5'] ."', 
    tuesovertime5 = '"
    $_POST['tuesovertime5'] ."', 
    tueslaborcode6 = '"
    $_POST['tueslaborcode6'] ."', 
    tuesexchange6 = '"
    $_POST['tuesexchange6'] ."', 
    tuesworkjob6 = '"
    $_POST['tuesworkjob6'] ."', 
    tuesreghours6 = '"
    $_POST['tuesreghours6'] ."', 
    tuesovertime6 = '"
    $_POST['tuesovertime6'] ."', 
    tueslaborcode7 = '"
    $_POST['tueslaborcode7'] ."', 
    tuesexchange7 = '"
    $_POST['tuesexchange7'] ."', 
    tuesworkjob7 = '"
    $_POST['tuesworkjob7'] ."', 
    tuesreghours7 = '"
    $_POST['tuesreghours7'] ."', 
    tuesovertime7 = '"
    $_POST['tuesovertime7'] ."', 
    tueslaborcode8 = '"
    $_POST['tueslaborcode8'] ."', 
    tuesexchange8 = '"
    $_POST['tuesexchange8'] ."', 
    tuesworkjob8 = '"
    $_POST['tuesworkjob8'] ."', 
    tuesreghours8 = '"
    $_POST['tuesreghours8'] ."', 
    tuesovertime8 = '"
    $_POST['tuesovertime8'] ."', 
    tueslaborcode9 = '"
    $_POST['tueslaborcode9'] ."', 
    tuesexchange9 = '"
    $_POST['tuesexchange9'] ."', 
    tuesworkjob9 = '"
    $_POST['tuesworkjob9'] ."', 
    tuesreghours9 = '"
    $_POST['tuesreghours9'] ."', 
    tuesovertime9 = '"
    $_POST['tuesovertime9'] ."', 
    wedlaborcode0 = '"
    $_POST['wedlaborcode0'] ."', 
    wedexchange0 = '"
    $_POST['wedexchange0'] ."', 
    wedworkjob0 = '"
    $_POST['wedworkjob0'] ."', 
    wedreghours0 = '"
    $_POST['wedreghours0'] ."', 
    wedovertime0 = '"
    $_POST['wedovertime0'] ."', 
    wedlaborcode1 = '"
    $_POST['wedlaborcode1'] ."', 
    wedexchange1 = '"
    $_POST['wedexchange1'] ."', 
    wedworkjob1 = '"
    $_POST['wedworkjob1'] ."', 
    wedreghours1 = '"
    $_POST['wedreghours1'] ."', 
    wedovertime1 = '"
    $_POST['wedovertime1'] ."', 
    wedlaborcode2 = '"
    $_POST['wedlaborcode2'] ."', 
    wedexchange2 = '"
    $_POST['wedexchange2'] ."', 
    wedworkjob2 = '"
    $_POST['wedworkjob2'] ."', 
    wedreghours2 = '"
    $_POST['wedreghours2'] ."', 
    wedovertime2 = '"
    $_POST['wedovertime2'] ."', 
    wedlaborcode3 = '"
    $_POST['wedlaborcode3'] ."', 
    wedexchange3 = '"
    $_POST['wedexchange3'] ."', 
    wedworkjob3 = '"
    $_POST['wedworkjob3'] ."', 
    wedreghours3 = '"
    $_POST['wedreghours3'] ."', 
    wedovertime3 = '"
    $_POST['wedovertime3'] ."', 
    wedlaborcode4 = '"
    $_POST['wedlaborcode4'] ."', 
    wedexchange4 = '"
    $_POST['wedexchange4'] ."', 
    wedworkjob4 = '"
    $_POST['wedworkjob4'] ."', 
    wedreghours4 = '"
    $_POST['wedreghours4'] ."', 
    wedovertime4 = '"
    $_POST['wedovertime4'] ."', 
    wedlaborcode5 = '"
    $_POST['wedlaborcode5'] ."', 
    wedexchange5 = '"
    $_POST['wedexchange5'] ."', 
    wedworkjob5 = '"
    $_POST['wedworkjob5'] ."', 
    wedreghours5 = '"
    $_POST['wedreghours5'] ."', 
    wedovertime5 = '"
    $_POST['wedovertime5'] ."', 
    wedlaborcode6 = '"
    $_POST['wedlaborcode6'] ."', 
    wedexchange6 = '"
    $_POST['wedexchange6'] ."', 
    wedworkjob6 = '"
    $_POST['wedworkjob6'] ."', 
    wedreghours6 = '"
    $_POST['wedreghours6'] ."', 
    wedovertime6 = '"
    $_POST['wedovertime6'] ."', 
    wedlaborcode7 = '"
    $_POST['wedlaborcode7'] ."', 
    wedexchange7 = '"
    $_POST['wedexchange7'] ."', 
    wedworkjob7 = '"
    $_POST['wedworkjob7'] ."', 
    wedreghours7 = '"
    $_POST['wedreghours7'] ."', 
    wedovertime7 = '"
    $_POST['wedovertime7'] ."', 
    wedlaborcode8 = '"
    $_POST['wedlaborcode8'] ."', 
    wedexchange8 = '"
    $_POST['wedexchange8'] ."', 
    wedworkjob8 = '"
    $_POST['wedworkjob8'] ."', 
    wedreghours8 = '"
    $_POST['wedreghours8'] ."', 
    wedovertime8 = '"
    $_POST['wedovertime8'] ."', 
    wedlaborcode9 = '"
    $_POST['wedlaborcode9'] ."', 
    wedexchange9 = '"
    $_POST['wedexchange9'] ."', 
    wedworkjob9 = '"
    $_POST['wedworkjob9'] ."', 
    wedreghours9 = '"
    $_POST['wedreghours9'] ."', 
    wedovertime9 = '"
    $_POST['wedovertime9'] ."', 
    thurslaborcode0 = '"
    $_POST['thurslaborcode0'] ."', 
    thursexchange0 = '"
    $_POST['thursexchange0'] ."', 
    thursworkjob0 = '"
    $_POST['thursworkjob0'] ."', 
    thursreghours0 = '"
    $_POST['thursreghours0'] ."', 
    thursovertime0 = '"
    $_POST['thursovertime0'] ."', 
    thurslaborcode1 = '"
    $_POST['thurslaborcode1'] ."', 
    thursexchange1 = '"
    $_POST['thursexchange1'] ."', 
    thursworkjob1 = '"
    $_POST['thursworkjob1'] ."', 
    thursreghours1 = '"
    $_POST['thursreghours1'] ."', 
    thursovertime1 = '"
    $_POST['thursovertime1'] ."', 
    thurslaborcode2 = '"
    $_POST['thurslaborcode2'] ."', 
    thursexchange2 = '"
    $_POST['thursexchange2'] ."', 
    thursworkjob2 = '"
    $_POST['thursworkjob2'] ."', 
    thursreghours2 = '"
    $_POST['thursreghours2'] ."', 
    thursovertime2 = '"
    $_POST['thursovertime2'] ."', 
    thurslaborcode3 = '"
    $_POST['thurslaborcode3'] ."', 
    thursexchange3 = '"
    $_POST['thursexchange3'] ."', 
    thursworkjob3 = '"
    $_POST['thursworkjob3'] ."', 
    thursreghours3 = '"
    $_POST['thursreghours3'] ."', 
    thursovertime3 = '"
    $_POST['thursovertime3'] ."', 
    thurslaborcode4 = '"
    $_POST['thurslaborcode4'] ."', 
    thursexchange4 = '"
    $_POST['thursexchange4'] ."', 
    thursworkjob4 = '"
    $_POST['thursworkjob4'] ."', 
    thursreghours4 = '"
    $_POST['thursreghours4'] ."', 
    thursovertime4 = '"
    $_POST['thursovertime4'] ."', 
    thurslaborcode5 = '"
    $_POST['thurslaborcode5'] ."', 
    thursexchange5 = '"
    $_POST['thursexchange5'] ."', 
    thursworkjob5 = '"
    $_POST['thursworkjob5'] ."', 
    thursreghours5 = '"
    $_POST['thursreghours5'] ."', 
    thursovertime5 = '"
    $_POST['thursovertime5'] ."', 
    thurslaborcode6 = '"
    $_POST['thurslaborcode6'] ."', 
    thursexchange6 = '"
    $_POST['thursexchange6'] ."', 
    thursworkjob6 = '"
    $_POST['thursworkjob6'] ."', 
    thursreghours6 = '"
    $_POST['thursreghours6'] ."', 
    thursovertime6 = '"
    $_POST['thursovertime6'] ."', 
    thurslaborcode7 = '"
    $_POST['thurslaborcode7'] ."', 
    thursexchange7 = '"
    $_POST['thursexchange7'] ."', 
    thursworkjob7 = '"
    $_POST['thursworkjob7'] ."', 
    thursreghours7 = '"
    $_POST['thursreghours7'] ."', 
    thursovertime7 = '"
    $_POST['thursovertime7'] ."', 
    thurslaborcode8 = '"
    $_POST['thurslaborcode8'] ."', 
    thursexchange8 = '"
    $_POST['thursexchange8'] ."', 
    thursworkjob8 = '"
    $_POST['thursworkjob8'] ."', 
    thursreghours8 = '"
    $_POST['thursreghours8'] ."', 
    thursovertime8 = '"
    $_POST['thursovertime8'] ."', 
    thurslaborcode9 = '"
    $_POST['thurslaborcode9'] ."', 
    thursexchange9 = '"
    $_POST['thursexchange9'] ."', 
    thursworkjob9 = '"
    $_POST['thursworkjob9'] ."', 
    thursreghours9 = '"
    $_POST['thursreghours9'] ."', 
    thursovertime9 = '"
    $_POST['thursovertime9'] ."', 
    frilaborcode0 = '"
    $_POST['frilaborcode0'] ."', 
    friexchange0 = '"
    $_POST['friexchange0'] ."', 
    friworkjob0 = '"
    $_POST['friworkjob0'] ."', 
    frireghours0 = '"
    $_POST['frireghours0'] ."', 
    friovertime0 = '"
    $_POST['friovertime0'] ."', 
    frilaborcode1 = '"
    $_POST['frilaborcode1'] ."', 
    friexchange1 = '"
    $_POST['friexchange1'] ."', 
    friworkjob1 = '"
    $_POST['friworkjob1'] ."', 
    frireghours1 = '"
    $_POST['frireghours1'] ."', 
    friovertime1 = '"
    $_POST['friovertime1'] ."', 
    frilaborcode2 = '"
    $_POST['frilaborcode2'] ."', 
    friexchange2 = '"
    $_POST['friexchange2'] ."', 
    friworkjob2 = '"
    $_POST['friworkjob2'] ."', 
    frireghours2 = '"
    $_POST['frireghours2'] ."', 
    friovertime2 = '"
    $_POST['friovertime2'] ."', 
    frilaborcode3 = '"
    $_POST['frilaborcode3'] ."', 
    friexchange3 = '"
    $_POST['friexchange3'] ."', 
    friworkjob3 = '"
    $_POST['friworkjob3'] ."', 
    frireghours3 = '"
    $_POST['frireghours3'] ."', 
    friovertime3 = '"
    $_POST['friovertime3'] ."', 
    frilaborcode4 = '"
    $_POST['frilaborcode4'] ."', 
    friexchange4 = '"
    $_POST['friexchange4'] ."', 
    friworkjob4 = '"
    $_POST['friworkjob4'] ."', 
    frireghours4 = '"
    $_POST['frireghours4'] ."', 
    friovertime4 = '"
    $_POST['friovertime4'] ."', 
    frilaborcode5 = '"
    $_POST['frilaborcode5'] ."', 
    friexchange5 = '"
    $_POST['friexchange5'] ."', 
    friworkjob5 = '"
    $_POST['friworkjob5'] ."', 
    frireghours5 = '"
    $_POST['frireghours5'] ."', 
    friovertime5 = '"
    $_POST['friovertime5'] ."', 
    frilaborcode6 = '"
    $_POST['frilaborcode6'] ."', 
    friexchange6 = '"
    $_POST['friexchange6'] ."', 
    friworkjob6 = '"
    $_POST['friworkjob6'] ."', 
    frireghours6 = '"
    $_POST['frireghours6'] ."', 
    friovertime6 = '"
    $_POST['friovertime6'] ."', 
    frilaborcode7 = '"
    $_POST['frilaborcode7'] ."', 
    friexchange7 = '"
    $_POST['friexchange7'] ."', 
    friworkjob7 = '"
    $_POST['friworkjob7'] ."', 
    frireghours7 = '"
    $_POST['frireghours7'] ."', 
    friovertime7 = '"
    $_POST['friovertime7'] ."', 
    frilaborcode8 = '"
    $_POST['frilaborcode8'] ."', 
    friexchange8 = '"
    $_POST['friexchange8'] ."', 
    friworkjob8 = '"
    $_POST['friworkjob8'] ."', 
    frireghours8 = '"
    $_POST['frireghours8'] ."', 
    friovertime8 = '"
    $_POST['friovertime8'] ."', 
    frilaborcode9 = '"
    $_POST['frilaborcode9'] ."', 
    friexchange9 = '"
    $_POST['friexchange9'] ."', 
    friworkjob9 = '"
    $_POST['friworkjob9'] ."', 
    frireghours9 = '"
    $_POST['frireghours9'] ."', 
    friovertime9 = '"
    $_POST['friovertime9'] ."', 
    satlaborcode0 = '"
    $_POST['satlaborcode0'] ."', 
    satexchange0 = '"
    $_POST['satexchange0'] ."', 
    satworkjob0 = '"
    $_POST['satworkjob0'] ."', 
    satreghours0 = '"
    $_POST['satreghours0'] ."', 
    satovertime0 = '"
    $_POST['satovertime0'] ."', 
    satlaborcode1 = '"
    $_POST['satlaborcode1'] ."', 
    satexchange1 = '"
    $_POST['satexchange1'] ."', 
    satworkjob1 = '"
    $_POST['satworkjob1'] ."', 
    satreghours1 = '"
    $_POST['satreghours1'] ."', 
    satovertime1 = '"
    $_POST['satovertime1'] ."', 
    satlaborcode2 = '"
    $_POST['satlaborcode2'] ."', 
    satexchange2 = '"
    $_POST['satexchange2'] ."', 
    satworkjob2 = '"
    $_POST['satworkjob2'] ."', 
    satreghours2 = '"
    $_POST['satreghours2'] ."', 
    satovertime2 = '"
    $_POST['satovertime2'] ."', 
    satlaborcode3 = '"
    $_POST['satlaborcode3'] ."', 
    satexchange3 = '"
    $_POST['satexchange3'] ."', 
    satworkjob3 = '"
    $_POST['satworkjob3'] ."', 
    satreghours3 = '"
    $_POST['satreghours3'] ."', 
    satovertime3 = '"
    $_POST['satovertime3'] ."', 
    satlaborcode4 = '"
    $_POST['satlaborcode4'] ."', 
    satexchange4 = '"
    $_POST['satexchange4'] ."', 
    satworkjob4 = '"
    $_POST['satworkjob4'] ."', 
    satreghours4 = '"
    $_POST['satreghours4'] ."', 
    satovertime4 = '"
    $_POST['satovertime4'] ."', 
    satlaborcode5 = '"
    $_POST['satlaborcode5'] ."', 
    satexchange5 = '"
    $_POST['satexchange5'] ."', 
    satworkjob5 = '"
    $_POST['satworkjob5'] ."', 
    satreghours5 = '"
    $_POST['satreghours5'] ."', 
    satovertime5 = '"
    $_POST['satovertime5'] ."', 
    satlaborcode6 = '"
    $_POST['satlaborcode6'] ."', 
    satexchange6 = '"
    $_POST['satexchange6'] ."', 
    satworkjob6 = '"
    $_POST['satworkjob6'] ."', 
    satreghours6 = '"
    $_POST['satreghours6'] ."', 
    satovertime6 = '"
    $_POST['satovertime6'] ."', 
    satlaborcode7 = '"
    $_POST['satlaborcode7'] ."', 
    satexchange7 = '"
    $_POST['satexchange7'] ."', 
    satworkjob7 = '"
    $_POST['satworkjob7'] ."', 
    satreghours7 = '"
    $_POST['satreghours7'] ."', 
    satovertime7 = '"
    $_POST['satovertime7'] ."', 
    satlaborcode8 = '"
    $_POST['satlaborcode8'] ."', 
    satexchange8 = '"
    $_POST['satexchange8'] ."', 
    satworkjob8 = '"
    $_POST['satworkjob8'] ."', 
    satreghours8 = '"
    $_POST['satreghours8'] ."', 
    satovertime8 = '"
    $_POST['satovertime8'] ."', 
    satlaborcode9 = '"
    $_POST['satlaborcode9'] ."', 
    satexchange9 = '"
    $_POST['satexchange9'] ."', 
    satworkjob9 = '"
    $_POST['satworkjob9'] ."', 
    satreghours9 = '"
    $_POST['satreghours9'] ."', 
    satovertime9 = '"
    $_POST['satovertime9'] ."', 
    sunlaborcode0 = '"
    $_POST['sunlaborcode0'] ."', 
    sunexchange0 = '"
    $_POST['sunexchange0'] ."', 
    sunworkjob0 = '"
    $_POST['sunworkjob0'] ."', 
    sunreghours0 = '"
    $_POST['sunreghours0'] ."', 
    sunovertime0 = '"
    $_POST['sunovertime0'] ."', 
    sunlaborcode1 = '"
    $_POST['sunlaborcode1'] ."', 
    sunexchange1 = '"
    $_POST['sunexchange1'] ."', 
    sunworkjob1 = '"
    $_POST['sunworkjob1'] ."', 
    sunreghours1 = '"
    $_POST['sunreghours1'] ."', 
    sunovertime1 = '"
    $_POST['sunovertime1'] ."', 
    sunlaborcode2 = '"
    $_POST['sunlaborcode2'] ."', 
    sunexchange2 = '"
    $_POST['sunexchange2'] ."', 
    sunworkjob2 = '"
    $_POST['sunworkjob2'] ."', 
    sunreghours2 = '"
    $_POST['sunreghours2'] ."', 
    sunovertime2 = '"
    $_POST['sunovertime2'] ."', 
    sunlaborcode3 = '"
    $_POST['sunlaborcode3'] ."', 
    sunexchange3 = '"
    $_POST['sunexchange3'] ."', 
    sunworkjob3 = '"
    $_POST['sunworkjob3'] ."', 
    sunreghours3 = '"
    $_POST['sunreghours3'] ."', 
    sunovertime3 = '"
    $_POST['sunovertime3'] ."', 
    sunlaborcode4 = '"
    $_POST['sunlaborcode4'] ."', 
    sunexchange4 = '"
    $_POST['sunexchange4'] ."', 
    sunworkjob4 = '"
    $_POST['sunworkjob4'] ."', 
    sunreghours4 = '"
    $_POST['sunreghours4'] ."', 
    sunovertime4 = '"
    $_POST['sunovertime4'] ."', 
    sunlaborcode5 = '"
    $_POST['sunlaborcode5'] ."', 
    sunexchange5 = '"
    $_POST['sunexchange5'] ."', 
    sunworkjob5 = '"
    $_POST['sunworkjob5'] ."', 
    sunreghours5 = '"
    $_POST['sunreghours5'] ."', 
    sunovertime5 = '"
    $_POST['sunovertime5'] ."', 
    sunlaborcode6 = '"
    $_POST['sunlaborcode6'] ."', 
    sunexchange6 = '"
    $_POST['sunexchange6'] ."', 
    sunworkjob6 = '"
    $_POST['sunworkjob6'] ."', 
    sunreghours6 = '"
    $_POST['sunreghours6'] ."', 
    sunovertime6 = '"
    $_POST['sunovertime6'] ."', 
    sunlaborcode7 = '"
    $_POST['sunlaborcode7'] ."', 
    sunexchange7 = '"
    $_POST['sunexchange7'] ."', 
    sunworkjob7 = '"
    $_POST['sunworkjob7'] ."', 
    sunreghours7 = '"
    $_POST['sunreghours7'] ."', 
    sunovertime7 = '"
    $_POST['sunovertime7'] ."', 
    sunlaborcode8 = '"
    $_POST['sunlaborcode8'] ."', 
    sunexchange8 = '"
    $_POST['sunexchange8'] ."', 
    sunworkjob8 = '"
    $_POST['sunworkjob8'] ."', 
    sunreghours8 = '"
    $_POST['sunreghours8'] ."', 
    sunovertime8 = '"
    $_POST['sunovertime8'] ."', 
    sunlaborcode9 = '"
    $_POST['sunlaborcode9'] ."', 
    sunexchange9 = '"
    $_POST['sunexchange9'] ."', 
    sunworkjob9 = '"
    $_POST['sunworkjob9'] ."', 
    sunreghours9 = '"
    $_POST['sunreghours9'] ."', 
    sunovertime9 = '"
    $_POST['sunovertime9'] ."', 
    summlaborcode0 = '"
    $_POST['summlaborcode0'] ."', 
    summexchange0 = '"
    $_POST['summexchange0'] ."', 
    summworkjob0 = '"
    $_POST['summworkjob0'] ."', 
    summreghours0 = '"
    $_POST['summreghours0'] ."', 
    summovertime0 = '"
    $_POST['summovertime0'] ."', 
    summlaborcode1 = '"
    $_POST['summlaborcode1'] ."', 
    summexchange1 = '"
    $_POST['summexchange1'] ."', 
    summworkjob1 = '"
    $_POST['summworkjob1'] ."', 
    summreghours1 = '"
    $_POST['summreghours1'] ."', 
    summovertime1 = '"
    $_POST['summovertime1'] ."', 
    summlaborcode2 = '"
    $_POST['summlaborcode2'] ."', 
    summexchange2 = '"
    $_POST['summexchange2'] ."', 
    summworkjob2 = '"
    $_POST['summworkjob2'] ."', 
    summreghours2 = '"
    $_POST['summreghours2'] ."', 
    summovertime2 = '"
    $_POST['summovertime2'] ."', 
    summlaborcode3 = '"
    $_POST['summlaborcode3'] ."', 
    summexchange3 = '"
    $_POST['summexchange3'] ."', 
    summworkjob3 = '"
    $_POST['summworkjob3'] ."', 
    summreghours3 = '"
    $_POST['summreghours3'] ."', 
    summovertime3 = '"
    $_POST['summovertime3'] ."', 
    summlaborcode4 = '"
    $_POST['summlaborcode4'] ."', 
    summexchange4 = '"
    $_POST['summexchange4'] ."', 
    summworkjob4 = '"
    $_POST['summworkjob4'] ."', 
    summreghours4 = '"
    $_POST['summreghours4'] ."', 
    summovertime4 = '"
    $_POST['summovertime4'] ."', 
    summlaborcode5 = '"
    $_POST['summlaborcode5'] ."', 
    summexchange5 = '"
    $_POST['summexchange5'] ."', 
    summworkjob5 = '"
    $_POST['summworkjob5'] ."', 
    summreghours5 = '"
    $_POST['summreghours5'] ."', 
    summovertime5 = '"
    $_POST['summovertime5'] ."', 
    summlaborcode6 = '"
    $_POST['summlaborcode6'] ."', 
    summexchange6 = '"
    $_POST['summexchange6'] ."', 
    summworkjob6 = '"
    $_POST['summworkjob6'] ."', 
    summreghours6 = '"
    $_POST['summreghours6'] ."', 
    summovertime6 = '"
    $_POST['summovertime6'] ."', 
    summlaborcode7 = '"
    $_POST['summlaborcode7'] ."', 
    summexchange7 = '"
    $_POST['summexchange7'] ."', 
    summworkjob7 = '"
    $_POST['summworkjob7'] ."', 
    summreghours7 = '"
    $_POST['summreghours7'] ."', 
    summovertime7 = '"
    $_POST['summovertime7'] ."', 
    summlaborcode8 = '"
    $_POST['summlaborcode8'] ."', 
    summexchange8 = '"
    $_POST['summexchange8'] ."', 
    summworkjob8 = '"
    $_POST['summworkjob8'] ."', 
    summreghours8 = '"
    $_POST['summreghours8'] ."', 
    summovertime8 = '"
    $_POST['summovertime8'] ."', 
    summlaborcode9 = '"
    $_POST['summlaborcode9'] ."', 
    summexchange9 = '"
    $_POST['summexchange9'] ."', 
    summworkjob9 = '"
    $_POST['summworkjob9'] ."', 
    summreghours9 = '"
    $_POST['summreghours9'] ."', 
    summovertime9 = '"
    $_POST['summovertime9'] ."' 

    Where username = '"
    $_SESSION['user_name'] ."'"

    $query4 mysql_query($query2) or die(mysql_error()); 
    }

    echo 
    'Your timesheet has been sucessfully saved. <meta http-equiv="refresh" content="3; url=http://timesheet.helloworld.com/test/managers/managerspage.php">';

    }
    ?>
    [/PHP]
    Last edited by wickedneat; Aug 8, 2007 at 08:03.

  23. #23
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    #1 All those = '". $_POST['summovertime9'] ."' etc. can just be = '". $summovertime9 ."' since you have already put the data into variables.

    #2 A <meta> tag should be above the </head> tag.

    #3 We really need to see the WHOLE code to get a sense of what is happening. Without this I cannot offer any further assistance.
    Ian Anderson
    www.siteguru.co.uk

  24. #24
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you see my first post you can see the basic way it's laid out. Minus all the variables. It has a if statement above the form. Then it has the submit to database.

  25. #25
    SitePoint Guru
    Join Date
    Apr 2007
    Posts
    690
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In essence I need help saying:

    If you press submit, then submit all below data to database.

    else if you don't press submit do nothing.


    submission to database:

    If you press submit and there is nothing in database for username "Session_Usernam" then insert all the data into database.

    If you press submit and there is something in database for username "Session_Username" Then update all the data already in the database.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •