Help!

VinnyWolf

I am trying to use a Php script to read information from a MySQL database and display it in an html table. For some reason, though, I keep getting the following error:

Parse error: parse error, unexpected T_STRING in /srv/www/htdocs/surveys/helpdesk/surveyresults.php on line 27

<body>
<?php

// Set the variables for database access

$User = "";
$Password = "";
$DBName = "";
$TableName = "";

$Link=mysql_connect (localhost, $User, $Password);

$Query="SELECT * from $TableName";

$Result="mysql_db_query ($DBName, $Query, $Link);

//Create a table for data

while ($Row=mysql_fetch_array ($Result)){

Line 27---> print ("<table border=1>\n");
print ("<TR>");
print ("<TD>Work Order #:</TD><TD align=center>$Row[wo]</td>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD>Technician:</TD><TD ALIGN=CENTER>$Row[technician]</TD>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD>Quality of service:</TD><TD ALIGN=CENTER>$Row[question1]</TD>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD ALIGN=RIGHT>Comments:</TD><TD>$Row[comments1]</TD>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD>Provided in a timely manner?</TD><TD ALIGN=CENTER>$Row[question2]</TD>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD ALIGN=RIGHT>Comments:</TD><TD>$Row[comments2]</Td>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD>Technician was helpful and professional?</TD><TD ALIGN=CENTER>$Row[question3]</TD>\n");
print ("</TR>\n");
print ("<TR>\n");
print ("<TD ALIGN=RIGHT>Comments:</TD><TD>$Row[comments3]</TD>\n");
print ("</TR>\n");
}
mysql_close ($Link);
print ("</TABLE>\n");
?>
</BODY>
</HTML>

I cannot figure out what is wrong with that line or why it does not like the "print" command???

I have a similar Php script that submits the info from an html form to the database and it works fine. I also use the "print" command in that script without any problems.

I'm stumped...

Vinny

thorpe

im only a newb, but i have found another error in your code that might be giving you grief. not sure it could have caused this error though.

but anyway, this line has a double quote in it that should'nt be there.

$Result="mysql_db_query ($DBName, $Query, $Link);

change it to;

$Result=mysql_db_query ($DBName, $Query, $Link);

VinnyWolf

That was it! Thanks thorpe!
Those dumb a$$ syntax errors get me every time. I am going to start using Scintilla.

Thanks again,

Vinny

rgermain

If you think about how the parser works, those errors make since and after using PHP for many projects, you actually began to fully understand why they throw the errors they do and why they give the wrong line number.

VinnyWolf

Yes, I am an admitted newbie. It's just a little misleading when the error message says that there is a problem with line 27 when the actual error (syntax) is several lines previous.

Thanks again eveyone,

Vince