Member Avatar for youvi

please clear the syntax error...

$locker_query ="update tbl_locker set locker_title='".$locker_title."',headline_text='".$locker_headline."',introductory_text='".$locker_intro_text."',popup_delay='". $locker_delay ."',repopup_frequency='".$locker_frequency."',forced_completion='".$locker_force_offer."',email_id='".$locker_email."',created_date=now(),guid='" . md5(time()). "' 
where locker_id='".20."'";

Thanks

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for diafol

Youvi - this is something you can do yourself I'm sure. You don't need to use concatenators (.) all over the place. For example:

$tm = md5(time());
$query = "UPDATE table1 SET `field1` = '$value1', `field2` = '$tm' WHERE `field3` = '$value3'";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.