[!--quoteo(post=383064:date=Jun 12 2006, 08:47 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jun 12 2006, 08:47 PM)
I don't really understand your problem. How did you create the table in the first place. How did you create and define the fields that make up each row? How could you not actually know the structure of a database you created?
Doing a little reading will help you learn faster than just asking questions. At worst, you'll get the terminology right
the database I have created isnt a problem right now, even though... I will come back to them in a few month and wont have a clue what i called the fields with the tables.
I have created a small database with only 3 fields at the moment and there id, user and comment all i am doing in playing arround with these making sure i know how to delete move and change the information befor i even attempt to make anything with the connection.
I have a guest book installed on my server and i have been trying to access the information within there too and this is were i have had some problems, I know how to find the table names but im lost on how to find the field names and I have read a number of sites and looked through my referance books but non of these seem to consider the fact that you could be working on somthing that somone else has created.
I would of thought there would be a simple command to do this, it seems very logical to me?
anyway thanks for the links, I will go check them out now see if i can find anything there
Just so you know i found what i wanted thanks for the help