HI there fellas,
I am currently working on this piece of code and is experiencing some difficulties here:

The Objective of this piece of code is to enter some data in a from and then hit submit: the information will then immediately go into the database.

The Error:
I received the error:
Column 'breed' cannot be null

I really don't understand what's happening here....

Here's the code for the insert data page

[code]
<?php require_once('Connections/connPets.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "insert_dat")) {
$insertSQL = sprintf("INSERT INTO adoption_list (species, breed, name, age, personality) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['species'], "text"),
GetSQLValueString($HTTP_POST_VARS['breed'], "text"),
GetSQLValueString($HTTP_POST_VARS['name'], "text"),
GetSQLValueString($HTTP_POST_VARS['age'], "int"),
GetSQLValueString($HTTP_POST_VARS['personality'], "text"));

mysql_select_db($database_connPets, $connPets);
$Result1 = mysql_query($insertSQL, $connPets) or die(mysql_error());

$insertGoTo = "insert_yeah.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>

Sounds like in your table declaration you have set the breed column to not null. Somewhere in your data conversion you are passing a null value to breed which is what is generating the error. If you are passing the right values to breed (i.e. it is supposed to be text and you are passing text), then you might want to check your script without the CASE logic below and see if that works. I think that might be the part you may have to rewrite out of any of it.