Get warning info from mysql_info()

[Jamie Jennings]

I'm trying to use a INSERT INTO table1 (column1,
column2, column3) SELECT 'value', 'value2',
table2.value3 FROM table2 WHERE table2.value4='name';

This query fails from C, but if I copy and paste it
exactly to the mysql client, it works.

If I run mysql_info(), it tells me: 
Records: 0  Duplicates: 0  Warnings: 1

But I have no idea what the warning is. Is there any
way to find out? mysql_error returns '\0' so it's no
help.

Thanks!

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca