Select statement with .$row

Question

I wonder what is wrong with this select statement. this is the error i am getting:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/www/mp28.bit-mp.biz/CardRegistration2.php on line 47

$query = "SELECT PlayerName FROM Players where TeamName = .$row['Team1']";

score 1 · Accepted Answer · answered Jan 27 '16 at 05:03

1

$query = "SELECT PlayerName FROM Players where TeamName = .$row['Team1']";

should be

$query = "SELECT PlayerName FROM Players where TeamName = '{$row['Team1']}'";

answered Jan 27 '16 at 05:03

kamal pal

4,187
5
25
40

I want to populate a dropdown list with values from two different columns e.g. Away vs Home xxx vs yyy I want to populate a dropdowlist: --select-- xxx yyy Anyone can help me with this?? – MOHW Jan 28 '16 at 08:26

score 0 · Answer 2 · answered Jan 27 '16 at 05:06

0

Query correction check two solutions. Both should work:

$query = "SELECT PlayerName FROM Players where TeamName =" .$row['Team1'];

OR

$query = "SELECT PlayerName FROM Players where TeamName ='" .$row['Team1'] . "'";

Concatenation issue at TeamName =

answered Jan 27 '16 at 05:06

AddWeb Solution Pvt Ltd

21,025
5
26
57

score 0 · Answer 3 · answered Jan 27 '16 at 05:07

0

$query = "SELECT PlayerName FROM Players where TeamName = '".$row['Team1']."' ";

Try this. TeamName column is varchar so passing string enclosed with quotes.

answered Jan 27 '16 at 05:07

Shailesh Katarmal

2,757
1
12
15

Select statement with .$row

3 Answers3