It just won't insert!

[Avalanche]

[php:1:20ca43efce]// Record in change logs if roster_trackchanges is 1

if ($roster_trackchanges == 1) {

$query_changes = \"INSERT INTO roster_changes(er, ee, type, date, time)

VALUES(\'user\',\'\".$_SESSION[mem_alias].\"\',\'edited\',date(), time())\";

mysql_query($query_changes);

}[/php:1:20ca43efce]

 

I added a \"else { echo \"hey hey\"; }\" but the \"hey hey\" didn\'t come up, so $roster_trackchanges IS 1, it just doesn\'t insert.

[Nairb]

Try assigning the session, so you dont have to break it, or w/e

 

[php:1:8452372283]

if ($roster_trackchanges == 1) {

$session = $_SESSION[mem_alias];

 

$query_changes = \"INSERT INTO roster_changes(er, ee, type, date, time)

VALUES(\'user\',\'$session\',\'edited\',date(), time())\";

mysql_query($query_changes);

}

[/php:1:8452372283]

 

Try that, it\'s all I can think of

[Avalanche]

It still won\'t work. I also tried removing the if argument, and optimizing the table in phpMyAdmin (becaue apparently it needed optimization).

[Nairb]

Lol, hmmm...

Once again, try assigning some stuff:

 

[php:1:4eac3f3181]

if ($roster_trackchanges == 1) {

$session = $_SESSION[mem_alias];

$date = date();

$time = time();

 

$query_changes = \"INSERT INTO roster_changes(er, ee, type, date, time)

VALUES(\'user\',\'$session\',\'edited\',\'$date,\' \'$time\')\";

mysql_query($query_changes);

}

[/php:1:4eac3f3181]

 

Again, just a suggestion?

[Avalanche]

Yeah, I just now figured out you don\'t put the apostrophes around the field names, just the values.

 

Anyway, thanks.

 

(PS: When I tried inserting a time() into my database it came out like 839:49:49 when it\'s 4:43... the field type is time; should it be timestamp?)

[Avalanche]

Nevermind, figured it out.