Ok, I have a ratings section for professors on my site. I first had the original like this
http://www.campus-resource.com/rati.../ucsb/index.php
Ok, go here and notice the advertisements on the right and the menu on the left. Both load off of php functions such as include.
Ok, I have recently started databasing pages due to file number restrictions and have this here
http://www.campus-resource.com/rati...x2.php?userid=3
Ok, i have the php coding copied into the database but it doesn't get processed and is left blank instead. How can I get these processes to continue to function?
Here is how I want my final index.php to look [or whatever works]:
<?php
include '../../../myscon/db.php';
$userid = $_REQUEST['userid'];
$sql = mysql_query("SELECT * FROM dbtester WHERE userid='$userid'");
$row = mysql_fetch_array($sql);
$body = $row['html'];
echo $body;
?>
That's what I have now and this is what I have in the 'html' section of DB:
<html>
<head>
<title>Campus Resource- Class Ratings of UC Santa Barbara</title>
<meta name="keywords" content="teacher, teacher, class number, class name, campus name, class, ratings, rating, evaluation">
<meta name="description" content="Offers ratings on listed teachers and classes at UCSB">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>a:link { color:#20255F; text-decoration:none; }
a:visited { color:#20255F; text-decoration:none; }
a:hover { color:#C9C8CE; text-decoration:none; }
a:active { color:#C9C8CE; text-decoration:none; }</style>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center"><font color="#999999">*Please note that there may
not be a relationship between class and teacher on same row.</font></div></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center"><img src="../../images/campuslogo/ucsb.gif" width="619" height="50"></td>
</tr>
</table>
<table width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="19%" height="594" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr valign="top">
<td width="100%" height="594">
<?php include("http://www.campus-resource.com/ads/leftbar.txt"); ?>
</td>
</tr>
</table></td>
<td width="62%" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2%"></td>
<td width="48%" height="32" background="../../images/bg1.jpg">
<div align="center"><strong><font color="#010A73">Teacher Name</font></strong></div></td>
<td width="2%"></td>
<td width="48%" height="32" background="../../images/bg2.jpg">
<div align="center"><strong><font color="#010A73">Class Name/Number</font></strong></div></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="2%"> </td>
<td width="48%"><a href="dickey.php"><strong>Dickey, T</strong></a>
<br>
<a href="?userid=1"><strong>Harmon, C</strong></a> <br>
<strong><a href="klein.php">Klein, S</a></strong> <br>
<strong><a href="krouse.php">Krouse, C</a></strong><br>
<a href="maass.php"><strong>Maass, L</strong></a>
<br>
<a href="proulx.php"><strong>Proulx, C</strong></a> <br>
<a href="sander.php"><strong>Sander, H</strong></a></td>
<td width="2%"> </td>
<td width="48%"><a href="econ100B.php"><strong>Econ 100B</strong></a><br>
<a href="econ116.php"><strong>Econ 116</strong></a>
<br>
<a href="econ118.php"><strong>Econ 118</strong></a><br>
<a href="econ136A.php"><strong>Econ 136A</strong></a>
<br>
<strong><a href="econ136B.php">Econ 136B</a></strong> <br>
<strong><a href="econ136C.php">Econ 136C</a></strong> <br>
<strong><a href="maass.php#137B">Econ 137B</a></strong> <br>
<strong><a href="econ139.php">Econ 139</a></strong><br>
<strong><a href="geog3A.php">Geog 3A</a></strong><br>
<strong><a href="psy102.php">Psych 102</a></strong></td>
</tr>
</table>
</td>
<td width="19%" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr valign="top">
<td width="145" height="594"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td valign="top">
<?php
$include_file_array[] = "http://www.campus-resource.com/ads/ad1.txt";
$include_file_array[] = "http://www.campus-resource.com/ads/ad2.txt";
$include_file_array[] = "http://www.campus-resource.com/ads/ad3.txt";
$include_file_array[] = "http://www.campus-resource.com/ads/ad4.txt";
$include_file_array[] = "http://www.campus-resource.com/ads/ad5.txt";
$include_file = $include_file_array[ rand( 0, ( sizeof($include_file_array) -1 ) ) ];
include($include_file);
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
This is what loads and it never processes the php variables in 'html'.
Pay no attention to the a href links for they will be changed to database setup later. I need the two processes to load also. But how?
Thanks
Ryan
