hey all,

I'm writing an embedded SQL C program and I have a really stupid problem.

I'm using the following to get some input from the user:

Code:
fgets(artist_name_c, sizeof(artist_name_c), stdin)
it then is supposed to do some SQL work and come back. However, when it gets to that line, it just goes right through it as if the user has simply pressed enter and entered nothing. I know the SQL code is done correctly and the "artist_name_c" has been declared correctly. I've also tried using "gets" but I get the same result.

Does anyone know why? If I use scanf it works, but if you put more than one word in, it treats it like 2 seperate words and puts two entries in my DB. help?