if( conn

NULL )

printf("Failed to initate MySQL\n");
return 1;

/*The next step is to actually connect to the database. This is where the conn variable and the host,
if( ! mysql_real_connect(conn,host,username,password,database,0,NULL,0) )

printf( "Error connecting to database: %s\n", mysql_error(conn));
return 1;

mysql_query(conn,"SELECT name, email, password FROM users");
/*In our example, there will most likely be more than one row returned (i.e., if there are more than one user in
the users table of the database). If so, then you need to find how many rows are returned so that you can
unsigned int num_fields = mysql_num_fields(res_set);
/*Finally, we retrive the result using the function mysql_fetch_row() and then print out all of the data in large chunks.

for(i = 0; i < num_fields; i++)

printf("%s\t", row[i] ? row[i] : "NULL");

printf("\n");

/*Last but certainly not least, we close our connection to the database*/

/*Followed by that, we tell mySQL that are are about to connect with the mysql_init() function.
We pass a value of NULL to it because for our purposes, we don't need to go into it any further:*/
conn = mysql_init(NULL);
/*The next step is to actually connect to the database. This is where the conn variable and the host,
username, password, and database #define's are used:*/
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
/*The next 3 lines are code that define variables to get a result and row pointer from the database,
along with a variable to increment in the loop if there is more than one row returned by the query:*/
MYSQL_RES *res_set;
MYSQL_ROW row;
unsigned int i;
/*Finally, we query the database with the following query using the mysql_query() function: "SELECT * FROM users" like so:*/
mysql_query(conn,"SELECT * FROM users WHERE userid=1");
/*After querying the result, we need to store the result data in the variable res_set we defined earlier. This is done like so:*/
res_set = mysql_store_result(conn);
/*In our example, there will most likely be more than one row returned (i.e., if there are more than one user in
the users table of the database). If so, then you need to find how many rows are returned so that you can
loop through each one and print the result of each one like so:*/
unsigned int numrows = mysql_num_rows(res_set);
/*Finally, we retrive the result using the function mysql_fetch_row() and then print out all of the data in large chunks.
This is done like so:*/
while ((row = mysql_fetch_row(res_set)) != NULL)
{
}
/*Last but certainly not least, we close our connection to the database. When there are multiple connects and many users
accessing the database at the same time, it is essential that you connect and disconnect as soon as possible, or you can
have disasterous results. The final lines of code disconnect from the database and then exit the main() function:*/
mysql_close(conn);
return 0;

DBPROCESS *dbproc;
LOGINREC *login;
DBCHAR name1[15];
DBINT no1;
RETCODE ret_code;
fflush(stdout);
dbinit();
login=dblogin();
DBSETLUSER(login,<Login name>);
DBSETLPWD(login,<Password>);
dbproc=dbopen(login,NULL);
dbcmd(dbproc,"select * from table");
dbsqlexec(dbproc);
return 0;