[SOLVED] insert and select help!

[countdrac]

im trying to do an INSERT then right away a SELECT (on that insert )

 

and for some reason the SELECT it returns nothing...

 

im kinda new to mysql...

 

$query = "INSERT INTO category (category_name) VALUES('".$category."')";
	$result = mysql_query($query) or die(mysql_error());

$query = "SELECT category_id FROM category WHERE category_name = '".$category."'";
	$result = @mysql_query($query) or die(mysql_error());
	while ($row = mysql_fetch_array($result)) 
	{
		$category_id = $row['$category_id'];
	}

 

thanks

[~n[EO]n~]

Your

$category_id = $row['$category_id'];

should be

$category_id = $row['category_id'];