Chris,
Why not escape, and extract the data prior to Insert string?
On 06/08/2011 05:41, Chris Stinemetz wrote:
I am getting the following error trying to run the below query. Any
suggestions on what I am doing wrong?
Thank you,
Something went wrong while inserting your store visitCannot add
I hope this isn't condescending, but you have a foreign key constraint that
is failing. I would probably echo the output of $_POST['post_store'] to see
what value, if any, is being written. If the output seems proper, I'd check
your other table and make sure that the data exists in that table.
Chris
The error is indicated by the keywords a foreign key constraint fails, This
implies that some value in store table is missing which u are trying to
insert in posts. So check for the value u are trying to input in post
table. U have to check for the values of post_store field from the input
