Use two tables in one php page (mysql)

Question

Trying to retrieve all the data onto one page... I've got this working fine when it's retrieving from one table like so:

$data = mysql_query("SELECT * FROM moduleDetails")

I've tried doing

("SELECT * FROM moduleDetails, qResponses")

but that doesn't work and is the only thing I can see working.

I've heard about using identifiers? But I'm not quite sure how to use those...

I am new to PHP, any tips/examples would be great.

You need to specify how to join those two tables. What column links them together? — Jessica
– Jessica, Commented Jan 10, 2014 at 18:22
I've got a userno, like a unique number for each participant of the questionniare - how would i use that? — box
– box, Commented Jan 10, 2014 at 18:22

Jessica · Accepted Answer · 2014-01-10 18:24:16Z

2

SELECT md.*, qr.*
FROM moduleDetails md
LEFT JOIN qResponses qr
ON qr.joinColumn = md.joinColumn

Whatever column you used to link them together, use as the joinColumn.

answered Jan 10, 2014 at 18:24

Jessica

6,99630 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

SaggingRufus Over a year ago

YES you can't just select all from 2 tables without joining them.

box Over a year ago

so like this? $data = mysql_query( SELECT md.*, qr.* FROM moduleDetails md LEFT JOIN qResponses qr ON qr.userno = md.userno)

jgabriel Over a year ago

PHP interpret everything that is not in quotes as being constants or functions. The query should be set as a variable. To do so, you should contain it inside quotes

jgabriel Over a year ago

$data = mysql_query('SELECT md.*, qr.* FROM moduleDetails md LEFT JOIN qResponses qr ON qr.userno = md.userno'); DON'T EVER FORGET THE SEMICOLON WHEN YOU END A LINE

Andrew Brown Over a year ago

IFF the tables are not actually linked in any way, you could use a UNION statement, which simply selects rows from first table, and then the next. w3schools.com/sql/sql_union.asp

Collectives™ on Stack Overflow

Use two tables in one php page (mysql)

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related