Update an existing field with date

[mrfloyd]

I am a layperson, please be gentle.

I have a login script that works fairly well. It sets cookies for people that login.
I would like to have that persons datetime field get updated whenever he revisits the site if his cookie is still active.

I added 4 lines of code that should do it, but does not<heavy sigh>... the result is a blank screen, I remove the lines and all is back and OK.

Here is the code.. I added a few lines before and after so you can see the setup...
My problem lines are numbered #1...#4...

Thanks in advance

function displayLogin()
{
   global $logged_in;
   if($logged_in)
   {
        //FK----attempt to update datetime field for people that log visits to the site
//	$query = "UPDATE users SET datetime=date("Y.m.d - H:i:s"),  //Line#1
//	WHERE username='$_SESSION[username]'"; 		//Line#2

//	$result = mysql_query($conn, $query)			//Line#3
//		or die ("could not execute the query.");    	//Line#4
         //FK-----attempt end 

echo "<br><h1>Logged In!<br><br></h1>";
echo "Hello <b>$_SESSION[username]</b> you are logged in.<br>

You can see the // where I been tesing to control those lines
(Maybe you can also tell me how to disply the error message rather than just a blank screen)

Any help would be very appreciated.. please be simple in you explanations
Thanks in advance.

[HalfaBee]

You need to do this.

$query = "UPDATE users SET datetime='" . date("Y-m-d - H:i:s") . "',  //Line#1
//	

assuming you are using the current date to update the field.

For debugging issues like this do

or die( mysql_error() . $sql );

[mrfloyd]

Hi Half
Thanks for getting back
I had just got it solved.... with this

//FK----update datetime db field when registered people visits the site
$date = date("Y.m.d - H:i:s");
$sql_update = "UPDATE users SET datetime='{$date}' WHERE username='{$_SESSION['username']}';";
mysql_query($sql_update)  or die ("could not execute the query:". mysql_error());
//FK-----update end

I tried your solution but I received a 'could not execute the query' message, so that means I had another bug in my code.
Thanks again for looking amigo
Floyd

[laserlight]

I tried your solution but I received a 'could not execute the query' message

And what might the error message provided by mysql_error() be?

[mrfloyd]

Hi Laser,

Im not very good at this but I have been having problems with the mysql_error() reporting.... it did not report a message.

On that particular code, the only message on the entire screen was the verbal 'could not execute the query'