Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12349
Latest: SUCCESSForum
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 40048
Total Topics: 7051
Most Online Today: 39
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 19
Total: 19

Author Topic: Replace into MySQL question  (Read 2338 times)

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 653
    • View Profile
    • Homework Clinic - Your Academic Lifeline
Replace into MySQL question
« on: August 17, 2016, 05:37:26 pm »
Code: [Select]
$request = db_query("
            REPLACE INTO {$db_prefix}log_activity (date, topics, posts, registers) values('$myDate', $val[topic_count], $val[message_count], $val[member_count])",
        __FILE__, __LINE__);

When I run this query, it makes the last column "mostON" to 0. How can I alter this query so that it leaves the values for "mostON" column the way they are :-\

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15029
    • View Profile
Re: Replace into MySQL question
« Reply #1 on: August 17, 2016, 06:12:18 pm »
It changes the whole table?
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
4472 Views
Last post October 15, 2007, 10:00:33 pm
by ApplianceJunk
1 Replies
2981 Views
Last post January 31, 2008, 05:28:27 pm
by SMFHacks
0 Replies
1673 Views
Last post October 12, 2010, 05:49:10 pm
by mxcape21
3 Replies
2265 Views
Last post May 27, 2013, 07:51:48 pm
by SMFHacks
4 Replies
4315 Views
Last post July 11, 2016, 12:50:54 pm
by shuban

+- Recent Topics

[Mod]Avatars Display Integration by SMFHacks
February 15, 2020, 07:30:47 pm

[Mod]BBC Message Boxes 1.0 by SMFHacks
February 15, 2020, 07:26:46 pm

[Mod]Stack Trace by live627 by SMFHacks
February 15, 2020, 07:21:33 pm

Stripe Integration by SMFHacks
February 08, 2020, 10:55:29 pm

SMF Store 4.0 Released by SMFHacks
January 26, 2020, 12:11:56 pm

Order of photos by D4611001
January 21, 2020, 12:06:36 pm

Cannot install by SMFHacks
January 18, 2020, 09:40:56 pm

Call to undefined function mysql_query() by SMFHacks
January 18, 2020, 02:06:47 pm

English British Translation file by HAL9000
January 17, 2020, 05:44:28 pm

Characters dispayed as boxes by SMFHacks
January 16, 2020, 07:21:51 am

Powered by EzPortal