--- a/db.h	Wed Jul 23 11:40:45 2008 +0200
+++ b/db.h	Wed Jul 23 11:41:38 2008 +0200
@@ -2,39 +2,51 @@
  * data for the database connection
  */
 
-char* server = "localhost";
-char* user = "garten";
-char* password = "gras";
-char* database = "garten";
+#include <sqlite3.h>
 
-MYSQL* conn;
-MYSQL_RES* result;
-MYSQL_ROW row;
+char* database;
+char query[1024];
+sqlite3* db;
+sqlite3_stmt* stmt;
+
 
 
 void db_connect() {
-	conn = mysql_init(NULL);
-
-	/* Connect to database */
-	if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
-		fprintf(stderr, "%s\n", mysql_error(conn));
+	if (sqlite3_open(database, &db) != SQLITE_OK) {
+		fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
+		sqlite3_close(db);
 		exit(1);
 	}
 }
 
 
 void db_close() {
-	/* close connection */
-	mysql_close(conn);
+	sqlite3_close(db);
 }
 
 
+/*
+static int callback(void* NotUsed, int argc, char* argv[], char* azColName[]){
+	NotUsed = NULL;
+	int i;
+	for (i = 0; i < argc; i++) {
+		printf("%s = %s\n", azColName[i], argv[i] ? argv[i]: "NULL");
+	}
+	printf("\n");
+	return 0;
+}
+
+int rc;
+char* zErrMsg = 0;
+rc = sqlite3_exec(db, query, callback, 0, &zErrMsg);
+*/
+
+
 void db_query(char* query) {
 	int error;
-	/* send SQL query */
-	error = mysql_query(conn, query);
-	/*printf("query: %s\nerror: %d / %d\n", query, error, mysql_errno(conn));*/
-	if (error != 0) {
-		fprintf(stderr, "E: %s\n", mysql_error(conn));
+
+	error = sqlite3_prepare(db, query, -1, &stmt, NULL);
+	if (error) {
+		fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));
 	}
 }