--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db.h	Mon May 12 21:24:20 2008 +0200
@@ -0,0 +1,40 @@
+/*
+ * data for the database connection
+ */
+
+char* server = "localhost";
+char* user = "garten";
+char* password = "gras";
+char* database = "garten";
+
+MYSQL* conn;
+MYSQL_RES* result;
+MYSQL_ROW row;
+
+
+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));
+		exit(1);
+	}
+}
+
+
+void db_close() {
+	/* close connection */
+	mysql_close(conn);
+}
+
+
+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));
+	}
+}