Its always best to just carry cash. Pay for food at a restaurant with cash. Pay for stuff at the store with cash. There are so many advantages, including limited...

Never mind. I just had it update individual columns. Dynamic columns not going to work for me. Thanks anyway people!:D

Okay, here is the table:

CREATE TABLE [dbo].[Experience] (

[ID] [int] IDENTITY (1, 1) NOT NULL ,

[FirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[LastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[varchar] (50) COLLATE...

Okay, it is set up in an array on my site. It is the photo names. Instead of inserting each individual image name, it should be namable as photo1, photo2,...

Thanks, but that didn't work. I got an invalid column name error. it said that the photoname.jpg was an invalde name. hmmm...