Executing multiple sql statements

Executing Multiple SQL Statements Typically, your C# program and the database will run on different computers and communicate over a network. Each time you execute a command in your program

7p daisuphu 29-07-2010 108 7   Download

MANAGING MULTIPLE DATABASE TABLES } else { $sql = 'UPDATE blog SET image_id = NULL, title = ?, article = ? WHERE article_id = ?'; $stmt-prepare($sql); $stmt-bind_param('ssi', $_POST['title'], $_POST['article'], $_POST['article_id']); } $stmt-execute(); $done = $stmt-affected_rows; } The last two lines of this code block execute the prepared statement that updates the record in the blog table, and then assign the number of affected rows to $done. If you update a record, the affected_rows property is 1, which is treated as true.

10p yukogaru14 30-11-2010 42 5   Download