how to fetch data from multiple tables MySQL

Question

I am looking some help in php+MySQL+jquery I have 2 tables

table1 table 1 have 4 colume (id, title, desc, thumb_img)

tabel2 table 2 have 3 colume(id, table1id, img)

I just want to compare 2 table with the value of $_get['QS']; and show the records from both (title, desc, img)

Looking forward for the help.:)

This is from the Postgres manual, but it may help you: postgresql.org/docs/current/static/tutorial-join.html — Artefacto
– Artefacto, Commented Jun 10, 2010 at 5:30

Ignacio Vazquez-Abrams · Accepted Answer · 2010-06-10 05:30:42Z

2

SELECT t1.title, t1.desc, t2.img
FROM table1 AS t1
JOIN table2 AS t2
  ON t1.id=t2.table1id
WHERE somefieldyoudidntspecify=:qs

answered Jun 10, 2010 at 5:30

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

2 Comments

faisal Over a year ago

somefieldyoudidntspecify? can u explan this?

Ignacio Vazquez-Abrams Over a year ago

It's whatever you want to compare $_GET['QS'] with.

nathan gonzalez · Accepted Answer · 2010-06-10 05:33:14Z

0

<?php  
   $query="select * from table1 t1 inner join table2 t2 on t2.table1id = t1.id where SomeField = '". mysql_real_escape_string($_get['QS'])."'"
?>

answered Jun 10, 2010 at 5:33

nathan gonzalez

12k4 gold badges43 silver badges57 bronze badges

2 Comments

Arafangion Over a year ago

@faisal: Perhaps only you can answer that. :) You need to specify what you want to compare against $_get['QS']

nathan gonzalez Over a year ago

yeah, just replace somefield with one of your table fields. you just didn't specify which field should be compared against, so i made up a fake one.

Collectives™ on Stack Overflow

how to fetch data from multiple tables MySQL

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related