How to update a single "cell" in MySQL?

[wisteria456]

I'm at a loss. 🙂 Of course...

Anyway, I've spent the day hashing out the code from scraps, and finally I'm able to log in. Now, what I'm trying to do is update a field called "date" with the SQL function CURDATE() so that when someone logs in, it will set their cell to the current date.

What I have is a real estate calendar type system, which, should ideally pop-up a list of things that need doing that day when one of my agents logs in. But, I can't make the date populate for a single cell.

I'm sure it's something simple, but I can't figure it out.

This is the code fragment I'm trying to use, without success:

mysql_query("UPDATE TABLE users date=curdate() WHERE id='$result'",$db);

~Kristi

[erikwebb]

Try this instead:

mysql_query("UPDATE users SET date=curdate() WHERE id='$result'",$db); 

[wisteria456]

Thanks. That's what was wrong. 🙂

You're the best. 🙂

~Kristi

[erikwebb]

I know. 🙂

Please remember to mark these sort of threads resolved.