Re: Mysqli data cacheing, of sorts

And, right after I sent that message, I remembered where had found mention of data change committing before: http://www.w3schools.com/php/func_mysqli_commit.asp And, for turning auto commit on or off: http://www.w3schools.com/php/func_mysqli_autocommit.asp In other words, sorry for posting original query/question...<smile> Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...' ----- Original Message ----- From: "Jacob Kruger" <jacob@blindza.co.za> To: <php-windows@lists.php.net> Sent: Monday, 17 February, 2014 6:09 PM Subject: [PHP-WIN] Mysqli data cacheing, of sorts Not sure if relevant, but, just wondering... Either way, busy with a largeish data capture webpage, and to try a bit of testing, am trying to wipe out any prior data entered higher up in page, using something like the following: $mysqliObj->query("delete from tbl_table_name;"); and, then lower down, when I run something similar to the following, it does still seem to retrieve the prior data: $res = $mysqliObj->query("select * from tbl_table_name;"); Do I need to set a specific mysqli/mysql option, or do something like close and re-open the connection to have my prior delete, or insert/update queries taken note of? And, asking this since am pretty sure I remember something like this being necessary, but, can't remember enough details, or find anything obviously relevant via google searches, etc.? TIA Jacob Kruger Blind Biker Skype: BlindZA '...fate had broken his body, but not his spirit...'