Jump to content

Archived

This topic is now archived and is closed to further replies.

Avalanche

It just won't insert!

Recommended Posts

[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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.