alex wacko
New Member
I'm working with a sequence of queries created with PDO class, in some case, my queries needs the same paramter.I've created an array used in a foreach statemend which save the data but some var is ouside, can I use both data in one query?the example:\[code\]// $connection is the PDO object;// $full_data contains:// $full_data[$i]["address"]// $full_data[$i]["phone"]// $full_data[$i]["email"]// $full_data[$i]["user_id"]// $full_data[$i]["surname"] // not used but present// $full_data[$i]["name"] // not used but present$sql = "UPDATE users_table SET city = :address, phone = 
hone, email = :email, admin_id = :admin_id, admin_name = :admin_name WHERE user_id = :user_id";$statement = $connection->prepare ($sql);$statement->bindParam (':admin_id', trim($admin_id), PDO:ARAM_INT);$statement->bindParam (':admin_name', trim($admin_name), PDO:ARAM_STR);foreach ($full_data as $value) { $ok = $statement->execute ($value); $num = $statement->rowCount ();}} catch (PDOException $e) { return $e->getMessage ();}\[/code\]this page return me the error:\[code\]SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\[/code\]what is exacltly the problem, on an UPDATE satement the tenique works
hone, email = :email, admin_id = :admin_id, admin_name = :admin_name WHERE user_id = :user_id";$statement = $connection->prepare ($sql);$statement->bindParam (':admin_id', trim($admin_id), PDO:ARAM_INT);$statement->bindParam (':admin_name', trim($admin_name), PDO:ARAM_STR);foreach ($full_data as $value) { $ok = $statement->execute ($value); $num = $statement->rowCount ();}} catch (PDOException $e) { return $e->getMessage ();}\[/code\]this page return me the error:\[code\]SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens\[/code\]what is exacltly the problem, on an UPDATE satement the tenique works