thrope,
I am new to this forum and don't know about view source. Hope you can view the source code.
<code>
<body bgcolor="#CCCCCC" text="#000000">
<p align="center"> </p>
<p align="center"><strong><font size="3" face="Georgia"><em><font size="5">GEORGIA</font></em></strong></p>
<p align="center"><strong><font size="3" face="Georgia"><em><font size="5">UNIFORM TRAFFIC CITATION, SUMMONS AND ACCUSATION</font></em></strong></p>
</body>
<?php
$dbcnx = @mysql_connect("localhost", "tiffanie",
"272420");
if (!$dbcnx) {
echo( "<p>Unable to connect to the " .
"database server at this time.</p>"
);
exit();
}
if (! @mysql_select_db("AMDU") ) {
echo( "<p>Unable to locate " .
"database at this time.</p>" );
exit();
}
echo('<br>');
//Retrieving values for sect3 of ticket
$weather = $_REQUEST['weather'];
$traffic = $_REQUEST['traffic'];
$lighting = $_REQUEST['lighting'];
$road_cond= $_REQUEST['rdcond'];
$road_type = $_REQUEST['rdtype'];
$comvecinfo = $_REQUEST['comvecinfo'];
/*
echo $weather;
echo '<br>';
echo $traffic;
echo '<br>';
echo $lighting;
echo '<br>';
echo $road_cond;
echo '<br>';
echo $road_type;
echo '<br>';
echo $comvecinfo;
echo '<br>';
*/
$sql="SELECT Lic FROM tickets";
$r = mysql_query($sql);
$val = mysql_fetch_assoc($r);
$tempval = $val['Lic'];
//Entering data from sect3 of ticket into database
$result = mysql_query("UPDATE tickets SET weather = '$weather', traffic = '$traffic', lighting = '$lighting', road_cond = '$road_cond', road_type =
'$road_type', comvecinfo = '$comvecinfo' WHERE Lic ='$tempval'");
$sql1="SELECT State FROM tickets";
$test = mysql_query($sql1);
$value = mysql_fetch_assoc($test);
$tempval1 = $value['State'];
$result1 = mysql_query("SELECT Lic,LicClass_Type, Lic_Endorsements, Lic_Expiration,First_Name, Middle_Name,Last_Name FROM $tempval1 WHERE Lic ='$tempval'");
//$val1 = mysql_fetch_assoc($result1);
while ($row = mysql_fetch_array($result1,MYSQL_ASSOC))
{
echo 'Name: ' . $row['First_Name'] ."\t".$row['Middle_Name'] ."\t".$row['Last_Name'] ."\t
\t\t\t\t".'License Class: ' .$row['LicClass_Type']. '<br/>' ;
}//while
?>
</code>
The output is:Name: Tiffanie Nicole Jones License Class: C