[RESOLVED] Parse Error

[focus310]

Hello:

I'm trying to test a SELECT query. When I run the query, I receive the following message:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Inetpub\fullfocus\Informed\test.php on line 11

I have stared at this query for a long time trying to figure out what's wrong. I can't seem to figure it out.

Can I get a second pair of eyes to look at my query?

Thank you in advance.

<?php

require_once ('mysql_connect.php');

$query = "SELECT a.lender_code, b.program_code, CONCAT(a.lender_code,b.program_code) AS prl FROM lender a, loan_program b;

$result = @mysql_query ($query) or die (mysql_error()); 

while($row=mysql_fetch_array($result))
{
$lender_code = $row['lender_code'];
$program_code = $row['program_code'];
$prl = $row['prl'];

echo "Lender:$lender_code<br>
      Program:  $program_code<br>
      Combo:  $prl<br>";
}
?>

[bike5]

I can see right off the bat that a end quote on your query var is missing

[focus310]

Yep, there it is. Thanks.

[bradgrafelman]

Two things would probably have helped you solve this problem on your own, and they both revolve around one key idea: syntax highlighting.

1. A ']' instead of a '}' at the end of your [PHP] tag (I've fixed this for you already).

2. Using an editor with syntax highlighting. Personally, I use Notepad2.