-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
  • 234,347
  • 28
  • 237
  • 341
Sâu Bự
  • 73
  • 8

1 Answers1

0

Escape the inner quotes:

$sql="SELECT username, description, website FROM members WHERE City=\"NY\" order by username";
aergistal
  • 29,947
  • 5
  • 70
  • 92