Help! I am still trying to write my own web interface for a MySQL back end database, I know phpMyAdmin is out there but doing this is really helping me learn both MySQL and PHP inside out.
I am stumped, though, when trying to alter a table, specifically when trying to create an index or adding a primary key to a column that has already been set to NULL or not given NOT NULL in the first place. I try the mysql_field_flags, but as we all know, this does not give the proper specifics about the column flags. When trying DESCRIBE in mysql_query, it only returns the number of fields in the table and nothing more.
Can it be done? Can I find out the specific column settings or am I stuck with if the column wasn't set up properly in the first place we have to settle with what we have instead? Anyone can help I would really appreciate it.
Jim Hawley
