Set default value to value of other field?

[DanielLiljeberg]

Hi

Can I have a table something like this:

COL A
COL B
COL C

where COL B's default value (if none is inserted) is the value entered in COL A?

[kender]

after submit, or while filling out?
if while filling out you would use a javascript code to insert the col b or col c when pressing a submit button
if on submit then it would be how you handle your variables...

... if (!isset( value == col a value)) sort of thing

[DanielLiljeberg]

I mean internaly in the mySQL server like you can set deafult values for all columns that does not get an assigned value when you insert a new record.

[kender]

ok, then it would be something like

if(isset($_POST)) {

if $_POST['cola'] == NULL {
	echo 'Please fill out Col A';
} else {
	$cola = $_POST['cola'];
}

if $_POST['colb'] == NULL {
	$colb = $_POST['cola'];
} else {
	$colb = $_POST['colb'];
}

if $_POST['colc'] == NULL {
	$colc = $_POST['cola'];
} else {
	$colc = $_POST['colc'];
}

	$query = mysql_query
		("INSERT INTO table_name VALUES('$cola','$colb','$colc')") or die(mysql_error());

quickly done, and not tested, but should get you on your way