-3

I get an error in my PHP script. Someone please kindly help me fix it. Thank you.

$sql="SELECT username, description, website FROM members WHERE City="NY" order by username";
rici
  • 219,119
  • 25
  • 219
  • 314
Sâu Bự
  • 65
  • 7

1 Answers1

0

Escape the inner quotes:

$sql="SELECT username, description, website FROM members WHERE City=\"NY\" order by username";
aergistal
  • 28,199
  • 5
  • 64
  • 88