Hi,

I'm experiencing this wierd problem with and insert query. If I run the query in PHPAdmin it works fine, but when I run it from my PHP script using pg_query the 'directions" field is not populated in my postgresql database. All the other fields get populated correctly. I'm not getting any errors either. Maybe it's the semi colon in the middle?

Here's the query

INSERT INTO recipe (name, directions, yield, source , yield_unit ) VALUES ('Grandma''s Potato Salad', ' In top of double boiler over boiling water, heat water, butter and vinegar. In bowl, beat eggs; add sugar and cornstarch. Add to butter mixture; cook and stir constantly till thick, 5-7 min. Remove from heat and allow to cool. Stir in mayonnaise; fold in whipped cream. In a large bowl, toss potatoes, onion, green onions, salt and pepper. Pour dressing over and mix gently. Chill. Serve in lettuce-lined bowl if desired. Garnish with cooked eggs and sprinkle with paprika. ', '18', 23 , 1 )

Any body experienced this before, or have any ideas? Any help would be most welcome.

Thanks
Barbara

    Does [man]pg_result_error[/man] report anything?

      I fixed it - Thanks

        Write a Reply...