pg_atoi problems

[SeenGee]

I've built a postgres database that can be controlled through browser inputs to update, insert or delete records. i'm using php to access the db and display results in html. all of my update commands work fine but my inserts will not, each time i try to insert it kicks out this line:

Warning: PostgreSQL query failed: ERROR: pg_atoi: error in "head": can't parse "head" in ....... on line 47

for this example "head" is an attribute of type text which is all set up properly to send and hold the correct attribute type ($tag_method in the sql under here). Line 47 refers to the sql command in my php which looks like this:

LINE 46: $sql="INSERT into sheep values ('$tag_method', $flock_id, '$sex', '$breed' , $age, $parent_id, '$born_on_farm', '$date_joined', $price_paid, $price_sold, $sheep_number)";

LINE 47: $result_set = pg_Exec ($conn, $sql);

Would really appreciate any ideas people may have as to wat's going on.

[Sxooter]

Sure, text data has to be single quoted to be inserted, while no quotes denotes a numeric / float / int value.

i.e. you need to add ' around that field.

[chriskl]

You can't insert a string or '' into an integer field. Just make sure you're actually inserting an actual number into your integer field.