php return 1 data set from 2 mysql queries

Question

Currently I'm getting a single row from a single table and returning that to be processed by JS:

$sql = "SELECT * FROM labs WHERE lab_id = $lab_id";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
// send the data encoded as JSON
echo json_encode($row);

But now I need to add some data from another table. The "labs" table has a "lab_model_id" column which is an int. I need to use that "lab_model_id" to get "lab_model_name" from "lab_models".

1) How do I pull out the "lab_model_id" in my php to perform the second query?

2) Can I add the second result to the first before returning?

Possible duplicate of [How to join two tables mysql?](http://stackoverflow.com/questions/3536283/how-to-join-two-tables-mysql) — chris85, May 09 '17 at 12:40

score 0 · Accepted Answer · edited May 09 '17 at 12:49

0

Try using JOIN..

$sql = "SELECT labs.*,`lab_models`.`lab_model_name`
        FROM labs
        LEFT JOIN lab_models
        ON lab_models.lab_model_id = labs.lab_model_id
        WHERE lab_id = $lab_id";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
// send the data encoded as JSON
echo json_encode($row);

edited May 09 '17 at 12:49

chris85

23,846
7
34
51

answered May 09 '17 at 12:43

Sizzling Code

5,932
18
81
138

Might want to add the table name to the `where` to avoid possible ambiguous column name. – chris85 May 09 '17 at 12:50

php return 1 data set from 2 mysql queries

1 Answers1