mysqli prepapred SELECT statement
| From: | Support | Date: | Fri, 16 Jul 2004 17:15:47 +0000 |
| Subject: | mysqli prepapred SELECT statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-190734@lists.php.net to get a copy of this message | ||
Anyone working with php5/mysql 4.1 yet with the new ext/mysqli?
This has me stumped:
$stmt = $mysqli->prepare('SELECT * FROM users WHERE userid=?');
$stmt->bind_param('i', $userID);
$stmt->execute();
...now how to get the results??? I can't use bind_result() since I have no
clue how many columns `*' will retreive. I have been reading the docs now
for over two hours and need to get back to work :-)
$stmt->close();
Jim Grill