How do I solve this using PHP, mysql.

Question

1.00/5 (1 vote)

See more:

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= ""

Posted 2-Jun-16 0:00am

PHP_OMG

Updated 2-Jun-16 5:42am

Add a Solution

Comments

Prava-MFS 2-Jun-16 6:42am

Provide the code what you tried and the exact error you are getting.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2016-06-02T04:11:00

Solution 1

You need to use JOINS.

SELECT *
FROM sailform6 s6
LEFT JOIN sailform7 s7 ON s6.indno = s7.indno
LEFT JOIN sailform8 s8 ON s6.indno = s8.sn

Posted 2-Jun-16 4:11am

ZurdoDev

Comments

PHP_OMG 2-Jun-16 11:39am

Thank you so much for answering.
Do i have to make any change in my html form??
I am getting a blank screen.

ZurdoDev 2-Jun-16 11:53am

No idea. I can't see anything that you have. I suggest opening a new question, tagging it as php and show the php code that you have.

Peter Leow · Accepted Answer · 2016-06-02T05:42:00

Solution 2

First, learn about Visual Representation of SQL Joins[^]
followed by How Multiple Joins Work[^]

Posted 2-Jun-16 5:42am

Peter Leow