PostgreSQL and PHP4

[Anon]

I am using this line to access a particular record called by an HTML page:

$result = pg_exec($conn, "SELECT * FROM tasklist WHERE taskcode = $tcode;")

when i enter 'ET-A01' I get an error "attribute 'et' was not found in blah,blah,blah in line blah.

but when i plugged the exact data i get a result.

where am i wrong?

thanks in advanced.

[Anon]

Put $code in single quotes ("SELECT * FROM tasklist WHERE taskcode = '$code'") - it will then not confuse the - for a minus sign.

Ori

[Anon]

I have a problem which is same as Ronnie's and I've tried your solution and it works then. But I have a problem with the single qoute because some of my data contains the apostrophy ( ' ), therefore, where the query insert such data into the database, it shows error.
My query looks something like this:

INSERT INTO test (id, test) VALUES ('$id', '$test');

The $test variable may contains apostrophy ( ' )

I thought to change the ' ' to \"\" so that I could get around with the ' but then it shows the same error as previous, like, ERROR: Attribute "xxx" not found

Any idea of how can I get around with it ?

TIA.