Jump to content


Photo

It just won't insert!


  • Please log in to reply
5 replies to this topic

#1 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 18 May 2003 - 07:00 PM

[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.
DEFINE("YOU","Spending Too Much Time On The Computer");

#2 Nairb

Nairb
  • Members
  • PipPip
  • Member
  • 18 posts
  • LocationCanada

Posted 18 May 2003 - 07:13 PM

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

#3 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 18 May 2003 - 08:15 PM

It still won\'t work. I also tried removing the if argument, and optimizing the table in phpMyAdmin (becaue apparently it needed optimization).
DEFINE("YOU","Spending Too Much Time On The Computer");

#4 Nairb

Nairb
  • Members
  • PipPip
  • Member
  • 18 posts
  • LocationCanada

Posted 18 May 2003 - 08:39 PM

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?

#5 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 18 May 2003 - 08:44 PM

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?)
DEFINE("YOU","Spending Too Much Time On The Computer");

#6 Avalanche

Avalanche
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts

Posted 18 May 2003 - 08:54 PM

Nevermind, figured it out.
DEFINE("YOU","Spending Too Much Time On The Computer");




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users