Re: Prepared statements

> MySQL returns "Column 'auction_house' cannot be null". > Here're some parts of my code: > > --- code --- > > $update = $this->sql->stmt_init(); > $update->prepare("UPDATE auctions SET name=?, auction_house=?, link=?, > prize=?, runtime=?, bids=?, picture=? WHERE link=?"); > $update->bind_param("sisdsiss", $auction_parts["name"], > $auction_house["id"], $auction_parts["link"], > $auction_parts["prize"], > $auction_parts["runtime"], $auction_parts["bids"], > $auction_parts["picture"], $auction_parts["link"]); > > $insert = $this->sql->stmt_init(); > $insert->prepare("INSERT INTO auctions (auction_house, name, link, > prize, runtime, bids, picture) VALUES (?, ?, ?, ?, ?, ?, ?)"); > $insert->bind_param("issdsis", $auction_house["id"], > $auction_parts["name"], $auction_parts["link"], > $auction_parts["prize"], > $auction_parts["runtime"], $auction_parts["bids"], > $auction_parts["picture"]); > > --- /code --- > > after this, there's the loop, in which I do either $update->execute(); > or $insert->execute(); - the $update->execute(); runs without problems > but the $insert->execute runs into the described problem. So at some point the $auction_parts['id'] is empty. As you go into the loop, print out the $auction_house["id"], then work backwards... -- Postgresql & php tutorials http://www.designmagick.com/