mysqli php condition if statement

Question

Will try to explain as best i can :)

I have 2 tables

Cloths tables (many) to Question Tables (one)

I want to show questions to a cloth item. Which works fine

What i am trying to understand, is that if a cloth item is removed from the database, the question will not sure up

as i have this as my sql command

"SELECT contact.id, contact.name, contact.email, contact.comments,contact.type, contact.stockid, contact.date ,
                      stock.stockid, stock.name ,stock.mainimage,  stock.price FROM contact,stock
                      where contact.stockid = stock.stockid
                      and contact.type ='ques'"

This will display the question related to stock item, what i am trying to get my brain around, how would i do it for example

If no stock.stock id, display question, but with a header, "this question is for a stock item that has been removed.

Any guidance would be great.

Many thanks

see stackoverflow.com/questions/38549/…

VolkerK
– VolkerK

2014-03-28 11:54:12 +00:00
Commented Mar 28, 2014 at 11:54 — VolkerK
– VolkerK, Commented Mar 28, 2014 at 11:54

mesutozer · Accepted Answer · 2014-03-28 11:54:02Z

1

You need a LEFT JOIN for this. Try the following query:

"SELECT contact.id, contact.name, contact.email, contact.comments,
    contact.type, contact.stockid, contact.date
    stock.name, stock.mainimage,  stock.price
FROM contact
LEFT JOIN stock ON (stock.stockid = contact.stockid)
WHERE contact.type ='ques'"

When you are fetching the rows, if name, mainimage or price fields are NULL, that means there are no stocks for that contact.

answered Mar 28, 2014 at 11:54

mesutozer

2,8591 gold badge15 silver badges13 bronze badges

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

Comments

laalto · Accepted Answer · 2014-04-01 07:43:07Z

0

FROM `contact`

LEFT JOIN `stock` ON `stock`.`id` = `contact`.`stockid`

edited Apr 1, 2014 at 7:43

laalto

153k68 gold badges293 silver badges306 bronze badges

answered Mar 28, 2014 at 12:22

rumaviio

11 bronze badge

Collectives™ on Stack Overflow

mysqli php condition if statement

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related