Code: Select all
$sql = "SELECT name, description, url, subject FROM tblname INNER JOIN tbllink ON tblname.nmid = tbllink.nmid INNER JOIN tblsubject ON tbllink.sbid = tblsubject.sbid WHERE tblsubject.sbid = $id ORDER BY name";
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
echo mysql_result($result,$i,'subject');
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "<dt><a href={$row['url']} target='_new'>{$row['name']}</a></dt>" .
"<dd>{$row['description']}</dd>";
}Why is this happening?
Thanks for any help or suggestions.
Bill