Click here to Skip to main content
15,881,882 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: give me some advise for my linxu road! Pin
LloydA1116-Mar-10 12:03
LloydA1116-Mar-10 12:03 
GeneralRe: give me some advise for my linxu road! Pin
wbgxx10-Apr-10 20:27
wbgxx10-Apr-10 20:27 
AnswerRe: give me some advise for my linxu road! Pin
ChinaLoong20-Mar-10 1:54
ChinaLoong20-Mar-10 1:54 
QuestionSEO and php site Pin
sharkbc28-Jan-10 16:55
sharkbc28-Jan-10 16:55 
AnswerRe: SEO and php site Pin
vorotnik8-Feb-10 4:07
vorotnik8-Feb-10 4:07 
AnswerRe: SEO and php site Pin
abushahin8-Feb-10 9:14
abushahin8-Feb-10 9:14 
QuestionTimestamps... Can't Seem to get it to work..... Pin
thebiostyle27-Jan-10 14:23
thebiostyle27-Jan-10 14:23 
AnswerRe: Timestamps... Can't Seem to get it to work..... Pin
Graham Breach27-Jan-10 23:02
Graham Breach27-Jan-10 23:02 
The user name will be a text string, so you need to enclose it in quotes:
$sql = mysql_query("UPDATE members SET lastactive=NOW() WHERE username='$username'");

I've also replaced the DBNAME and TABLENAME with the actual name of your table, and replaced the single quotes around the SQL string with double quotes so that $username will be expanded.

Also, instead of:
$password = trim(md5($_POST['password']));

you probably want:
$password = md5(trim($_POST['password']));

- an MD5 hash won't have any spaces in it, but the password you pass to it might.
AnswerRe: Timestamps... Can't Seem to get it to work..... Pin
fly90428-Jan-10 1:07
fly90428-Jan-10 1:07 
QuestionPerl "days in the future" Pin
m. holliday20-Jan-10 9:32
m. holliday20-Jan-10 9:32 
AnswerRe: Perl "days in the future" Pin
Graham Breach20-Jan-10 10:11
Graham Breach20-Jan-10 10:11 
QuestionReiserFS disc accessing Pin
Aljaz11115-Jan-10 12:31
Aljaz11115-Jan-10 12:31 
AnswerRe: ReiserFS disc accessing Pin
Jimmanuel18-Jan-10 3:13
Jimmanuel18-Jan-10 3:13 
Questiondate difference script Pin
Jay Tee13-Jan-10 18:46
Jay Tee13-Jan-10 18:46 
AnswerRe: date difference script Pin
Rob15-Jan-10 4:16
Rob15-Jan-10 4:16 
AnswerRe: date difference script Pin
Sethsdad15-Jan-10 7:51
Sethsdad15-Jan-10 7:51 
GeneralRe: date difference script Pin
Justin20-Jan-10 21:24
Justin20-Jan-10 21:24 
QuestionI need an ebay program Pin
totolcm13-Jan-10 2:22
totolcm13-Jan-10 2:22 
Questionimap_search problem Pin
nathionice11-Jan-10 22:46
nathionice11-Jan-10 22:46 
AnswerRe: imap_search problem Pin
Niall Barr12-Jan-10 3:08
professionalNiall Barr12-Jan-10 3:08 
GeneralRe: imap_search problem Pin
nathionice12-Jan-10 4:05
nathionice12-Jan-10 4:05 
GeneralRe: imap_search problem Pin
Niall Barr12-Jan-10 4:44
professionalNiall Barr12-Jan-10 4:44 
GeneralRe: imap_search problem Pin
nathionice12-Jan-10 6:20
nathionice12-Jan-10 6:20 
GeneralRe: imap_search problem Pin
Niall Barr12-Jan-10 22:38
professionalNiall Barr12-Jan-10 22:38 
AnswerRe: imap_search problem Pin
elizas19-Jan-10 0:53
elizas19-Jan-10 0:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.