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@xxxxxxxxxxxxx>
To: <php-windows@xxxxxxxxxxxxx>
Sent: Monday, 17 February, 2014 6:09 PM
Subject: 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...'
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php