Sorry to bother i am asking how can i use 2 tables in select like this $query = mysqli_query($con," select from user where

Question

Sorry to bother i am asking how can i use 2 tables in select like this

$query = mysqli_query($con,"
select from user where password $password then select from shoplistmember where email $ email and select from tomorrow as tmrrw

Any help

Answer 1

Мг. Кнап🌠
At the moment we don't even know the OP's table structure, we need to be sure that the tables involved have same number of columns before we can use UNION IIRC.

Answer 2

Ipang oh yes, i didn't thought about it.. ;)

Answer 3

Hoo Lee Sheet as Ipang mentioned you need to be more precise about your table structure

Answer 4

Ok check the DM

Answer 5

Ok

Answer 6

ARE YOU KIDDING?
if you can read users pwd directly from dB I don't want to be a user.
Sth from your dB is out of control.

Answer 7

Oma Falk actually, I looked into his problem, it was totally different issue, he wanted to create multilevel marketting sort of registeration and login, where user puts some reference code from parent user, and joins under it's node

Answer 8

"SELECT *
FROM user
WHERE password = $password
UNION
SELECT *
FROM shoplistmember
WHERE email = $email
UNION
SELECT *
FROM tomorrow"

Answer 9

I tried union didnt work

Answer 10

$query = mysqli_query($con,"select * from user where email='$email' and password='$password' UNION select * from pin_list where pin='$pin'");

Answer 11

what is the relation between "tomorrow" and other tables?

Answer 12

This is the correct table

Answer 13

Email email password password pin amd pin

Answer 14

I wanna combine them all when user login he has t put password email and a pin

Answer 15

so you want to take email, password and a pin all within the same form, and when you submit the form the email and password is checked with users table, and the email is checked with shoplistmember table, and the pin with tomorrow table??

Answer 16

Yes bro put the pin will be in pin_list and shopmember and tomorrow is not needed then

Answer 17

Like

Answer 18

From user table Email =email table and password =password then in pin from pin_list where pin=pin then i dont need tomorrow and shopmember s