[SOLVED] Mysql SELECT returns 0

[TomGrooby]

					$authorid = mysql_query("SELECT id FROM users WHERE username='$cookieuser'") or die(mysql_error());


						$category = $_GET['cat'];
						$date = date("j F Y");
						$title = $_POST['title'];
						$topicbody = addslashes(strip_tags($_POST['topicbody']));
						$image = $_POST['group1'];


					$querytopic = mysql_query("

					INSERT INTO topics VALUES ('', '$authorid', '$date', '$title', '$topicbody', '$category', '$image')						
					");

					echo "Topic sucessfully created.. Click <a href=\"category.php?cat=".$category."\">here</a> to view.";

 

 

I am using the code above as part of a simple post and reply forum that I am building for my site.

This part is inserting data from a form into a database to make a new topic. The script works for every variable apart from $authorid. It inserts 0 for every user. I have tried using mysql_fetch_assoc in a loop but then I cant insert the data aswell.

 

I am really confused here, all help will be appreciated. 

[mikesta707]

read your question wrong. nevermind ig got it.

[ignace]

$query = mysql_query("SELECT id FROM users WHERE username='$cookieuser'") or die(mysql_error());
list($authorid) = mysql_fetch_array($query, MYSQL_NUM);

[TomGrooby]

$query = mysql_query("SELECT id FROM users WHERE username='$cookieuser'") or die(mysql_error());

list($authorid) = mysql_fetch_array($query, MYSQL_NUM);

 

that doesn't work either. It just inserts 0 when it should be 1. 

 

 

EDIT: IF I ECHO OUT THE $AUTHORID IT GIVES A RESOURCE ID.

[ignace]

$query = mysql_query("SELECT id FROM users WHERE username='$cookieuser'") or die(mysql_error());

list($authorid) = mysql_fetch_array($query, MYSQL_NUM);

 

that doesn't work either. It just inserts 0 when it should be 1. 

 

 

EDIT: IF I ECHO OUT THE $AUTHORID IT GIVES A RESOURCE ID.

 

Then you are not using my code.

[TomGrooby]

I solved it. It was an error in one of my variables  your code works. thank you.

[Maq]

I solved it. It was an error in one of my variables  your code works. thank you.

 

Then please mark as so.