I have a script that I think should be working. I would like to have someone esle look at it to see what I am missing:
I am echoing a bunch of values from my data but only the timestamp is printing.
<?
$username="root";
$password="";
$database="tracker";
$server="localhost";
mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM request where assigned_1 = ''";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>New Requests</center></b><br><hr><br>";
$i=0;
while ($i < $num) {
//Tracker Values
$priority = $_POST['priority'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$department = $_POST['department'];
$ext = $_POST['ext'];
$email = $_POST['email'];
$summary = $_POST['summary'];
$details = $_POST['details'];
$day = $_POST['day'];
$month = $_POST['month'];
$year = $_POST['year'];
//timestamp
$timestamp=mysql_result($result,$i,"timestamp");
echo "
<b>Ticket Number $timestamp</b><br>
Priority: $priority <br>
Name: $first_name $last_name <br>
Department: $department <br>
Extension: $ext <br>
Email: $email <br>
Request Summary: $summary <br>
Request Details: $details <br>
Due By: $day $month $year <br>
<hr>
";
++$i;
}
?>
