Posted by Jm on 05/02/05 21:26

Ok who's using mysqli? I'm moving over to the mysqli OO method. I'm
trying to perform an insert and having difficulty.

$sql = "INSERT INTO USERS (record_id, name_first, name_last) VALUES
(1, 'George', 'Dubbuyah')";

$mysqli->query($sql);

I have a followup SELECT that prints the rowcount so I can see if the
rows are increasing but they aren't. I figured this would be enough
for the insert, I even tried:

$mysqli->commit();

but their is no change. The SELECT is returning the correct amount of
rows. Any suggestions?

--
J

[Back to original message]