How does one refrain from laughing when reading this thread? :D
jail.php
<?php
@mysql_connect("localhost",$user,$pass);
@mysql_select_db($db);
$criminal = $_COOKIE[criminal];
$sheriff = $_COOKIE[sheriff];
$day = date("m/d/Y");
if(isset($sheriff)) {
} else {
?>
Wah howdy, partner!<br>
These folks been doin' crimes round these parts.
<table align="center" border="1">
<tr>
<th>Criminal</th>
<th>Day Released</th>
<th>Crime</th>
</tr>
<?php
$criminals = mysql_query("SELECT * FROM jail") or die(mysql_error());
while($c = mysql_fetch_array( $criminals )) {
?>
<tr>
<td><?php echo $c[criminal]; ?></td>
<td><?php echo $c[releaseDay]; ?></td>
<td><?php echo $c[crime]; ?></td>
</tr>
<?php
$crime = mysql_query("SELECT * FROM jail WHERE criminal='$criminal'") or die(mysql_error());
while($c = mysql_fetch_array( $crime )) {
if($c[releaseDay] > $date) {
echo '<h1>You\'re released from jail!</h1>';
} else {
?>
<p align="center">
You've been arrested for <b><?php echo $c[crime]; ?></b><br>
You're released on <b><?php echo $c[releaseDay]; ?></b><br>
</p>
<?php
}
}
}
?>
mysql_dumb.sql
CREATE TABLE `test`.`jail` (
`id` INT NOT NULL AUTO_INCREMENT ,
`criminal` VARCHAR( 255 ) NOT NULL ,
`crime` VARCHAR( 255 ) NOT NULL ,
`releaseDay` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB