<%
##########
# fkselector_top.htm - displays the fk
# top frame for fk selection
# TJM 05/19/01
# $Id$
# params
# $table, $fields,$whereclause, $orderby
##########
require "prepend.php3";
if (!$table) {
echo "table not set";
return;
}
if (!$fields) {
echo "fields not set";
return;
}
%>
Viewing Table <% echo $table %>
<%
$q = "SELECT $fields FROM $table";
if (strlen($whereclause)) {
$q.= " WHERE ".urldecode(stripslashes($whereclause));
}
$q.= " ORDER BY '$orderby'";
#echo $q;
$r = DoQuery($q);
echo "\n";
if (mysql_num_rows($r)>0) {
while ($row = mysql_fetch_array($r)) {
echo "";
echo "| $row[0] | ";
echo "".$row[1]." | ";
echo "
";
}
}
else {
echo "| No Records Found. |
";
}
%>