Changing Data In MySQL Through PHP

[tomyknoker]

Hiya ok I received a parse error I tried to see what it was but couldn't I'm probably going blind!

mysql_query("UPDATE `tblmembers` SET `status`='$status' WHERE `userID`='$id'");

header('Location: '.$_SERVER["PHP_SELF"]);
  }

  else { 

[thetestingsite]

Hiya ok I received a parse error I tried to see what it was but couldn't I'm probably going blind!

mysql_query("UPDATE `tblmembers` SET `status`='$status' WHERE `userID`='$id'");

header('Location: '.$_SERVER["PHP_SELF"]);
  }

  else { 

What's the parse error?

[tomyknoker]

Hiya a parse error I can't seem to find it ug!

Parse error: parse error, expecting `']'' in e:\showMembers.php on line 94
PHP Parse error: parse error, expecting `']'' in e:\showMembers.php on line 94

[thetestingsite]

That has to do with this line:

  elseif ($_REQUEST['act'] == "edit") {
 $id = $_REQUEST['id'];
 $status = $_REQUEST['status'];

I forgot about the quote. Hope this helps.

[tomyknoker]

Ahhhhh great! For some reason the loginDateTime are all equal to 1-1-1970, I can understand that happening for users who haven't logged in yet but all the Approved users are equal to that... I added this line

<?php echo date('d-m-Y', $q['loginDateTime']):'unknown';?>

but this gives me the following error

Parse error: parse error, expecting `','' or `';'' in e:\showMembers.php on line 179
PHP Parse error: parse error, expecting `','' or `';'' in e:\showMembers.php on line 179

[thetestingsite]

This:

<?php echo date('d-m-Y', $q['loginDateTime']):'unknown';?>

makes no sense. Does your loginDateTime column (in your database) have the values as a unix timestamp (like 1175581024), or is it text (Jan 12, 2008)? If the first, then this should work:

<?php echo date('d-m-Y', $q['loginDateTime']);?>

Otherwise, try using this:

<?php echo date('d-m-Y', strtotime($q['loginDateTime']));?>

Hope this helps.

[tomyknoker]

Hiya, in the database the fields look like this

I added this code as I had this before, what it did was displayed the date/time a user had logged in and if they hadn't logged in since I added the loginDateTime column to the datatabase that field in the table was just populated with 'unknown'... But they are all unknown and looking into the datatbase I can see quite a few that have logged in

<?php echo($qry['loginDateTime']?date('d/m/Y H:i:s', strtotime($qry['loginDateTime'])):'unknown') ?>

[thetestingsite]

What if you just do:

<?php echo $qry['loginDateTime'];?>

See what it displays (if anything) and if you would like, go ahead and send me a screenshot. Not sure what else there is to say, but the code that is posted in one of my posts above should work.

Hope this helps.

[tomyknoker]

I sent you the screenshot, my very original page before all the sorting had that code too and it worked, It's wierd... Could it be to do with the sort feature?