I would like to generate a ticket number when a form is submitted. I have just been using the timestamp, but have started seeing duplicates.
Also, once the form is submitted, I would like to display the ticket number to the person that has submitted the form.
what would be a good way to create a random ticket number?
Then how would I display that on a confirmation page?
Here is what I have so far (using timestamp)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Information Technologies Work Request</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="work_request" method="post" action="work_request.php">
<table width="56%" height="50%" border="1" align="center" bgcolor="#FFFFE6">
<tr>
<td width="762" height="771" align="left" valign="top">
<table width="97%">
<tr>
<td></td>
</tr>
<tr>
<td><div align="center"><font color="#000000" size="3" face="Arial, Helvetica, sans-serif"><strong>Work
Request for Information Technologies Department</strong></font></div></td>
</tr>
<tr>
<td><div align="center"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">All
Requests for work must be requested using this form. No project
will be completed unless a request has been submitted through
this process.</font></div></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td width="53%"><font color="#000000" size="2" face="Arial, Helvetica, sans-serif">1.
</font><font color="#0000FF" size="3" face="Arial, Helvetica, sans-serif">Priority
of project: (1 most urgent - 5 not urgent)</font></td>
</tr>
<tr>
<td><table width="200">
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<label>
<input type="radio" name="priority" value="1">
<font color="#FF0000">Priority 1</font></label>
</font></td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<label>
<input type="radio" name="priority" value="2">
<font color="#009900">Priority 2</font></label>
</font></td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<label>
<input type="radio" name="priority" value="3">
<font color="#C100C1">Priority 3</font></label>
</font></td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<label>
<input type="radio" name="priority" value="4">
<font color="#0000FF">Priority 5</font></label>
</font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="21"></td>
</tr>
<tr>
<td height="21"><font size="2" face="Arial, Helvetica, sans-serif">2.
<font color="#0000FF" size="3">Name:</font> </font></td>
</tr>
<tr>
<td> <font size="2" face="Arial, Helvetica, sans-serif">First:
<input type="text" name="first_name">
Last:
<input type="text" name="last_name">
</font></td>
</tr>
<tr>
<td height="21"> </td>
</tr>
<tr>
<td height="21"><font size="2" face="Arial, Helvetica, sans-serif">3.
<font color="#0000FF" size="3">Department:</font></font></td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<select name="department">
<option>Client Services</option>
<option>Accounting</option>
<option>Legal</option>
<option>Administration</option>
<option>Data Services</option>
<option>Mail Room</option>
<option>PMG</option>
<option>I. T.</option>
</select>
</font></td>
</tr>
<tr>
<td height="21"> </td>
</tr>
<tr>
<td height="21"><font size="2" face="Arial, Helvetica, sans-serif">4.
<font color="#0000FF" size="3">Extension:</font></font></td>
</tr>
<tr>
<td> <input name="ext" type="text" size="5" maxlength="3"></td>
</tr>
<tr>
<td height="21"> </td>
</tr>
<tr>
<td height="21"><font size="2" face="Arial, Helvetica, sans-serif">5.
<font color="#0000FF" size="3">Email Address:</font></font></td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<input name="email" type="text" size="40" maxlength="50">
</font></td>
</tr>
<tr>
<td height="18"> </td>
</tr>
<tr>
<td height="18"><font size="2" face="Arial, Helvetica, sans-serif">
6. <font color="#0000FF" size="3">Request Summary: (100 Characters)</font></font></td>
</tr>
<tr>
<td height="61"><font size="2" face="Arial, Helvetica, sans-serif">
<textarea name="summary"></textarea>
</font></td>
</tr>
<tr>
<td height="21"> </td>
</tr>
<tr>
<td height="21"><font size="2" face="Arial, Helvetica, sans-serif">7.
<font color="#0000FF" size="3">Request Details: <font size="2" face="Arial, Helvetica, sans-serif">(255
Characters)</font></font></font></td>
</tr>
<tr>
<td height="47"><font color="#0000FF" size="3" face="Arial, Helvetica, sans-serif">
<textarea name="details"></textarea>
</font></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">8. <font color="#0000FF" size="3">Due
Date: </font></font></td>
</tr>
<tr>
<td> <input name="day" type="text" value="DD" size="5" maxlength="2">
<input name="month" type="text" value="MM" size="5" maxlength="2">
<input name="year" type="text" value="YYYY" size="8" maxlength="4"></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">
<input type="submit" value="Submit Work Request" name="Submit Survey Results">
</font></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
then what I was trying to do was display the timestamp on a portion of the page, but I get a resource id #3 instead:
<?
$username="";
$password="";
$database="";
$server="localhost";
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT timestamp FROM request";
$result=mysql_query($query);
mysql_close();
echo "
$result
"
?>
