can't get data into DB!

[mistafeesh]

Sorry to re-post, but I've had no answers so far, and I'm doing my nut!

I've come to the end of Dreamweavers abilities, and I'm having to do stuff meself. Please can someone tell me why the following code won't work? I've put in the 'echo' line to see if the variables are working properly.

I guess there must be something wrong with the mysql_query line...

<?php  do { 
	$cat="catbox".$row_category['cat_id'];
	if (isset($_POST[$cat]))  {
	$cat_id=$_POST[$cat];
	$user_id=$_POST[uid];
mysql_pconnect($hostname_act, $username_act, $password_act) or die(mysql_error('poo'));
	mysql_query ("insert into TABLE dir_rel_cat(cat_id,user_id) VALUES ('$cat_id','$user_id') or die(mysql_error('yarg')");
echo $cat_id.",".$user_id."<br>";}	
	 } while ($row_category = mysql_fetch_assoc($category)); ?>

[Pig]

You have the die command inside of your query. It should be:

mysql_query ("insert into TABLE dir_rel_cat(cat_id,user_id) VALUES ('$cat_id','$user_id')")
     or die(mysql_error()); 
echo $cat_id.",".$user_id."<br>";}     

[mistafeesh]

I put those bits in just in case I was getting an empty error message and couldn't see it. Just removed them again, and still no dice.

Just thought...this stuff is in the 'body' - does that matter?

[mistafeesh]

shameless bump! surely someone can help! Please! This is the third or fourth time I've asked about this specific problem, and I'm totally stumped...