Displaying Results From Several Tables

bunker

Hi,

If I do a query selecting several fields from several tables for example:

$sql = mysql_query("SELECT content.* , article.title FROM content article")

How would I display the value of the field title from the table article?

Thx!

_RL_Ian

<?php
$sql = "SELECT c.*, a.title FROM `content` c, `aritcle` a WHERE c.article_id = a.article_id";
?>

bunker

dont get it... or I didnt explain right....

Could you please explain a bit the code... Ive tried to adapt it to my site and It finaly looks like this...

$sql = mysql_query("SELECT c.*, a.cat FROM content c, article a WHERE a.article_cat = $cat");

but I get an error....

dont understant the bit after WHERE...

Also.. how would I display the result?? print $row[??????];

Thx again!

_RL_Ian

When you call from more than one table, you have to LINK those tables together. So, what you're doing after the "where", is telling MySQL that c.article_cat should be equal to a.article_cat (c and a are just shortcuts that we created in the SELECT portion of the statement) in order to be a valid result. If you don't do that, you will retreive every category for every article.

Give this a shot:

<?php
$sql = "SELECT c.*, a.cat FROM `content` c, `aritcle` a WHERE c.article_cat = a.cat AND c.article_cat = '" . $cat . "'";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query))
{
	echo($row['cat'] . "<br />");
}
?>

bunker

ok...

so far so good.... But... what if there is also a field on the content table called "cat" and I want to display that value? ( which is my actual problem ).

Ive changed the query a bit, instead of c.* Ive put c.cat and also please explain why You do: c.article_cat instead of a.article_cat, like Ive done below!!

<?php
$sql = "SELECT c.cat, a.cat FROM content c, article a WHERE a.article_cat = '" . $cat . " AND c.content_cat = '" . $cat . "''";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query))
{
echo($row[??????] . "<br />");
}
?>

Once again... THX!!