change a column?

archgames · 08-06-2008, 05:51 AM

i have a gamepack for a script, but every game has over 1k plays i want to set the plays of every game to 0 is it possible to change just column in mysql. thanks

robbieray · 08-06-2008, 10:10 AM

Sent a pm

SlickEddie · 08-06-2008, 11:10 AM

using the phpmyadmin interface

update <table_name> set <column_name>=0

replace <table_name> with the name of the table and <column_name> with the name of the column

for example

update games set plays=0

archgames · 08-06-2008, 02:11 PM

thanks slick! worked

08-06-2008, 05:51 AM	#1 (permalink)
archgames Senior Member Join Date: Jan 2008 Posts: 994	change a column? i have a gamepack for a script, but every game has over 1k plays i want to set the plays of every game to 0 is it possible to change just column in mysql. thanks __________________ Quotes: "I do not have superior intelligence or faultless looks. I do not captivate a room or run a mile under six minutes. I only succeeded because I was still working after everyone else went to sleep." "I've missed over 9,000 shots in my career. I've lost almost 300 games. 26 times I've been trusted to take the game-winning shot . . . and missed. I've failed over and over and over again in my life. And that is why I succeed." <?php echo "The end"; ?>

08-06-2008, 10:10 AM	#2 (permalink)
robbieray Senior Member Join Date: Feb 2008 Location: uk Posts: 353	Sent a pm __________________ http://oxidearcade.com Try this guys free http://www.webmasterstools.net Cheap Domains http://www.247regdomains.com

08-06-2008, 02:11 PM	#4 (permalink)
archgames Senior Member Join Date: Jan 2008 Posts: 994	thanks slick! worked __________________ Quotes: "I do not have superior intelligence or faultless looks. I do not captivate a room or run a mile under six minutes. I only succeeded because I was still working after everyone else went to sleep." "I've missed over 9,000 shots in my career. I've lost almost 300 games. 26 times I've been trusted to take the game-winning shot . . . and missed. I've failed over and over and over again in my life. And that is why I succeed." <?php echo "The end"; ?>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking for someone to change my shockscript site into...	bobbyr	Talk Arcades	5	07-29-2008 10:53 AM
Name Change?	JanArve	The Lounge	6	07-17-2008 03:13 PM
How can I do this column?	New-Games	Arcadem Pro	2	05-18-2008 02:58 PM
Aadavark TopSites Script - Change Password?	peter_anderson	Scripts & Software	2	04-04-2008 03:34 PM
How do you change default admin pass?	Ragnarok96	GameSiteScript	2	02-25-2007 09:33 PM

08-06-2008, 11:10 AM	#3 (permalink)
SlickEddie Full Member Join Date: Jul 2008 Posts: 57	using the phpmyadmin interface update <table_name> set <column_name>=0 replace <table_name> with the name of the table and <column_name> with the name of the column for example update games set plays=0