an error in your SQL syntax near '.TeamName LIKE '%

[neobis]

I am getting the error message :

You have an error in your SQL syntax near '.TeamName LIKE '%'' at line 1.

My code is :

$sqlVar="SELECT * FROM fixtures";
{
$sqlVar.="WHERE fixtures.TeamName LIKE '%".$_GET['TeamID']."'";
}

Can anybody give me any advice on my code above and why I am getting the error message. The lcodee looks OK to me?

Many Thanks in advance.
N.

[dancahill]

I would do this:

$TeamID = $_GET["TeamID"];

$sqlVar="SELECT * FROM fixtures WHERE fixtures.TeamName LIKE '%$TeamID%'";

[thom]

$sqlVar="SELECT * FROM fixtures";
{
$sqlVar.="WHERE fixtures.TeamName LIKE '%".$_GET['TeamID']."'";
}

if the above is your exact code the string $sqlVar should have the following value:

SELECT * FROM fixturesWHERE fixtures.TeamName LIKE '%".$_GET['TeamID']."'"

It is obvious then that you need a space between fixtures and WHERE. It's often good to echo out sql queries, it is often very obvious what's wrong.

the advice dancahill gave you was good, simplifies your code.

regards,
thom