Posted by up2trouble on 07/03/07 09:51

I'm trying to link the results to go to a new page for printing. My
code is:

<FIELDSET>
<LEGEND>Older Posts</LEGEND>
<?PHP
$sql3 = "SELECT * FROM $db_table1 WHERE category = 'ideas' ORDER BY
time";
$result3 = mysql_query ($sql3, $connect) or die ('Query failed:
' .mysql_error());

echo "<TABLE CELLSPACING='13' CELLPADDING='2' BORDER='0'
WIDTH='90%'>";
echo "<TR><TD CLASS='title'>Date & Time</TD><TD CLASS='title'>Entry</
TD></TR>";

while ($row3 = mysql_fetch_array($result3))
{
$record1 = $row3["record"];
$time1 = $row3["time"];
$user1 = $row3["user1"];
$entry1 = $row3["entry"];
$part_entry1 = substr("$entry1",0,49);

echo"<TR><TD CLASS='info'>$time1</TD><TD CLASS='info'><A
HREF='printable.php?record=$record1' TARGET='_blank'>$part_entry1</A></
TD>";
}
echo "</TR></TABLE>";
?>
</FIELDSET>

[Back to original message]