[Resolved] Query Arrays - Proper Formatting

[JJ123]

I have some code to print out the results of a DB query. It loops through a for loop to print each value in the array. I need to know if there might be a cleaner way to do this. Here is my code:

$query = "SELECT * FROM tblIssues WHERE (FirstName LIKE '$first' OR LastName LIKE '$last')";
$result = mssql_query( $query ) or die ("Query failed");

print("<TABLE BORDER='3' CELLSPACING='1' CELLPADDING='2'>");
print("<tr><td>Ticket</td><td>First Name</td><td>Last Name</td><td>Phone</td><td>E-mail</td><td>Type</td><td>Subject</td><td>Ticket Details</td><td>Date Submitted</td><td>Assigned To</td></tr>");

for ($i = 0; $i < mssql_num_rows( $result ); ++$i)
	{
	$line = mssql_fetch_row($result);				
	print("<tr>");	
	print( "<td>$line[0] </td>");
	print( "<td>$line[1] </td>");
	print( "<td>$line[2] </td>");
	print( "<td>$line[3] </td>");
	print( "<td>$line[4] </td>");
	print( "<td>$line[5] </td>");
	print( "<td>$line[6] </td>");
	print( "<td>$line[7] </td>");
	print( "<td>$line[10] </td>");
	print( "<td>$line[11] </td>");
	print("</tr>");
}
print("</TABLE>");

I am wondering how (if it is even possible) to use words instead of [0] to [11] in the $line[] variable. So for example $line[ticket] or $line[firstname].

[Xoid]

it's entirely possible, if you use a command such as;

mssql_fetch_array which puts the data into an associative array so you can call an individual element by it's name according to the database.

e.g.

$line = mssql_fetch_array($result);

print $line['name_of_field'];

also, instead use foreach which makes it alot easier looping through arrays, alot cleaner also!

e.g.
$line = mssql_fetch_array($result);

foreach($line as $entry)
{
print "$entry";
}

which makes things alot easier to read and a hell of alot cleaner when reading.

Hope this helps!

[kevinsequeira]

 while($line = mssql_fetch_row($result)){
  print("<tr>");
  print("<td>$line['ticket']</td>");
  print("<td>$line['firstname'] </td>");
  print("<td>$line['lastname'] </td>");
  print("<td>$line['email'] </td>");//and so on for the rest of the array
  print("<td>$line[4] </td>");
  print("<td>$line[5] </td>");
  print("<td>$line[6] </td>");
  print("<td>$line[7] </td>");
  print("<td>$line[10] </td>");
  print("<td>$line[11] </td>");
  print("</tr>");
} 

reg
kevin

[JJ123]

Great - thank you!