How to select foreign key
#1

Hi guys

I have two tables
1) inventory ( `ID` `userid` , `inv_item`(a item_name ID foreign key) , `inv_amount` )
2) item_name ( `ID` , `name` `weight` )

I have this query for example:
Код:
SELECT * FROM `inventory` WHERE `userid` = '2'
Result: http://prntscr.com/kgp3tz

My question is: How to get item_name from this query(like in picture,how I can use it name in my script?)
Reply


Messages In This Thread
[SOLVED] How to select foreign key - by GospodinX - 09.08.2018, 16:03
Re: How to select foreign key - by Kraeror - 09.08.2018, 16:31
Re: How to select foreign key - by GospodinX - 09.08.2018, 17:16
Re: How to select foreign key - by Kraeror - 09.08.2018, 19:24
Re: How to select foreign key - by Banditul18 - 09.08.2018, 19:42
Re: How to select foreign key - by GospodinX - 09.08.2018, 22:59

Forum Jump:


Users browsing this thread: 1 Guest(s)