Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12388
Latest: Rands
New This Month: 5
New This Week: 2
New Today: 0
Stats
Total Posts: 40308
Total Topics: 7099
Most Online Today: 43
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 44
Total: 44

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

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 657
    • 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: 15147
    • 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
4549 Views
Last post October 15, 2007, 10:00:33 pm
by ApplianceJunk
1 Replies
3057 Views
Last post January 31, 2008, 05:28:27 pm
by SMFHacks
0 Replies
1723 Views
Last post October 12, 2010, 05:49:10 pm
by mxcape21
3 Replies
2359 Views
Last post May 27, 2013, 07:51:48 pm
by SMFHacks
4 Replies
4409 Views
Last post July 11, 2016, 12:50:54 pm
by shuban

+- Recent Topics

Quality of images after import by SMFHacks
September 05, 2020, 10:21:44 am

How do I download gallery images? by CWVRV
August 30, 2020, 11:50:07 pm

Deleting Empty Galleries by SMFHacks
August 30, 2020, 11:43:32 am

PHP error by davejo
August 25, 2020, 07:35:13 am

Permissions to list ads and buy items by CWVRV
August 21, 2020, 05:19:45 pm

Doubt with download permissions. by Rock Lee
August 20, 2020, 08:23:24 pm

Attachment images Upsidedown or Sideways by SMFHacks
August 18, 2020, 05:41:07 pm

[Mod]Avatars Display Integration by Hatshepsut
August 17, 2020, 11:39:54 pm

Simple Portal Block - Classifieds by SMFHacks
August 16, 2020, 09:56:48 am

SMF Links by SMFHacks
August 16, 2020, 08:03:42 am

Powered by EzPortal