Insert then select ??
Posted: Mon Apr 14, 2003 10:18 am
Ok here’s the scenario
I input a load of data into a table. Directly under the “Insert sql” I run a select statement based on finding the data I have just inserted. It always comes up blank. If I go back in to the page and search again then the data appears.
I have taken to closing mysql connections after the insert in the hope that a new connection will in effect refresh the database and display the new data – didn’t work.
With out posting a shed load of code here, is there anything in the protocol / logic that I’m missing?
Cheers,
Lee.
I input a load of data into a table. Directly under the “Insert sql” I run a select statement based on finding the data I have just inserted. It always comes up blank. If I go back in to the page and search again then the data appears.
I have taken to closing mysql connections after the insert in the hope that a new connection will in effect refresh the database and display the new data – didn’t work.
With out posting a shed load of code here, is there anything in the protocol / logic that I’m missing?
Cheers,
Lee.