help, cant unsibscribe

[Kenneth Johansen]

sql <- ignore.

yesterday i sent an email to:
[EMAIL PROTECTED]
to get unsibscribed, but today i discovered that it didnt work. So i
tried
http://lists.mysql.com/php/unsubscribe.php
After a while i got an auth code and a link. when i checked the link
it said that i wasnt subscribing to  [EMAIL PROTECTED]
,but im still recieving emails.

anyone got any ideas ?

kenneth johansen
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem with C API and mysql

[kenneth johansen]

hello everybody.
Ive been working with perl and mysql for some time, but recently i had
to move over
to C and as such i wrote a small test program, just to get to know the
mysql C API.
Well, things didnt go as i thought. i kept getting linking problems
and in the end my test program was limited to the few lines bellow:

#include 
#include "mysql.h"
#include 
#include 

int main(){

  MYSQL *mysql;

mysql = mysql_init(NULL);
  if (mysql == NULL) {
fprintf(stderr,"mysql_init() failed (foobar\n");
exit(1);
  }
}
+

i compile this with:
gcc -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ program.c
-lmysqlclient

but i always get the error message:
/usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/local/mysql/lib//libmysqlclient.a(my_compress.o): In function
`my_compress_alloc':
my_compress.o(.text+0x12b): undefined reference to `compress'
collect2: ld returned 1 exit status

doing an nm on libmysqlclient.a does reveal that the compress functions
are there,but
for some reason it wont work.

appriciate any/all help

regards
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

howto insert a variable in a query in C?

[Kenneth Johansen]

hi all, im currently using a C program to access my mysql database.
but i have a small question.
How do i insert a variable into a query?
imagine:
*query="select blah,blah from table_name where name = variable";

im a bit in the dark on this one and would appriciate any/all suggestions.

regards
kenneth johansen
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem using mysql_fetch_row in C API

[Kenneth Johansen]

hi all, ive got a small problem (again).
i have a table with an entry "foo" which is an int(3).

my problem is that whenever i collect the values in my c program.
they are returned as characters with mysql_fetch_row. (which is ok)
but i cant seem to convert them into int,
using something like

temp = (int) row[0];

this might not (strictly) be a mysql question.
but IMHO i dont think a C forum is the right place either.

any reply
appriciated

regards
kenneth johansen
[EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem with mysql_query in C API

[Kenneth Johansen]

hi all, i have a small problem

im using mysql_query to access my mysql database.

now then, i have 2 queries, 1 just after the other.
the first one goes ok, the second one never does.

doesnt matter if i switch the queries, the one that is last never works.

if i write the query in an xterm (using linux), which has a sesstion
towards the mysql database
then it works fine.

im clearly missing something here.

anyone know what ?

any replies appriciated.

regards
kenneth johansen
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php