Adding string to a sql string

[snoopy6129]

Hi All,
I'm trying to add a string into an already existing string. I want to pretty much have the following string

$sql_ad = "SELECT * FROM Ad WHERE";
$sql_ad = $sql_ad." StateIDKeyRef='$StateID'";  
           // sql_ad + "(another string)"

to attain this string exactly

$sql_ad = "SELECT * FROM Ad WHERE StateIDKeyRef='$StateID'";

When I run the joint string above, it gives me SQL syntax error. I really don't know if I'm joining the string correctly, or is it SQL that is giving me the problem?

Thank you in advance for your help

 

[sleipnir214]

Output the string. Does it look like it should?

What does your database server error message report?

One thing that pops out at me...you need a space after WHERE. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[KempCGDR]

He has the space at the start of the next string, but yeah, try echoing the string and checking what it turns out as.

 

[sleipnir214]

Actually, he does not.

The second part of the concatenation begins with a variable, not a string.

Also, the operator in the second line should read ".=", not "=". Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[skiflyer]

I think you're mis-reading the code sleipnir...

$sql_ad = "SELECT * FROM Ad WHERE";
$sql_ad = $sql_ad." StateIDKeyRef='$StateID'";

is functionally equivalent to

$sql_ad = "SELECT * FROM Ad WHERE";
$sql_ad .= " StateIDKeyRef='$StateID'";

There's no doubt that your other two tips however will reveal what's going on.

-Rob

 

[sleipnir214]

Oops.

Yep, you're right. Teach me to pay more attention to variable names.

But my first two pieces of advice are the ones he should have done before he ever posted here. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[snoopy6129]

I haven't a clue what went wrong... but I used

$sql_ad = "SELECT * FROM Ad WHERE";
$sql_ad .= " StateIDKeyRef='$StateID'";

and it echoed

SELECT * FROM Ad WHERE StateIDKeyRef='37'

Worked out perfect, ran the statement and it queried perfectly. Thanks everyone for your help.