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

Linux, Apache, MySQL, PHP

 
JokeRe: give me some advise for my linxu road! PinPopular
Richard MacCutchan16-Feb-10 2:45
mveRichard MacCutchan16-Feb-10 2:45 
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 
Okay, I tried using W3Schools to "UPDATE" a timestamp, upon logging in, here is my code:

$sql = mysql_query('UPDATE `DBNAME`.`TABLENAME` SET `lastactive` = NOW() WHERE `TABLENAME`.`username` = $username ;');


Here is the login code:

if(isset($_POST['login'])){
$username= trim($_POST['username']);
$password = trim(md5($_POST['password']));
if($username == NULL OR $password == NULL){
$final_report.="Please complete all the fields below..";
}else{
$check_user_data = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'") or die(mysql_error());
if(mysql_num_rows($check_user_data) == 0){
$final_report.="The username that you submitted does not exist..";
}else{
$get_user_data = mysql_fetch_array($check_user_data);
if($get_user_data['password'] == $password){
$start_idsess = $_SESSION['username'] = "".$get_user_data['username']."";
$start_passsess = $_SESSION['password'] = "".$get_user_data['password']."";


That is the code above the timestamp issue. The page loads and everything, it just doesn't update it into the database... Please Help. Thanks!
AnswerRe: Timestamps... Can't Seem to get it to work..... Pin
Graham Breach27-Jan-10 23:02
Graham Breach27-Jan-10 23:02 
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 

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.