Overclock.net - Overclocking.net
     
 
Home Gallery Reviews Blogs Register Today's Posts Mark Forums Read Members List


Go Back   Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Web Coding
Reload this Page [PHP] Error?

Reply
 
LinkBack Thread Tools
Old 02-04-08   #1 (permalink)
Audiophile
 
F3t1sh's Avatar
 
intel ati

Join Date: Oct 2006
Location: Gatineau, Quebec
Posts: 799
Blog Entries: 4

Rep: 36 F3t1sh is acknowledged by some
Unique Rep: 26
Hardware Reviews: 1
Trader Rating: 0
Default [PHP] Error?
Whenever i try to add a column through php to my sql server.
Nothing I tried worked so can i have someones input on how to do this.

All i need is to execute some mysql query:

Code:
ALTER TABLE tablename auto_increment = 1;
P.S. The account has all the rights granted to it....
__________________


My Votes



31D8M4a1r1k

System: lolz
CPU
Q6600 GO @ 3.6 1.47v (400*9)		 Motherboard
Abit IP35 Pro		 Memory
Crucial Ballistix 4x1GB 		Graphics Card
HIS Radeon 3870x2
Hard Drive
RAID0 - Seagate Barracuda 160GB		 Sound Card
AuzenTech Auzen Prelude		 Power Supply
GameXStream 700W		 Case
Ultra Aluminus
CPU cooling
Xigmatek S1283 w/Backplate mod		 OS
Vista HP 64Bit		 Monitor
Samsung 225BW
Last edited by F3t1sh : 02-04-08 at 08:22 PM.
F3t1sh is offline F3t1sh's Gallery   Reply With Quote
Old 02-04-08   #2 (permalink)
Hebrew Hammer
 
TheLegend's Avatar
 
intel nvidia

Join Date: Jan 2006
Location: Milwaukee, WI
Posts: 5,719

FAQs Submitted: 1
Trader Rating: 21
Default
Shouldn't it read auto-increment as 1? You cannot incrementing anything by 0.
__________________
|
PC Audio Setup:
JRiver Media Center ASIO(FLAC) > E-MU 0404 USB > LD MKIII > Grado SR225 / HD555

Fold for 37726
Folding Team "Just Be Cause" Honorary Member

System: Legendary
CPU
E6750		 Motherboard
ASUS P5B Deluxe		 Memory
2 x 2GB G.Skill PQ 		Graphics Card
XFX 8800GT [721|1802|2050]
Hard Drive
Seagate 250GB x 2		 Sound Card
X-Fi XtremeMusic		 Power Supply
PC P&C Quad 750W Silencer		 Case
Thermaltake Tsunami Dream
CPU cooling
Tuniq Tower 120 | Lapped		 OS
Vista x64		 Monitor
Samsung 225BW
TheLegend is offline Overclocked Account   Reply With Quote
Old 02-04-08   #3 (permalink)
Audiophile
 
F3t1sh's Avatar
 
intel ati

Join Date: Oct 2006
Location: Gatineau, Quebec
Posts: 799
Blog Entries: 4

Rep: 36 F3t1sh is acknowledged by some
Unique Rep: 26
Hardware Reviews: 1
Trader Rating: 0
Default
Quote:
Originally Posted by TheLegend View Post
Shouldn't it read auto-increment as 1? You cannot incrementing anything by 0.
:P fixed but none the less it's not doing anything, say I try to alter a table to insert a column, it won't insert it.
__________________


My Votes



31D8M4a1r1k

System: lolz
CPU
Q6600 GO @ 3.6 1.47v (400*9)		 Motherboard
Abit IP35 Pro		 Memory
Crucial Ballistix 4x1GB 		Graphics Card
HIS Radeon 3870x2
Hard Drive
RAID0 - Seagate Barracuda 160GB		 Sound Card
AuzenTech Auzen Prelude		 Power Supply
GameXStream 700W		 Case
Ultra Aluminus
CPU cooling
Xigmatek S1283 w/Backplate mod		 OS
Vista HP 64Bit		 Monitor
Samsung 225BW
F3t1sh is offline F3t1sh's Gallery   Reply With Quote
Old 02-04-08   #4 (permalink)
Hebrew Hammer
 
TheLegend's Avatar
 
intel nvidia

Join Date: Jan 2006
Location: Milwaukee, WI
Posts: 5,719

FAQs Submitted: 1
Trader Rating: 21
Default
How is your table defined?
__________________
|
PC Audio Setup:
JRiver Media Center ASIO(FLAC) > E-MU 0404 USB > LD MKIII > Grado SR225 / HD555

Fold for 37726
Folding Team "Just Be Cause" Honorary Member

System: Legendary
CPU
E6750		 Motherboard
ASUS P5B Deluxe		 Memory
2 x 2GB G.Skill PQ 		Graphics Card
XFX 8800GT [721|1802|2050]
Hard Drive
Seagate 250GB x 2		 Sound Card
X-Fi XtremeMusic		 Power Supply
PC P&C Quad 750W Silencer		 Case
Thermaltake Tsunami Dream
CPU cooling
Tuniq Tower 120 | Lapped		 OS
Vista x64		 Monitor
Samsung 225BW
TheLegend is offline Overclocked Account   Reply With Quote
Old 02-04-08   #5 (permalink)
PC Gamer
 
Evostance's Avatar
 
intel nvidia

Join Date: Oct 2007
Posts: 960

Rep: 39 Evostance is acknowledged by some
Unique Rep: 35
Trader Rating: 0
Default
That just automatically gives the row an id so you dont have to put it in

System: BlackMagic
CPU
E6750 @ 3.3ghz		 Motherboard
Asus P5N-E Sli 650i		 Memory
Ballistix Tracers 2gb 6400 		Graphics Card
XFX 8800GTS 640mb @ 710/1100
Hard Drive
2x 160gb Hitachi Raid0, 1x Seagate 500gb		 Sound Card
XFI XtremeGamer		 Power Supply
Win Power 750W		 Case
ThermalTake Kandalf Black
CPU cooling
Intel CPU Cooler		 GPU cooling
Another badly placed fan		 OS
Vista Business x86		 Monitor
Samsung T220
Evostance is offline   Reply With Quote
Old 02-04-08   #6 (permalink)
Audiophile
 
F3t1sh's Avatar
 
intel ati

Join Date: Oct 2006
Location: Gatineau, Quebec
Posts: 799
Blog Entries: 4

Rep: 36 F3t1sh is acknowledged by some
Unique Rep: 26
Hardware Reviews: 1
Trader Rating: 0
Default
Code:
mysql_query("ALTER TABLE room ADD ID INT");
Doesn't work.
__________________


My Votes



31D8M4a1r1k

System: lolz
CPU
Q6600 GO @ 3.6 1.47v (400*9)		 Motherboard
Abit IP35 Pro		 Memory
Crucial Ballistix 4x1GB 		Graphics Card
HIS Radeon 3870x2
Hard Drive
RAID0 - Seagate Barracuda 160GB		 Sound Card
AuzenTech Auzen Prelude		 Power Supply
GameXStream 700W		 Case
Ultra Aluminus
CPU cooling
Xigmatek S1283 w/Backplate mod		 OS
Vista HP 64Bit		 Monitor
Samsung 225BW
F3t1sh is offline F3t1sh's Gallery   Reply With Quote
Old 02-04-08   #7 (permalink)
Audiophile
 
F3t1sh's Avatar
 
intel ati

Join Date: Oct 2006
Location: Gatineau, Quebec
Posts: 799
Blog Entries: 4

Rep: 36 F3t1sh is acknowledged by some
Unique Rep: 26
Hardware Reviews: 1
Trader Rating: 0
Default
WOW im an idiot, sorry, it works 100%
__________________


My Votes



31D8M4a1r1k

System: lolz
CPU
Q6600 GO @ 3.6 1.47v (400*9)		 Motherboard
Abit IP35 Pro		 Memory
Crucial Ballistix 4x1GB 		Graphics Card
HIS Radeon 3870x2
Hard Drive
RAID0 - Seagate Barracuda 160GB		 Sound Card
AuzenTech Auzen Prelude		 Power Supply
GameXStream 700W		 Case
Ultra Aluminus
CPU cooling
Xigmatek S1283 w/Backplate mod		 OS
Vista HP 64Bit		 Monitor
Samsung 225BW
F3t1sh is offline F3t1sh's Gallery   Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools



All times are GMT -4. The time now is 08:11 PM.

Contact Us - Overclock.net - Archive - Top

Overclock.net is a Carbon Neutral Site Creative Commons License Internet Security By ControlScan

Terms of Service / Forum Rules | Privacy Policy | Advertising | Become an Official Vendor
Copyright © 2008 Shogun Interactive Development. Most rights reserved.
Page generated in 0.15560 seconds with 9 queries