Adding Categories....table join?

Adding Categories....table join?

El Forum
Unregistered

02-09-2008, 11:32 PM

[eluser]Armchair Samurai[/eluser]
If you want to display the category of each article as well, just add 'y.name AS category' to your select statement. You'll need to alias it because you have two columns called 'name' (one from articles table and one from the categories).

Messages In This Thread

Adding Categories....table join? - by El Forum - 02-09-2008, 10:06 AM

Adding Categories....table join? - by El Forum - 02-09-2008, 10:28 AM

Adding Categories....table join? - by El Forum - 02-09-2008, 12:08 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 09:58 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 11:04 PM

Adding Categories....table join? - by El Forum - 02-09-2008, 11:32 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 12:31 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 07:17 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:04 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:15 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 08:30 PM

Adding Categories....table join? - by El Forum - 02-10-2008, 09:39 PM