Get data from 2 tables?

[Lilian]

Hey,

I am getting a bit lost on how to get information from two different tables.

I have got:


<?
ob_start();
include("config.php");

$a= mysql_query("SELECT * FROM `swnews` ORDER BY `newsid` DESC LIMIT 5") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
echo "<br />";
echo $b['subject'] . '</a></b><br /><i>';
echo $b['description'] . '</b></i><br />';
echo $b['contents'] . '</b></i><br />';
}

?>

However, I need "contents" to come from the table "swarticles" and not "swnews" when the ID = the subject ID (if you understand that).

[Dentafrice,]

<?
ob_start();
include("config.php");

$a= mysql_query("SELECT * FROM `swnews` ORDER BY `newsid` DESC LIMIT 5") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
$c = mysql_query("SELECT * FROM `swarticles` WHERE id='$b[subject]' LIMIT 0,1");
$d = mysql_fetch_array($d);
echo "<br />";
echo $b['subject'] . '</a></b><br /><i>';
echo $b['description'] . '</b></i><br />';
echo $d['contents'] . '</b></i><br />';
}

?>

[Lilian]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in news.php on line 8


<?
ob_start();
include("config.php");

$a= mysql_query("SELECT * FROM `swnews` ORDER BY `newsid` DESC LIMIT 5") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
$c = mysql_query("SELECT * FROM `swnewsdata` WHERE id='$b[subject]' LIMIT 0,1");
$d = mysql_fetch_array($d);
echo "<br />";
echo $b['subject'] . '</a></b><br /><i>';
echo $b['description'] . '</b></i><br />';
echo $d['contents'] . '</b></i><br />';
}

?>

Can't seem to find the problem. All the databases are there :S

[Dentafrice,]

oops



<?
ob_start();
include("config.php");

$a= mysql_query("SELECT * FROM `swnews` ORDER BY `newsid` DESC LIMIT 5") or die(mysql_error());
while ($b = mysql_fetch_array($a)) {
$c = mysql_query("SELECT * FROM `swnewsdata` WHERE id='$b[subject]' LIMIT 0,1");
$d = mysql_fetch_array($c);
echo "<br />";
echo $b['subject'] . '</a></b><br /><i>';
echo $b['description'] . '</b></i><br />';
echo $d['contents'] . '</b></i><br />';
}

?>

[Lilian]

Nope =[

Edit:// Got it :) Needed to change id to $b[subject] to $b[newsid].

Would Rep you Denta but need to spread :(

[Dentafrice,]

ahh in your post I thought you said subject was the id :P