digitalbill

Yesterday, I decided I want to learn a little programming........ I built a development host, Fedora Core6 + Apache + Postgresql-8.1.6-1 + PHP-5.1.6-3.3.  I created a database and a table and columns and put data in the columns. Created a simple page with a form: <form action="http://192.168.1.39/tests/postgres2.php" method=post> postgresql2 <br> Enter Users name <input type=text name=data> <br> <input type=submit value="Search database"> </form> But I think my syntax is incorrect in my "postgres2.php" script, specifically this line: $sql="SELECT * FROM phones WHERE people = '" . $data . "'";  If I swap out  = '" . $data . "'";  with a the name of a person from "people" column, $sql="SELECT * FROM phones WHERE people = 'Bill’    The script runs fine and provides me with the expected output. I tried  $sql="SELECT * FROM phones WHERE people = '" . $data . "'";  print $sql; This output is generated on the web page: SELECT * FROM phones WHERE people = '' And thats why I think I have a sytntax error in that line.  I just can’t figure it out, I tried playing with the quotes. Its  probably something fundamental that I just don’t understand yet. Im open to Any Suggestions at this point :-) Thanks!