[HowdeeDoodee]

I want to use a variable at the end of a MySql statement but cannot get the following SELECT statement to work using a variable. I can get the SELECT statement to work if I use a text string in the statement.

The following 2 statements return an error from the mysql_query

$input = 'test';
$query = ("SELECT * FROM `View1` WHERE `Topic` = $input");

$query = ("SELECT * FROM `View1` WHERE `Topic` = '$input'");


The following statement does NOT return an error from the mysql_query

$query = "SELECT * FROM `View1` WHERE 'Topic` = 'test'";


$result = mysql_query($query) or die("ERROR63");[/size][/size]

Help would be appreciated.

[Chicon]

Hi HowdeeDoodee;

Did you try this ?
$query = "SELECT * FROM `View1` WHERE `Topic` = " + $input;

[HowdeeDoodee]

Chicon...

No, sorry that did not work. However, I did resolve the issue.

$input must be made to appear as if the string or word "test" is enclosed by single quotes when the SELECT statement is evaluated or run.

Here is the fix.

$input = "'test'";

the word "test" is enclosed first with single quotes and then in double quotes. By using double quotes the single quotes appear to be part of the string expression.