Printing from an array

[jlong32]

I am getting information from a database (non-local) and bringing it into a string.  I now want to print the entire string in column form.  I keep receiving the error message

Parse error: parse error, unexpected T_STRING in /home/httpd/vhosts/khsaa.org/subdomains/admin/httpdocs/jerrod/index.php on line 12

this is the code I am using: 

$coaches=mysql_fetch_array(mysql_query("SELECT KHSAA_Schools.* FROM KHSAA_Schools where member=\"T\""));
  $coachlist=mysql_query("SELECT bacoach FROM KHSAA_Schools WHERE member=\"T\" and ba=\"T\");
(line 12 of my code) -> while($coaches=mysql_fetch_array($coachlist));
      echo vprintf("Coach: %s",($coaches[bacoach]));
  print mysql_error();

[wildteen88]

You have a missing quote in this code, highlighted in red:
mysql_query("SELECT bacoach FROM KHSAA_Schools WHERE member=\"T\" and ba=\"T\"[color=red][b]"[/b][/color]);

Also remove the semi-colon on this line:
while($coaches=mysql_fetch_array($coachlist))[color=red][b];[/b][/color]

Your new code:
[code=php:0]mysql_query("SELECT bacoach FROM KHSAA_Schools WHERE member='T\' and ba='T'") or die('Error with query:<br />' . mysql_error());

Also remove the semi-colon on this line:
while($coaches=mysql_fetch_array($coachlist))
{
    echo vprintf("Coach: %s",($coaches[bacoach]));
}[/code]

I have modified it a little.

[jlong32]

Thanks that was perfect