Name |
State |
Category |
Full Story? |
/* include configuration file */
include("config.php3");
/* make connection to database */
MYSQL_CONNECT($hostname, $username_rw, $password_rw) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
/* select stories */
$query1 = "SELECT * FROM theedge";
$result1 = MYSQL_QUERY($query1);
$number1 = MYSQL_NUMROWS($result1);
/* print story previews */
$i = 0;
if ($number1 == 0) {
PRINT"There are no stories in the database.";
}
else {
while ($i < $number1) {
$id = mysql_result($result1,$i,"id");
$first_name = mysql_result($result1,$i,"first_name");
$last_name = mysql_result($result1,$i,"last_name");
$city = mysql_result($result1,$i,"city");
$state = mysql_result($result1,$i,"state");
$category = mysql_result($result1,$i,"category");
$full_story = mysql_result($result1,$i,"full_story");
$started_mo = mysql_result($result1,$i,"started_mo");
$started_yr = mysql_result($result1,$i,"started_yr");
PRINT "";
PRINT "$first_name | ";
PRINT "$state | ";
PRINT "$category | ";
if ($full_story == "") { PRINT " | "; }
else { PRINT "Yes | "; }
#PRINT "$started_mo $started_yr | ";
$i++;
}
}
?>