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
list in "store" table's store_id field
============
regds
amit
"The difference between fiction and reality? Fiction has to make sense."
On Sat, Aug 6, 2011 at 10:11 AM, Chris Stinemetz
<chrisstinemetz@xxxxxxxxx>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 or
> update a child row: a foreign key constraint fails (`store`.`posts`,
> CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post_store`) REFERENCES
> `stores` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)
>
> $sql = "INSERT INTO
> posts(market, type, post_store, post_tptest, post_content, post_by,
> post_date)
> VALUES('" . mysql_real_escape_string($_POST['market']) . "',
> '" . mysql_real_escape_string($_POST['type']) . "',
> '" . mysql_real_escape_string($_POST['post_store']) . "',
> '" . sha1($_POST['post_tptest']) . "',
> '" . mysql_real_escape_string($_POST['post_content']) . "',
> " . $_SESSION['user_id'] . ",
> NOW())";
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
