Topic: 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.