Hello,
I'm using PhpMyAdmin for the first time. A few questions:
Background:
I have the version of phpmyadmin with .php3 extensions. The site is being hosted on pair.com. Pair.com supports php4.
Question1:
When I run phpmyadmin it warns me that magic_quotes are not on, and that they need to be to run the program correctly. Since I do not have my own server how do I change this? Will it really be a problem if I leave them off?
Question2:
In creating my first table, I am using 8 fields. From what I understand they should all be indexed if I want to run a search on them later. Is that correct?
Question3:
Assuming they all have to be indexed, I know that the max index is 255, so on the varchars I am typing 20 in the "length/set" columns because I believe the values won't ever be bigger than 20. Is that the corrct approach?
Question4:
Under "attributes" what is the difference between binary, unsigned, and unsigned zerofill, and just leaving it blank? I have the year field as "unsigned zerofill" because I read that zerofill means that whatever is typed in the "length/set" column is definite (the year will always be 4.) All the other fields are blank.
Sorry for all the beginner questions, any help is greatly appreciated. Thanks,
Dan
