Query 2nd table with value of the 1st

Question

I have 2 tables in my db, departments and company_com. What I am trying to do is, if a posted value in php is run in a query, check the first table for a value and if found, query the second table with that value.

So, for example, posted value = demo, I run select query to store the value in a variable and then use that variable in query on company_com. I know how to query tables but not sure how to store the value in a variable in php. Thanks

BTW I am using MySql and not pdo or mysqli.

sounds like a poor approach, you should use a join and a single query — , Nov 20 '14 at 20:11
http://stackoverflow.com/q/12475850/1450077 You might want to check this out — Fluffeh, Nov 20 '14 at 20:16
Never mind. Decided to go another route. Shall request the question be closed. — user1532468, Nov 20 '14 at 20:19
you can delete your own question. it is a beginner question, that is why people downvoted on it — , Nov 20 '14 at 20:32

score 1 · Accepted Answer · answered Nov 20 '14 at 21:46

$result1 = mysqli_query($conn,"SELECT data1 FROM firsttable");
while($row = mysqli_fetch_array($result1)){
    $result2 = mysqli_query($conn, "SELECT data2 FROM secondtable WHERE data2 = '".$row[0]."'");
    while($row2 = mysqli_fetch_array($result2)){
        echo $row2[0];
    }
}

$result1 is first query.
first while loop goes through first query
$result2 is second query which takes WHERE data from first query's results.
second loop goes through second query and echos data from second query which we compared to data from first query.

Hope that made any sense.

Query 2nd table with value of the 1st

1 Answers1