[Resolved] echo

ckwall

OK, so here is my file. I am trying to echo a number of fields from one table in the database, but only the timestamp is echoed.

(sample output)
Ticket Number 20030812143041
Priority:
Name:
Department:
Extension:
Email:
Request Summary:
Request Details:
Due By:

<p align="center"><font size="3" face="Arial, Helvetica, sans-serif"><strong>New 
Work Requests</strong></font></p>
<table width="729" border="1" align="center" bgcolor="#FFFFE6">
<tr> 
<td height="22"> <p align="left"> 
<? 
$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; 
} 

?> 

</tr>
</table>

pointsplat

Try this, if the field names are correct in the $query you should be able to paste this directly over the old code and be set!

<p align="center"><font size="3" face="Arial, Helvetica, sans-serif"><strong>New 
Work Requests</strong></font></p> 
<table width="729" border="1" align="center" bgcolor="#FFFFE6"> 
<tr> 
<td height="22"> <p align="left"> 
<?  

$username="root";  

$password="";  

$database="tracker";  

$server="localhost";  

mysql_connect($server,$username,$password);  

@mysql_select_db($database) or die( "Unable to select database");  

$query="SELECT priority,first_name,last_name,department,ext,email,summary,details,day,month,year FROM request where assigned_1 = ''";  

$result=mysql_query($query);   

mysql_close();  

echo "<b><center>New Requests</center></b><br><hr><br>";  

$i=0;  

while ($row=mysql_fetch_row($result)) {  

//Tracker Values 
$priority = $row[0];  

$first_name = $row[1];  

$last_name = $row[2];
$department = $row[3];
$ext = $row[4];
$email = $row[5];
$summary = $row[6];
$details = $row[7];
$day = $row[8];
$month = $row[9];
$year = $row[10]; 

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> 
";  

}  

?>  

</tr> 
</table>

ofSHIZ

Hmm try this.. I don't know if this works.. so.. yeah.

$timestamp = mysql_result($result,$i,"timestamp");

Should be.. 😃

$timestamp = mysql_result($result,$i,"timestamp");
$priority = mysql_result($result,$i,"priority");  

$first_name = mysql_result($result,$i,"first_name"); 
$last_name = mysql_result($result,$i,"last_name"); 
$department = mysql_result($result,$i,"department"); 
$ext = mysql_result($result,$i,"ext"); 
$email = mysql_result($result,$i,"email"); 
$summary = mysql_result($result,$i,"summary"); 
$details = mysql_result($result,$i,"details"); 
$day = mysql_result($result,$i,"day"); 
$month = mysql_result($result,$i,"month"); 
$year = mysql_result($result,$i,"year");

pointsplat

i've never used the mysql_result command before but it seems alot simpler to do the code once and use the while for pulling each row......

Another thing is where did you get the $POST thing from? $POST retrieves values given to the script via a FORM (eg. a contact form or quiz something) it does not have anything to do with a database.

ckwall

ya.... just figured that out before you posted. It was one of those things where you know what to do, but you get confused as to which file you are working on.

A second pair of eyes is always helpful

Thank you.

pointsplat

no problem looking at code for a long time can cause you to miss the simple thing that outsiders like people on this baord can help ya fix in a jiffy, thats why I love it here 🙂

ckwall

thank you for the cheery reply... maybe you can help me with my other new post.