When writting an INSERT INTO, and the table doesn't exist for your query, how can you go about forcing a new table into a certain field?
Example:
PHP Code:
$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid,title,description,required,hidden,maxlength,size,displayorder,editable,type,data,height,def,optional,searchable,memberlist,regex,form,html) VALUES
In the above INSERT, i am trying to install a title in the table, but the title will not insert.
Right now the profilefield show's this
Quote:
profilefieldid,description,required,hidden,maxleng th,size,displayorder,editable,type,data,height,def ,optional,searchable,memberlist,regex,form,html
|
and i need to put title in to this section, so that right after profile field, it says "title" like this
Quote:
profilefieldid,title,description,required,hidden,m axlength,size,displayorder,editable,type,data,heig ht,def,optional,searchable,memberlist,regex,form,h tml
|
.......Is this even possible in 3.6, or do i need to try to write this for another table? I would really like this to be a profile addition, but i am not sure how to go about changing fields.
any help on this would be greatly appreciated. Hotwheels