Dear coders,
I have the following scenario : (webdev - php - mysql )
1. I have one table called "TblUsers" which I create from analysis and data type is MySQL, The "Tblusers" table contains two columns "LogonName", "LogonPass" , When I run the Webdev PHP project "index.php" , dynamically it will create a tables to MYSQL server. (I put a code Hcreationifnotfound("*")) on the Global Initialization of the project.
2. When I add another column through analysis and I add a column "LogonFullName", then I again run the Webdev PHP project. the table "TblUsers" on my MYSQL server will does'nt update , it is still having two columns .
How to update the Table column dynamically ? If I want to add new tables on my analysis and to add a new column to any tables, I want also that it should update the tables on MYSQL SERVER.
Advise please.
Thanks