Web Hosting Forum | Lunarpages
News: July 14, 2008 - New Contest! - Submit Your WordPress Theme Designs, Win BIG!
August 5, 2008 - Time to Submit Your Links for the August 08 Site of the Month Award!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
August 21, 2008, 01:45:17 AM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: How to undo an SQL query  (Read 1516 times)
chadz
Newbie
*
Offline Offline

Posts: 5


WWW
« on: July 13, 2005, 05: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?
Logged
scanman20
Master Jedi
*****
Offline Offline

Posts: 1216



WWW
« Reply #1 on: July 13, 2005, 06:01:33 AM »

Go into phpmyadmin and in the phpbb_config table delete the row that you entered.
Logged

Even a broken clock is right twice a day.
NotOneBit.com
MCSE - MCSA - MCP
Nibbler
21st century digital boy
Master Jedi
*****
Offline Offline

Posts: 1184



WWW
« Reply #2 on: July 13, 2005, 07:00:09 AM »

Code:
DELETE FROM  `phpbb_config` WHERE `config_name` = 'users_online_today' LIMIT 1
Logged

Missing since 1983

chadz
Newbie
*
Offline Offline

Posts: 5


WWW
« Reply #3 on: July 13, 2005, 11: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 Smile It seems I need to change some table parameters somewhere in the two tables created with the above SQL.
Logged
Nibbler
21st century digital boy
Master Jedi
*****
Offline Offline

Posts: 1184



WWW
« Reply #4 on: July 13, 2005, 12:46:26 PM »

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.
Logged

Missing since 1983

chadz
Newbie
*
Offline Offline

Posts: 5


WWW
« Reply #5 on: July 13, 2005, 02:02:06 PM »

Ahhh, thank you so much...that did the trick
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.3 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM