php - Mysql SELECT after succesful INSERT is empty -

on development server run script inserts data, fetches insert id , later uses id select row. works fine. when push test server result empty.

for testing echo insert query, insertid , select query.

• insert test (id, title) values (null, 'testtitle');
• id: 485
• select * test id = 485

the row added database, because can query echoed query later , shows, @ script runtime select stays empty.

any1? there should know transactions or something?

greeting