Avalanche Posted May 18, 2003 Share Posted May 18, 2003 [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. Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/ Share on other sites More sharing options...
Nairb Posted May 18, 2003 Share Posted May 18, 2003 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 Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/#findComment-1617 Share on other sites More sharing options...
Avalanche Posted May 18, 2003 Author Share Posted May 18, 2003 It still won\'t work. I also tried removing the if argument, and optimizing the table in phpMyAdmin (becaue apparently it needed optimization). Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/#findComment-1618 Share on other sites More sharing options...
Nairb Posted May 18, 2003 Share Posted May 18, 2003 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? Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/#findComment-1619 Share on other sites More sharing options...
Avalanche Posted May 18, 2003 Author Share Posted May 18, 2003 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?) Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/#findComment-1620 Share on other sites More sharing options...
Avalanche Posted May 18, 2003 Author Share Posted May 18, 2003 Nevermind, figured it out. Link to comment https://forums.phpfreaks.com/topic/480-it-just-wont-insert/#findComment-1621 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.