insert data code not working

mistafeesh

Please be gentle with me. wasn't sure whether to put this in here or in the noobs section.

I've got some code wot i wrote to insert data from dynamically generated checkboxes into my DB. It's my first try at something like this - usually Dreamweaver can do it for me...

here's the code:

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

I put the echo in for testing if the data had been passed over OK, and it all shows up just fine, but the database remains empty. the $cat variable is there to recreate the names the previous page gave to the checkboxes.

LordShryku

Are those variables numeric or strings? If they're strings or your database is setup to take those as strings, you'll need to use single quotes around them in the sql.

mistafeesh

they're numbers, but I'll give it a shot anyway.

edit--nope, that didn't fix it🙁

mistafeesh

I'm getting well conused here. I've added in a select_db thang, in case it'd forgotten what database it was looking at. I've added in quotes just in case it needed them. I've put in an "or die" condition to try and find out the error, but still the page happily echoes the results, but won't put them in the bl**dy database.

here's the code so far:

<?php  do { 
	$cat="catbox".$row_category['cat_id'];
	if (isset($_POST[$cat]))  {
	$cat_id=$_POST[$cat];
	$user_id=$_POST[uid];
	mysql_select_db($database_act, $act);
	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>";}	
	 } while ($row_category = mysql_fetch_assoc($category)); ?>