Hi all,
Forgive me if this is an obvious question, Say I have this page
I want to add div tags around the nav.php, and then also around the table below, but when I do this it makes the display errors, is it not just as simple as addingCode:<?php $cat = $_GET['cat']; /* connect to the mysql database and use a query to get the members info */ include 'library/config.php'; include 'library/opendb.php'; //navigation include("nav.php"); /* set the allowed order by columns */ $default_sort = 'LastName'; $allowed_order = array ('JoinDate', 'FirstName','LastName', 'loginDateTime'); /* if order is not set, or it is not in the allowed * list, then set it to a default value. Otherwise, * set it to what was passed in. */ if (!isset ($_GET['order']) || !in_array ($_GET['order'], $allowed_order)) { $order = $default_sort; } else { $order = $_GET['order']; } /* construct and run our query */ $query = "SELECT * FROM tblmembers WHERE `MemberApproved`='$cat' ORDER BY $order"; $result = mysql_query ($query); /* make sure data was retrieved */ $numrows = mysql_num_rows($result); if ($numrows == 0) { echo "No data to display!"; exit; } /* now grab the first row and start the table */ $row = mysql_fetch_assoc ($result); echo "<TABLE border=1>\n"; echo "<TR>\n"; foreach ($row as $heading=>$column) { /* check if the heading is in our allowed_order * array. If it is, hyperlink it so that we can * order by this column */ echo "<TD><b>"; if (in_array ($heading, $allowed_order)) { echo "<a href=\"{$_SERVER['PHP_SELF']}?order=$heading&cat=$cat\">$heading</a>"; } else { echo $heading; } echo "</b></TD>\n"; } echo "</TR>\n"; /* reset the $result set back to the first row and * display the data */ mysql_data_seek ($result, 0); while ($row = mysql_fetch_assoc ($result)) { echo "<TR>\n"; foreach ($row as $column) { echo "<TD>$column</TD>\n"; } echo "</TR>\n"; } echo "</TABLE>\n"; ?Code:<div ="navigation">//navigation include("nav.php");</div>



Reply With Quote


Bookmarks