Is there any way I can get PHP to work with HTML in the manner I'm trying below? It's not working and I don't know if it just can't be done or if I'm missing something:
++++++++++++
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
<?php
$dbh = mysql_connect("localhost", "user", "password") or die("Failure to communicate with database");
mysql_select_db("test_db") or die(mysql_error());
$rs = mysql_query('SELECT * FROM test_table') or die(mysql_error());
$row = mysql_fetch_array($rs);
$header = $row['header'];
$rooms = $row['rooms'];
$sqft = $row['sqft'];
$price = $row['price'];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>test past</title>
</head>
<body>
<?php while (mysql_fetch_row($rs)): ?>
<table width="600" border="1" cellspacing="2" cellpadding="2">
<tr>
<td colspan="3"><?php $_GET[$header]; ?></td>
</tr>
<tr>
<td><?php $_GET[$rooms]; ?></td>
<td><?php $_GET[$sqft]; ?></td>
<td><?php $_GET[$price]; ?></td>
</tr>
</table>
<?php endwhile; ?>
</body>
</html>
++++++++++++
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
<?php
$dbh = mysql_connect("localhost", "user", "password") or die("Failure to communicate with database");
mysql_select_db("test_db") or die(mysql_error());
$rs = mysql_query('SELECT * FROM test_table') or die(mysql_error());
$row = mysql_fetch_array($rs);
$header = $row['header'];
$rooms = $row['rooms'];
$sqft = $row['sqft'];
$price = $row['price'];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>test past</title>
</head>
<body>
<?php while (mysql_fetch_row($rs)): ?>
<table width="600" border="1" cellspacing="2" cellpadding="2">
<tr>
<td colspan="3"><?php $_GET[$header]; ?></td>
</tr>
<tr>
<td><?php $_GET[$rooms]; ?></td>
<td><?php $_GET[$sqft]; ?></td>
<td><?php $_GET[$price]; ?></td>
</tr>
</table>
<?php endwhile; ?>
</body>
</html>