crazyal
Maddy
Hi all
So I have this piece of script
whereby the first line gets the date in a formatted way
however the date iin the $query always picks up what is already in the DB rather than the current date. What am I doing wrong? I did an echo of the $query and it shows the old date.
$f_today = date('Y-m-d H:i:s'); <-----------------
$query=mysqli_query($conn, "UPDATE Avatar SET
Avatar.SL_LEG_NAME = '$SL_LEG_NAME',
Avatar.CUR_DIF_LVL = '$CUR_DIF_LVL',
Avatar.TIMER_INCEPT = `$TIMER_INCEPT',
Avatar.TIMER_DIF_LVL_1 = '$TIMER_DIF_LVL_1',
Avatar.TIMER_DIF_LVL_2 = '$TIMER_DIF_LVL_2',
Avatar.TIMER_DIF_LVL_3 = '$TIMER_DIF_LVL_3',
Avatar.TIMER_DIF_LVL_4 = '$TIMER_DIF_LVL_4',
Avatar.TIMER_DIF_LVL_5 = '$TIMER_DIF_LVL_5',
Avatar.TIMER_TODAY = '$TIMER_TODAY',
Avatar.LAST_LOGON = '$f_today', <-----------------
Avatar.EXPERIENCE = '$EXPERIENCE',
Avatar.LIVRES_IN = '$LIVRES_IN',
Avatar.LIVRES_OUT = '$LIVRES_OUT',
Avatar.LINDEN_IN = '$LINDEN_IN',
WHERE Avatar.UUID = '$SL_UUID'");
So I have this piece of script
whereby the first line gets the date in a formatted way
however the date iin the $query always picks up what is already in the DB rather than the current date. What am I doing wrong? I did an echo of the $query and it shows the old date.
$f_today = date('Y-m-d H:i:s'); <-----------------
$query=mysqli_query($conn, "UPDATE Avatar SET
Avatar.SL_LEG_NAME = '$SL_LEG_NAME',
Avatar.CUR_DIF_LVL = '$CUR_DIF_LVL',
Avatar.TIMER_INCEPT = `$TIMER_INCEPT',
Avatar.TIMER_DIF_LVL_1 = '$TIMER_DIF_LVL_1',
Avatar.TIMER_DIF_LVL_2 = '$TIMER_DIF_LVL_2',
Avatar.TIMER_DIF_LVL_3 = '$TIMER_DIF_LVL_3',
Avatar.TIMER_DIF_LVL_4 = '$TIMER_DIF_LVL_4',
Avatar.TIMER_DIF_LVL_5 = '$TIMER_DIF_LVL_5',
Avatar.TIMER_TODAY = '$TIMER_TODAY',
Avatar.LAST_LOGON = '$f_today', <-----------------
Avatar.EXPERIENCE = '$EXPERIENCE',
Avatar.LIVRES_IN = '$LIVRES_IN',
Avatar.LIVRES_OUT = '$LIVRES_OUT',
Avatar.LINDEN_IN = '$LINDEN_IN',
WHERE Avatar.UUID = '$SL_UUID'");