Web Hosting Forum | Lunarpages

Author Topic: How to undo an SQL query  (Read 7279 times)

Offline chadz

  • Newbie
  • *
  • Posts: 5
    • http://chadzboyz.com
How to undo an SQL query
« on: July 13, 2005, 04:33:55 AM »
I installed the following query using phpMyAdmin for a MOD.

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO `phpbb_config` ( `config_name` , `config_value` ) VALUES ('users_online_today', '24');

#
Now I would like to remove the mod and undo the query. Do I just submit the same query by replacing INSERT INTO with something like ____??? Or can I just leave it there?

Offline scanman20

  • Senior Moderator
  • Über Jedi
  • *****
  • Posts: 1552
    • http://www.notonebit.com
Re: How to undo an SQL query
« Reply #1 on: July 13, 2005, 05:01:33 AM »
Go into phpmyadmin and in the phpbb_config table delete the row that you entered.
Even a broken clock is right twice a day.
NotOneBit.com
MCSE - MCSA - MCP (<- unused since 2006!)

Offline Nibbler

  • 21st century digital boy
  • Master Jedi
  • *****
  • Posts: 1168
    • Coppermine
Re: How to undo an SQL query
« Reply #2 on: July 13, 2005, 06:00:09 AM »
Code: [Select]
DELETE FROM  `phpbb_config` WHERE `config_name` = 'users_online_today' LIMIT 1
Missing since 1983


Offline chadz

  • Newbie
  • *
  • Posts: 5
    • http://chadzboyz.com
Re: How to undo an SQL query
« Reply #3 on: July 13, 2005, 10:36:24 AM »
Thanks but now I'm thinking I may want to keep the MOD for phpbb installed. The problem is the list of users online for the past 24 hours displays in a very long narrow column instead of across the page.
See the example in the forum I am working on here:
http://www.chadzboyz.com/chadforum/   then scroll down

Is there a way to adjust the table of online users in the last 24 hours so it displays across the page instead of vertically in a long narrow column. I'm not that familiar with phpmyadmin but I can try :) It seems I need to change some table parameters somewhere in the two tables created with the above SQL.

Offline Nibbler

  • 21st century digital boy
  • Master Jedi
  • *****
  • Posts: 1168
    • Coppermine
Re: How to undo an SQL query
« Reply #4 on: July 13, 2005, 11:46:26 AM »
Ah, that won't be in the database. You need to change the html output, and add a colspan="2" into the <td> that's displaying the new data.
Missing since 1983


Offline chadz

  • Newbie
  • *
  • Posts: 5
    • http://chadzboyz.com
Re: How to undo an SQL query
« Reply #5 on: July 13, 2005, 01:02:06 PM »
Ahhh, thank you so much...that did the trick

 

Share |