Jump to content


Photo

Printing from an array


  • Please log in to reply
2 replies to this topic

#1 jlong32

jlong32
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationLexington

Posted 31 August 2006 - 04:42 PM

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();
The completely lost PHP Programmer

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 31 August 2006 - 04:52 PM

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

Also remove the semi-colon on this line:
while($coaches=mysql_fetch_array($coachlist));

Your new code:
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]));
}

I have modified it a little.

#3 jlong32

jlong32
  • New Members
  • Pip
  • Newbie
  • 3 posts
  • LocationLexington

Posted 31 August 2006 - 05:01 PM

Thanks that was perfect
The completely lost PHP Programmer




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users