get from 2 tables which are connected

get from 2 tables which are connected

El Forum
Guest

08-24-2012, 11:44 AM

[eluser]UnknownPlayer[/eluser]
I removed that code, now my code is doing 3 sql queries.
First get article info, then function that get cats for that article and get cat name for each cat, and at end save that object to $data->cats.

Can you give me example for join method, so i can do it on that way ?

Messages In This Thread

get from 2 tables which are connected - by El Forum - 08-24-2012, 10:00 AM

get from 2 tables which are connected - by El Forum - 08-24-2012, 10:16 AM

get from 2 tables which are connected - by El Forum - 08-24-2012, 10:52 AM

get from 2 tables which are connected - by El Forum - 08-24-2012, 10:53 AM

get from 2 tables which are connected - by El Forum - 08-24-2012, 11:44 AM

get from 2 tables which are connected - by El Forum - 08-24-2012, 12:58 PM

get from 2 tables which are connected - by El Forum - 08-24-2012, 02:39 PM

get from 2 tables which are connected - by El Forum - 08-24-2012, 04:26 PM

get from 2 tables which are connected - by El Forum - 08-25-2012, 11:08 AM

get from 2 tables which are connected - by El Forum - 08-25-2012, 02:57 PM

get from 2 tables which are connected - by El Forum - 08-25-2012, 04:25 PM