I am using mysql 4.0.17 on Red Hat Linux.

I am using the C API to access mysql

The application I am writing should parse a xml file and write details to the mysql database.

The xml elements as they are read are fed into a simple data structure. On the completion of the structure details the datbase should be checked for a prior entry.

This works successfully for the first 3 entries. The 4th. entry executes the SELECT statement but appears to wipe the structure contents

The code is as follows.

select_query = "SELECT file_id FROM File WHERE file_name = 'RPCMap.h'";

mysql_query (conn, select_query);

I know that the line containing the mysql_query statement destroys the struture data content because I have used gdb to print the structure values as I step through the code.

Thanks

Melly