c++ and mysql api

i am using redhat 8.0 and installed MySQL++ 1.7.9 RPM for Red Hat 8.0 with gcc 3.2 installation went fine.when i tried to compile the following code

#include <iostream>
#include <iomanip>
#include <sqlplus/sqlplus.hh>

Code:

---

int main()
{
        Connection con("mysql_cpp_data");
       
        Query query=con.query();
        query<<"select * from stock";
        Result res =query.store();
       
        cout<<"query: "<,query.preview()<<endl;
        cout<<"Records found: "<<res.size()<<endl<<endl;
       
        Row row;
        cout.setf(iso::left);
        cout<<setw(17)<<"item"
            <<setw(4)<<"Num"
            <<setw(7)<<"weith"
            <<setw(7)<<"price"
            <<"date"<<endl
            <<endl;
       
        Result::iterator i;
       
        for(i=res.begin();i!=res.end();i++){
                row = *i;
                cout<<setw(17)<<row[0]
                    <<setw(4)<<row[1]
                    <<setw(7)<<row["weight"]
                    <<setw(7)<<row[3]
                    <<row[4]<<endl;
        }
        return 0;
}

---

i got a lot of errors 20 pages or so first one is mysql.h is not found what other thing i have to install to use the api

Read this , then edit your post accordingly please.

i copied all includes file from /usr/include/mysql and /usr/include/sqlplus to /usr/include now works but still get lots of undified reference errors.

thx it took me an hour to figure problems but al last working thx everybody