index page...
<?php
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
include("config.php");
$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $connect);
echo "<form method=\"post\" action=\"results3.php\">
<center>
<table>
<tr>
<td>Category 1:</td>
<td><select name=category size=1>
<option></option>
<option value=nature>Nature</option>
<option value=minnesota>Minnesota</option>
<option value=flowers>Flowers</option>
<option value=BBQ>BBQ Festival</option>
<option value=friends>Friends</option>
<option value=Family>Family</option>
<option value=animals>Animals</option>
<option value=moose>Moose</option>
<option value=eagle>Bald Eage</option>
<option value=Loon>Loon</option>
<option value=chipmunk>Chipmunk</option>
<option value=birds>Birds</option>
<option value=landscape>Landscape</option>
<option value=campsite>Campsite</option>
<option value=cedar>Cedar Bluff</option>
<option value=weather>Weather</option>
<option value=sunset>Sunset</option>
<option value=fog>Fog</option>
<option value=astronomy>Astronomy</option>
</select></td>
</tr>
<tr>
<td>Optional<br>Category 2:</td>
<td><select name=tcategory size=1>
<option></option>
<option value=nature>Nature</option>
<option value=minnesota>Minnesota</option>
<option value=flowers>Flowers</option>
<option value=BBQ>BBQ Festival</option>
<option value=friends>Friends</option>
<option value=Family>Family</option>
<option value=animals>Animals</option>
<option value=moose>Moose</option>
<option value=eagle>Bald Eage</option>
<option value=Loon>Loon</option>
<option value=chipmunk>Chipmunk</option>
<option value=birds>Birds</option>
<option value=landscape>Landscape</option>
<option value=campsite>Campsite</option>
<option value=cedar>Cedar Bluff</option>
<option value=weather>Weather</option>
<option value=sunset>Sunset</option>
<option value=fog>Fog</option>
<option value=astronomy>Astronomy</option>
</select></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</table>
<p><input type=submit value=renew name=submit></p>
</center>
</form>";
//mysql_close($connect);
php ?>
The result page..... results3.php without the javascript
<?php
include("config.php");
$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $connect);
$sql = "SELECT *
FROM photographs p, largepics l, resolution r
WHERE p.largeid=l.largeid
AND p.resolutionid=r.resolutionid
AND category LIKE '%$category%'
AND category LIKE '%$tcategory%'
ORDER BY id";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$num=mysql_numrows($result);
$l=0;
echo "<div align=center>";
echo "<table>";
$i=0;
$r=0;
while ($r<$num)
{
echo "<tr>";
while ($i < 5) {
if ($r==$num)
{
++$r;
exit;}
echo "<td align=center>";
$fname=mysql_result($result,$r,"filename");
$wdth=mysql_result($result,$r,"width");
$hght=mysql_result($result,$r,"height");
$dte=mysql_result($result,$r,"date");
$ttle=mysql_result($result,$r,"title");
$size=mysql_result($result,$r,"size");
$worig=mysql_result($result,$r,"worig");
$horig=mysql_result($result,$r,"horig");
echo "<a href=\"JAVASCRIPT:openPopImg('photographs/large/$fname', 'Photo $fname', $wdth,$hght)\"><img src='photographs/thumbnails/$fname' alt='Click to Enlarge' border='0'></a>";
echo "<br><a href=\"JAVASCRIPT:openPopImg('photographs/large/$fname', 'Photo $fname', $wdth,$hght)\">Click for Bigger Image</a>";
echo "<br><b>$ttle</b>";
echo "<br>$dte<br>";
echo "<a href=\"photographs/originals/$fname\" target=\"_blank\">Original</a><br>";
echo "Size = $size<br>";
echo "Resolution:<br>$worig x $horig</td>";
++$r;
++$i;
echo "</td>";
}
$i=0;
echo "</tr>";
}
mysql_free_result($result);
mysql_close($connect);
php?>
