SELECT * FROM with two different tables [duplicate]

Question

I've been fiddling with this for bit and tried a couple different ways to combine both SELECT FROM statements, but I can't get it to work where I can call on fields from two tables within the same database. It works find if I remove either one. I tried to combine them using UNION (not sure if that's the correct thing), but couldn't get it to work.

Here's what I got so far with them separated:

$id = $_POST['id'];

$edit = $db->prepare("SELECT * FROM contacts WHERE id = (?)");
$edit->bind_param('s', $id);
$edit->execute();
$edit->bind_result($id, $firstName, $lastName, $email, $phone, $category);

$categories = $db->prepare("SELECT * FROM category");
$categories->execute();
$categories->bind_result($cateid, $setcategory);

echo $firstName;

while ($categories->fetch()) {
    echo $setcategory;
}

I'm new to all of this. I'd be grateful if someone could point me in the right direction. Thanks!

I do not see anything, that might be link this two tables together. Is there anything? Could you please describe structure of those tables? — BlitZ
– BlitZ, Commented Jul 30, 2013 at 5:00
How does the 2 tables relate? Does a contact have a category_id specified? Is there a joining table? Is the relationship 1<->1, 1-> many, many<->many? — Adriaan Stander
– Adriaan Stander, Commented Jul 30, 2013 at 5:01
Ultimately, I'm trying to pull and assign fields to variables, then write it so that I can add category values to the category row inside the contacts table. Maybe, I'm going about it the wrong way? — omyzach
– omyzach, Commented Jul 30, 2013 at 5:03

Jacob · Accepted Answer · 2013-07-30 05:16:16Z

4

if the two tables have a common field then you can do something like

"SELECT A.*, B.*
 FROM contacts AS A
 JOIN category AS B
 ON A.primary = B.foreign
 WHERE A.id = (?)"

edited Jul 30, 2013 at 5:16

answered Jul 30, 2013 at 5:08

Jacob

9206 silver badges19 bronze badges

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

1 Comment

JDGuide Over a year ago

Put comma in between A data and B data.This will return Cartesian result.

maXfenda · Accepted Answer · 2013-07-30 05:31:14Z

2

if your two tables have a comman attribute you can use inner join to do this

select * from tableA inner join tableB 
on tableA.commanKey =tableB.commanKey on tableA.id=?

hope this will help you.

answered Jul 30, 2013 at 5:31

maXfenda

2143 silver badges10 bronze badges

Collectives™ on Stack Overflow

SELECT * FROM with two different tables [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related