get from 2 tables which are connected

get from 2 tables which are connected

El Forum
Guest

08-24-2012, 10:16 AM

[eluser]CroNiX[/eluser]
Look into JOINs using mysql to get related data from other tables and you can use GROUP_CONCAT() to grab all of the categories for each article.

Once you figure out the regular SQL to do the query you can convert it to active record.

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