Getting an unexpected T_STRING when trying to retrieve data and store as variable

Question

I am unable to make $firstname equal to $row['Firstname']. The same with Lastname too.

$locationsQuery='select Firstname, Lastname, from locations where
username=$username;
 $results = sqlsrv_query( $conn, $locationsQuery, array($desiredusername));
 while($row = sqlsrv_fetch_array($results))
 {
 $firstname = $row['Firstname'];
 $lastname = $row['Lastname'];
 }

Is this copy/paste from the actual code? If so, you're missing a closing `'` after your query. — rickdenhaan, May 07 '17 at 17:48
Missing single quote `'` for your `$locationsQuery` variable — Thamilhan, May 07 '17 at 17:48
Your query also is open to SQL injections and invalid, strings need to be quoted. — chris85, May 07 '17 at 17:49
@Z.Sow You should delete the question since it isnt a programming issue. — chris85, May 07 '17 at 17:51
question's like these do not improve Stack's Q&A's and there are far too many already asked and in the process of deletion. — Funk Forty Niner, May 07 '17 at 17:51
there is also another "off-topic" syntax error; the trailing comma in the last column, as well as an unquoted string literal. — Funk Forty Niner, May 07 '17 at 17:52

score -1 · Answer 1 · answered May 07 '17 at 17:48

-1

You are missing a ' at the end of the first line containing $locationsQuery, in front of ;

answered May 07 '17 at 17:48

faffaffaff

3,429
16
27

1

https://meta.stackexchange.com/questions/174389/should-we-answer-or-comment-on-a-typo-question – chris85 May 07 '17 at 17:50
if you're going to go after an off-topic syntax/typo error, at the very least.. .get them all – Funk Forty Niner May 07 '17 at 17:55

Getting an unexpected T_STRING when trying to retrieve data and store as variable

1 Answers1