I have three tables in a database. First table has primary key indno(auto increment), second table has indno ad foreign key and sn as a primary key(AI), third table has sn as foreign key and id as primary key(AI).
I made a form in html and and inserted values in that form from user using php,sql. I want to write query to fetch previous result into the form so that the logged in user may change and update the data if he/she whises to.
What I have tried:
There is an error in query.
i used- SELECT * FROM sailform6,sailform7,sailform8 where indno=$indno";
and in the form i used value= ""