Query from two table

Topic: Query from two table (Read 1707 times) previous topic - next topic

Query from two table

October 10, 2019, 10:06:39 AM

Hi,

hi have to table

vendors ( id, name, image)
cards ( id, vendor_name, vendor_image, price)

vendor_name ar datasource from table vendors

how to set vendor_ image from table vendors when i add new record?

Re: Query from two table

Reply #1 – October 10, 2019, 10:28:14 AM

you want just display the image? on list view?

Re: Query from two table

Reply #2 – October 10, 2019, 10:32:12 AM

yes

Re: Query from two table

Reply #3 – October 10, 2019, 12:41:36 PM

Select table, join, selectc cards table and vendor_name and name from vendors table

and now you have all the fields on Vendos table..

deselect fields you dont want...

Re: Query from two table

Reply #4 – October 11, 2019, 09:29:22 AM

Good.
I have to make a simple application for giftcard exchange between users, can you help me? obviously I pay you as a freelance.

Re: Query from two table

Reply #5 – October 11, 2019, 10:28:12 AM

Hi,

sorry, i cant help much more than that i dont have much free time, i'm not a programmer and sometimes i take a lot of time to do simple tasks. i can help with my limited knowledge..

I suggest you to see phprad YouTube videos, https://www.youtube.com/channel/UCw5yA932KwBhTIzg-8Alz_w/videos and https://www.youtube.com/channel/UCogX2nzYLJ5OCUmCcWjPTJg/videos

or create a new post for "freelancer wanted" and explain what you want/ need.