Master/Detail pages

fireman_sam

Help please
I've got a mySQL database which has a brief details field and a full details field (among others). The web page shows a subset of the records with a hyperlink that takes you to a page which shows the full details field of that particualr record. My problem is that the full details field does not always contain any information. I only want the link to be 'active' if there is any info in the full details field, but I haven't clue how to do it. I'm using Dreamweaver MX.
www.essex-fire.org/press is the current site written in Frontpage(sorry, we all start somewhere). This doesn't have the functionality either but it might give an idea of what I'm after. Help please

snoopy13

you first read out the data in the database for the row, where you want the details link to be - than make an if statement (if there is a value in there, make the link)

eg.
you have two tables x (with little info) and y (with everything else) and you have a key to connect the two tables in the database - lets say subject_ID

so you make a query
$query=mysql_query ("select * from y WHERE subject_ID = '$subject_ID'");
$count=mysql_num_rows($query);
if ($count>0) {
?>
<a href=.....</a>
<?php
}
?>

Frederick

do a check to see if the full details field is empty or not

$sql = mysql_query("SELECT * FROM tablename WHERE id=$id")
or die(mysql_error());
$row = mysql_fetch_array($sql);

$str = $row["shortDescription"];
echo nl2br($str);

echo "<br>";

if (!empty($row["fullDetails"]) {
    echo "<a href=\"........\">View Full details</a>";
}