Code:
<html><style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<table width="100%" background="images/stars.jpg">
<td><img src="images/movright.jpg" align="right">
</td>
</table>
<title>Welcome to Sim and Sim.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {color: #ECE9D8}
-->
</style><body bgcolor="#000000"></body>
<span class="style1"></span>
<?php
include("menu.php");
echo "<table width='80%' align='center' height='100%' border='1' cellpadding='0' cellspacing='0'>";
echo " <tr>
<td width='30' valign='top' bgcolor='#000000'><table bgcolor='#999999' border='1'><td>
<FONT color='white' face='Verdana, Arial, Helvetica, sans-serif' size='2'><u>Are you a member?</u></font>
<p>
<!-- form for customer login -->
<form action='index.php?do=login' method='POST'>
<table border='0'>";
#25
if (isset($message))
{
echo "<tr><td colspan='2'>$message </td></tr>";
}
echo " <tr><td align=right><FONT color='white' face='Verdana, Arial, Helvetica, sans-serif' size='2'>Username</font></td>
<td><input type='text' name='fusername'
size='20' maxsize='30'>
</td></tr>
<tr><td align='right'><FONT color='white' face='Verdana, Arial, Helvetica, sans-serif' size='2'>Password</font>
</td>
<td><input type='password' name='fpassword'
size='20' maxsize='30'></td></tr>
<tr><td align='center' colspan='2'>
<input type='submit' name='log'
value='Enter'></td></table></td>
</tr>
</table>
</form>";
echo "<table width='100%' bgcolor='gray'><td><font color='white' face='Verdana, Arial, Helvetica, sans-serif' size='4'><b><center><u>News</u></center></b><td></table>";
$connection = mysql_connect($host,$user,$password) #13
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection) #15
or die ("Couldn't select database");
$query = "SELECT * FROM news ORDER BY id DESC LIMIT 5"; #19
$result = mysql_query($query)
or die ("Couldn't execute query.");
while ($row = mysql_fetch_array($result)) #37
{
extract($row); #39
echo "<font color='white' face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>$title</b><br>"; echo substr ($post, 0, 115); echo ".....<br><font align='right'><a href='news.php?news=$id'><font color='#CCCCCC'>Full Story</font></a></font><br><br>
</font>";
}
echo "</td>";
?>
<td valign="top"><table bgcolor="#999999" width='100%' border="1"><td>
<font color='white' face='Verdana, Arial, Helvetica, sans-serif'>
<center><b><h1>Simulacra and Simulation Media</h1></b></center>
</font>
</td>
</table>
<font color='white' face='Verdana, Arial, Helvetica, sans-serif' size="2">
<br>
Welcome to Sim and Sim.com?s Media Section, here amongst other things are;<br>
Trailers made by Fans of Movies and Games<br>
Fan based movies<br>
Movie Reviews made by fans<br>
Trailers for Movies and Games that are about to be released<br>
DVDs news posted by members of this site<br>
Pictures made by members of this site
<br><br><br><br>
[b]<?php
$connection = mysql_connect($host,$user,$password) #13
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection) #15
or die ("Couldn't select database");
/* Select all categories from GameType table */
$query = "SELECT * FROM people"; #19
$result = mysql_query($query)
or die ("Couldn't execute query."); #21
/* Create form containing selection list */
echo "<center><table cellpadding='5' border='1'>";
echo "<tr>";
$row = mysql_fetch_array($result);
extract($row);
if ($_GET["find"] == $person )
{
$per_row = 4;
echo "$person";
$result2 = mysql_query("SELECT pic FROM pics");
for ($i=0; $i<mysql_num_rows($result2); $i++)
{
$pic2 = mysql_result($result2,($i));
echo "<td align='center'><img src='$pic2'></td>";
if ($i%$per_row == 0)
{
echo "</tr><tr>";
}
}
}
else {
echo "<font face='Verdana, Arial, Helvetica, sans-serif' size='2'>Sorry no pics found</font>";
}
echo "</tr><center></table>"; #55
echo "<div align='center'>
<table border='1' bgcolor='#999999'><td><a href='media.php'>
<font color='white' face='Verdana, Arial, Helvetica, sans-serif' size='2'>Back to the Start</font></a></td></table></div>";
?>[/b]
</td>
</table>
</body>
</html>
For each pic the user has there is a new row for it, so the person who is on the site can have as many lines as s\he likes
I know its long but..... it needs to be like that
