Hi there, as you can tell I am a beginner with mysql and phprunner (recently purchased for a project that I am working on).
I'm not sure what I am trying to do is possible and some guidance would greatly be appreciated.
I have a _table
with the following
SID int(11) No auto_increment
edi varchar(10) latin1_swedish_ci Yes NULL
name varchar(100) latin1_swedish_ci Yes NULL
contact varchar(50) latin1_swedish_ci Yes NULL
address1 varchar(100) latin1_swedish_ci Yes NULL
address2 varchar(100) latin1_swedish_ci Yes NULL
address3 varchar(100) latin1_swedish_ci Yes NULL
suburb varchar(50) latin1_swedish_ci Yes NULL
region varchar(50) latin1_swedish_ci Yes NULL
state varchar(50) latin1_swedish_ci Yes NULL
postcode varchar(5) latin1_swedish_ci Yes NULL
mainphone varchar(50) latin1_swedish_ci Yes NULL
fax varchar(50) latin1_swedish_ci Yes NULL
email varchar(100) latin1_swedish_ci Yes NULL
type varchar(50) latin1_swedish_ci Yes NULL
comments mediumtext latin1_swedish_ci Yes NULL
updated timestamp ON UPDATE CURRENT_TIMESTAMP No CURRENT_TIMESTAMP
addrecord varchar(100) latin1_swedish_ci Yes NULL
CreatedByPHPRunner int(11) Yes NULL
What I am trying to accomplish is;
On the edit page I have a dropdown for the "addrecord" field which is using the lookup wizard to display the "edi" data from same _table.
Once an "edi" value is selected in "addrecord" field, on clicking save I want to create a new table in the database with this value if it dose not already exist.
else
update the current record and also add the same record into the new table created with the "edi" value.
Is this possible or am I barking up the wrong tree?
Many thanks in advance.
Nick
