[PHP-DB] bindParam OR bindValue

2010-12-28 Thread Ron Piggott
The INSERT INTO query successfully executes EXACTLY as it is. The bind’s aren’t working. :{Variable name] is being saved to the database. What do I need to change? I am not understanding this yet. Ron $dsh = 'mysql:host=localhost;dbname='.$database2; $dbh = new PDO($dsh, $username,

Re: [PHP-DB] bindParam OR bindValue

2010-12-28 Thread Artur Ejsmont
i am not 100% sure but should you not remove ' from around the variables to have (NULL, :f1, :l1 etc? prepared statements take care of escaping and quoting. http://www.php.net/manual/en/pdo.prepare.php does it help? art -- Visit me at: http://artur.ejsmont.org/blog/ -- PHP Database Mailing