|
|
 |
November 27th, 2007, 11:20 AM
|
#1
|
|
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 30
Posts: 247
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
[SOLVED] Column 'photo' cannot be null
Could anyone help me find a fix to this code error i keep getting in my PHP form code: "Column 'photo' cannot be null"
Its driving me mad, any help would be great!
The code below is off my submit form, it all works until i add the images upload section of the code and form,
Here is what i have manged so far:
Once the form is submit the data goes into the database & the image goes into the images file,
My problem is the name of the image is not going into the databse, really confusing me!
Code:
<?php require_once('Connections/dbsignup.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO customer (first_name, last_name, address, city, area, email, phone, user_name, password, work_location, agency_name, agency_number, skills, about_me, myspace_address, hotmail_yahoo_address, gender, age, height_one, height_two, build, eye_colour, hair_colour, desired_work, photo) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['last_name'], "text"),
GetSQLValueString($_POST['address'], "text"),
GetSQLValueString($_POST['city'], "text"),
GetSQLValueString($_POST['area'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['phone'], "int"),
GetSQLValueString($_POST['user_name'], "text"),
GetSQLValueString($_POST['password'], "text"),
GetSQLValueString($_POST['work_location'], "text"),
GetSQLValueString($_POST['agency_name'], "text"),
GetSQLValueString($_POST['agency_number'], "text"),
GetSQLValueString($_POST['skills'], "text"),
GetSQLValueString($_POST['about_me'], "text"),
GetSQLValueString($_POST['myspace_address'], "text"),
GetSQLValueString($_POST['hotmail_yahoo_address'], "text"),
GetSQLValueString($_POST['gender'], "text"),
GetSQLValueString($_POST['age'], "text"),
GetSQLValueString($_POST['height_one'], "int"),
GetSQLValueString($_POST['height_two'], "int"),
GetSQLValueString($_POST['build'], "text"),
GetSQLValueString($_POST['eye_colour'], "text"),
GetSQLValueString($_POST['hair_colour'], "text"),
GetSQLValueString($_POST['desired_work'], "text"),
GetSQLValueString($_POST['photo'], "text"));
mysql_select_db($database_dbsignup, $dbsignup);
$Result1 = mysql_query($insertSQL, $dbsignup) or die(mysql_error());
}
$con = mysql_connect("localhost","root","longstand1");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbsignup", $con);
if (!empty($_POST['button']))
{
$needStrip = get_magic_quotes_gpc();
$fields = array();
$fields['select'] = array('type' => 's',
'required' => true,
'column' => 'first_name'
);
$fields['select2'] = array('type' => 's',
'required' => true,
'column' => 'last_name'
);
$fields['select3'] = array('type' => 's',
'required' => true,
'column' => 'address'
);
$fields['select4'] = array('type' => 's',
'required' => true,
'column' => 'city'
);
$fields['select5'] = array('type' => 's',
'required' => true,
'column' => 'area'
);
$fields['select6'] = array('type' => 's',
'required' => true,
'column' => 'email'
);
$fields['select7'] = array('type' => 'n',
'required' => true,
'column' => 'phone'
);
$fields['select8'] = array('type' => 's',
'required' => true,
'column' => 'user_name'
);
$fields['select9'] = array('type' => 's',
'required' => true,
'column' => 'password'
);
$fields['select10'] = array('type' => 's',
'required' => true,
'column' => 'work_location'
);
$fields['select11'] = array('type' => 's',
'required' => true,
'column' => 'agency_name'
);
$fields['select12'] = array('type' => 'n',
'required' => true,
'column' => 'agency_number'
);
$fields['select13'] = array('type' => 's',
'required' => true,
'column' => 'skills'
);
$fields['select14'] = array('type' => 's',
'required' => true,
'column' => 'about_me'
);
$fields['select15'] = array('type' => 's',
'required' => true,
'column' => 'myspace_address'
);
$fields['select16'] = array('type' => 's',
'required' => true,
'column' => 'hotmail_yahoo_address'
);
$fields['select17'] = array('type' => 's',
'required' => true,
'column' => 'gender'
);
$fields['select18'] = array('type' => 'n',
'required' => true,
'column' => 'age'
);
$fields['select19'] = array('type' => 'n',
'required' => true,
'column' => 'height_one'
);
$fields['select20'] = array('type' => 'n',
'required' => true,
'column' => 'height_two'
);
$fields['select21'] = array('type' => 's',
'required' => true,
'column' => 'build'
);
$fields['select22'] = array('type' => 's',
'required' => true,
'column' => 'eye_colour'
);
$fields['select23'] = array('type' => 's',
'required' => true,
'column' => 'hair_colour'
);
$fields['select24'] = array('type' => 's',
'required' => true,
'column' => 'desired_work'
);
$errors = array();
$cols = '';
$vals = '';
foreach ($fields as $field => $dets)
{
$field = trim($field);
if ($dets['required'] && empty($_POST[$field])) {
$errors[] = $field . ' is a required field!';
continue;
}
if ($dets['type'] == 'n' && !is_numeric($_POST[$field])) {
$errors[] = $field . ' should be a number!';
continue;
}
if (empty($_POST['field']) || count($errors))
continue;
$_POST[$field] = $needStrip ? stripslashes($_POST[$field]) : $_POST[$field];
$_POST[$field] = mysql_real_escape_string($_POST[$field]);
if (!empty($cols)) {
$cols .= ', ';
$vals .= ', ';
}
$cols .= $dets['column'];
$vals .= $dets['type'] == 'n' && is_numeric($_POST[$field]) ? $_POST[$field] : "'{$_POST[$field]}'";
}
if (!count($errors) && !empty($cols) && !empty($vals)) {
$query = "INSERT INTO customer($cols) VALUES($vals)";
mysql_select_db($database_dbsignup, $dbsignup);
$result = mysql_query($query) or die(mysql_error());
$message = "Cool you have been inserted as " . mysql_insert_id(); // The insert ID
} else {
$message = '<strong>The following errors are screwing things up!</strong>
<ol>';
foreach ($errors as $err)
$message .= '<li>' . $err . '</li>';
$message .= '</ol>';
}
}
//This is the directory where images will be saved
$target = "images2/";
$target = $target . basename( $_FILES['photo']['name']);
//This gets all the other information from the form
$pic=($_FILES['photo']['name']);
// Connects to your Database
mysql_connect("localhost", "root", "longstand1") or die(mysql_error()) ;
mysql_select_db("dbsignup") or die(mysql_error()) ;
//Writes the information to the database
mysql_query("INSERT INTO `customer` VALUES ('$name')") ;
//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{
//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). "has been uploaded, and your information has been added to the directory";
}
else {
//Gives and error if its not
echo "Sorry Dear Customer There Was A Problem Uploading The Photo.";
}
?>
My html form:
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Signup Today</title>
<style type="text/css">
<!--
@import url("Drop down menu/Untitled-1.css");
@import url("Drop down menu/Untitled-4.css");
@import url("Drop down menu/Untitled-4.css");
body {
background-image: url(images/Only4Stars%20background.png);
}td img {display: block;}
.style1 {
font-family: Tahoma;
font-style: italic;
color: #FFFFFF;
}
.style2 {
font-family: Tahoma;
color: #FFFFFF;
}
.style3 {font-family: Tahoma; color: #FFFFFF; font-size: 12px; }td img {display: block;}
.style4 {font-family: Tahoma; color: #FFFFFF; font-weight: bold; }
td img {display: block;}td img {display: block;}
.style12 {
font-family: Tahoma;
font-size: 14px;
}
.style13 {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 14px;
color: #000000;
}td img {display: block;}
.style14 { color: #000000;
font-size: 12px;
font-family: Tahoma;
}
-->
</style>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script language="JavaScript1.2" type="text/javascript" src="Drop down menu/mm_css_menu.js"></script>
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body onload="MM_preloadImages('Drop down menu/Untitled-1_r1_c1_f2.gif','Drop down menu/Untitled-1_r2_c1_f2.gif','Drop down menu/Untitled-1_r3_c1_f2.gif','Drop down menu/Untitled-1_r4_c1_f2.gif','Drop down menu/Untitled-1_r4_c3_f2.gif','Drop down menu/Untitled-1_r5_c2_f2.gif','Drop down menu/Untitled-1_r6_c1_f2.gif','Drop down menu/Untitled-1_r7_c1_f2.gif','Drop down menu/Untitled-1_r9_c1_f2.gif','Drop down menu/Untitled-1_r10_c1_f2.gif','Drop down menu/Untitled-1_r11_c1_f2.gif','Drop down menu/Untitled-1_r13_c1_f2.gif')">
<table width="944" height="2005" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="228"><table width="943" height="228" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="419" bgcolor="#EBE9ED"><div align="center">
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','421','height','242','src','animation/Main Logo/Menu','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/Main Logo/Menu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="421" height="242">
<param name="movie" value="animation/Main Logo/Menu.swf" />
<param name="quality" value="high" />
<embed src="animation/Main Logo/Menu.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="421" height="242"></embed>
</object>
</noscript></div></td>
<td width="266" bgcolor="#99FF00"><div align="center">
<table width="250" height="228" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','251','height','237','src','animation/slide show 1/Movie1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/slide show 1/Movie1' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="251" height="237">
<param name="movie" value="animation/slide show 1/Movie1.swf" />
<param name="quality" value="high" />
<embed src="animation/slide show 1/Movie1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="251" height="237"></embed>
</object></noscript></td>
</tr>
</table>
</div></td>
<td width="248" bgcolor="#99FF00"><div align="center">
<table width="250" height="228" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','251','height','237','src','animation/slideshow 2/Movie1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','animation/slideshow 2/Movie1' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="251" height="237">
<param name="movie" value="animation/slideshow 2/Movie1.swf" />
<param name="quality" value="high" />
<embed src="animation/slideshow 2/Movie1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="251" height="237"></embed>
</object></noscript></td>
</tr>
</table>
</div></td>
<td width="10" bgcolor="#99FF00"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="94"><img name="" src="images/Photo Reel.png" width="945" height="125" alt="" /></td>
</tr>
<tr>
<td height="1651" valign="top"><table width="944" height="1664" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="189" height="1651" valign="top" bgcolor="#990000"><div id="FWTableContainer1603953034">
<table border="0" cellpadding="0" cellspacing="0" width="190">
<!-- fwtable fwsrc="Untitled" fwpage="Page 1" fwbase="Untitled-1.gif" fwstyle="Dreamweaver" fwdocid = "1603953034" fwnested="0" -->
<tr>
<td><img src="Drop down menu/spacer.gif" width="36" height="1" border="0" alt="" /></td>
<td><img src="Drop down menu/spacer.gif" width="81" height="1" border="0" alt="" /></td>
<td><img src="Drop down menu/spacer.gif" width="73" height="1" border="0" alt="" /></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="1" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="index.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r1_c1','','Drop down menu/Untitled-1_r1_c1_f2.gif',1);"><img name="Untitled1_r1_c1" src="Drop down menu/Untitled-1_r1_c1.gif" width="190" height="34" border="0" id="Untitled1_r1_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="about.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r2_c1','','Drop down menu/Untitled-1_r2_c1_f2.gif',1);"><img name="Untitled1_r2_c1" src="Drop down menu/Untitled-1_r2_c1.gif" width="190" height="34" border="0" id="Untitled1_r2_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r3_c1" src="Drop down menu/Untitled-1_r3_c1.gif" width="190" height="12" border="0" id="Untitled1_r3_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="12" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="2"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r4_c1" src="Drop down menu/Untitled-1_r4_c1.gif" width="36" height="22" border="0" id="Untitled1_r4_c1" alt="" /></a></td>
<td><a href="javascript:;" onmouseout="MM_menuStartTimeout(1000);" onmouseover="MM_menuShowMenu('MMMenuContainer1101183735_0', 'MMMenu1101183735_0',81,0,'Untitled1_r4_c2');"><img name="Untitled1_r4_c2" src="Drop down menu/Untitled-1_r4_c2.gif" width="81" height="13" border="0" id="Untitled1_r4_c2" alt="" /></a></td>
<td rowspan="2"><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r4_c3" src="Drop down menu/Untitled-1_r4_c3.gif" width="73" height="22" border="0" id="Untitled1_r4_c3" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="13" border="0" alt="" /></td>
</tr>
<tr>
<td><a href="javascript:;" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r3_c1','','Drop down menu/Untitled-1_r3_c1_f2.gif','Untitled1_r4_c1','','Drop down menu/Untitled-1_r4_c1_f2.gif','Untitled1_r4_c3','','Drop down menu/Untitled-1_r4_c3_f2.gif','Untitled1_r5_c2','','Drop down menu/Untitled-1_r5_c2_f2.gif',1);"><img name="Untitled1_r5_c2" src="Drop down menu/Untitled-1_r5_c2.gif" width="81" height="9" border="0" id="Untitled1_r5_c2" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="9" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="your_account.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r6_c1','','Drop down menu/Untitled-1_r6_c1_f2.gif',1);"><img name="Untitled1_r6_c1" src="Drop down menu/Untitled-1_r6_c1.gif" width="190" height="33" border="0" id="Untitled1_r6_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="33" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="2" colspan="3"><a href="signup.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r7_c1','','Drop down menu/Untitled-1_r7_c1_f2.gif',1);"><img name="Untitled1_r7_c1" src="Drop down menu/Untitled-1_r7_c1.gif" width="190" height="35" border="0" id="Untitled1_r7_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="1" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="search_memebers.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r9_c1','','Drop down menu/Untitled-1_r9_c1_f2.gif',1);"><img name="Untitled1_r9_c1" src="Drop down menu/Untitled-1_r9_c1.gif" width="190" height="34" border="0" id="Untitled1_r9_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="faq.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r10_c1','','Drop down menu/Untitled-1_r10_c1_f2.gif',1);"><img name="Untitled1_r10_c1" src="Drop down menu/Untitled-1_r10_c1.gif" width="190" height="33" border="0" id="Untitled1_r10_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="33" border="0" alt="" /></td>
</tr>
<tr>
<td rowspan="2" colspan="3"><a href="contact_us.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r11_c1','','Drop down menu/Untitled-1_r11_c1_f2.gif',1);"><img name="Untitled1_r11_c1" src="Drop down menu/Untitled-1_r11_c1.gif" width="190" height="35" border="0" id="Untitled1_r11_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="1" border="0" alt="" /></td>
</tr>
<tr>
<td><img src="Drop down menu/spacer.gif" width="1" height="34" border="0" alt="" /></td>
</tr>
<tr>
<td colspan="3"><a href="terms&conditions.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Untitled1_r13_c1','','Drop down menu/Untitled-1_r13_c1_f2.gif',1);"><img name="Untitled1_r13_c1" src="Drop down menu/Untitled-1_r13_c1.gif" width="190" height="33" border="0" id="Untitled1_r13_c1" alt="" /></a></td>
<td><img src="Drop down menu/spacer.gif" width="1" height="33" border="0" alt="" /></td>
</tr>
</table>
<div id="MMMenuContainer1101183735_0">
<div id="MMMenu1101183735_0" onmouseout="MM_menuStartTimeout(1000);" onmouseover="MM_menuResetTimeout();"> <a href="lookalikes.php" id="MMMenu1101183735_0_Item_0" class="MMMIFVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Look-A-Likes </a> <a href="models.php" id="MMMenu1101183735_0_Item_1" class="MMMIVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Models & Glamour </a> <a href="movie_tv.php" id="MMMenu1101183735_0_Item_2" class="MMMIVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Actors & TV Extras </a> <a href="singers.php" id="MMMenu1101183735_0_Item_3" class="MMMIVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Singers & Vocalists </a> <a href="thearter.php" id="MMMenu1101183735_0_Item_4" class="MMMIVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Stage Works Musicals </a> <a href="producers.php" id="MMMenu1101183735_0_Item_5" class="MMMIVStyleMMMenu1101183735_0" onmouseover="MM_menuOverMenuItem('MMMenu1101183735_0');"> Produces </a> </div>
</div>
</div>
<table border="0" cellpadding="0" cellspacing="0" width="188">
<!-- fwtable fwsrc="6.png" fwpage="Page 1" fwbase="Untitled-4.gif" fwstyle="Dreamweaver" fwdocid = "1208126192" fwnested="0" -->
<tr>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="15" height="1" border="0" id="undefined_2" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="163" height="1" border="0" id="undefined_2" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="10" height="1" border="0" id="undefined_2" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="1" height="1" border="0" id="undefined_2" /></td>
</tr>
<tr>
<td colspan="3"><a href="producers.php"><img name="Untitled4_r1_c1" src="Left side menu/Untitled-4_r1_c1.gif" width="188" height="618" border="0" id="Untitled4_r1_c1" alt="" /></a></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="1" height="618" border="0" id="undefined_2" /></td>
</tr>
<tr>
<td colspan="3"><img name="Untitled4_r2_c1" src="Left side menu/Untitled-4_r2_c1.gif" width="188" height="65" border="0" id="Untitled4_r2_c1" alt="" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="1" height="65" border="0" id="undefined_2" /></td>
</tr>
<tr>
<td rowspan="2"><img name="Untitled4_r3_c1" src="Left side menu/Untitled-4_r3_c1.gif" width="15" height="336" border="0" id="Untitled4_r3_c1" alt="" /></td>
<td><a href="http://www.ajl-online-services.com"><img name="Untitled4_r3_c2" src="Left side menu/Untitled-4_r3_c2.gif" width="163" height="300" border="0" id="Untitled4_r3_c2" alt="" /></a></td>
<td rowspan="2"><img name="Untitled4_r3_c3" src="Left side menu/Untitled-4_r3_c3.gif" width="10" height="336" border="0" id="Untitled4_r3_c3" alt="" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="1" height="300" border="0" id="undefined_2" /></td>
</tr>
<tr>
<td><img name="Untitled4_r4_c2" src="Left side menu/Untitled-4_r4_c2.gif" width="163" height="36" border="0" id="Untitled4_r4_c2" alt="" /></td>
<td><img src="Left side menu/spacer.gif" alt="" name="undefined_2" width="1" height="36" border="0" id="undefined_2" /></td>
</tr>
</table>
<p align="center" class="style4">AJL Online Services.com</p>
<p align="center" class="style4">Business Developmet At Its Best</p>
<table border="0" cellpadding="0" cellspacing="0" width="190">
<!-- fwtable fwsrc="Untitled" fwpage="Page 1" fwbase="Untitled-1.gif" fwstyle="Dreamweaver" fwdocid = "654341032" fwnested="0" -->
<tr>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="6" height="1" border="0" id="undefined_3" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="182" height="1" border="0" id="undefined_3" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="2" height="1" border="0" id="undefined_3" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="1" height="1" border="0" id="undefined_3" /></td>
</tr>
<tr>
<td colspan="3"><img name="Untitled1_r1_c1_2" src="webforums link/Untitled-1_r1_c1.gif" width="190" height="1" border="0" id="Untitled1_r1_c2" alt="" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="1" height="1" border="0" id="undefined_3" /></td>
</tr>
<tr>
<td rowspan="2"><img name="Untitled1_r2_c1_2" src="webforums link/Untitled-1_r2_c1.gif" width="6" height="63" border="0" id="Untitled1_r2_c2" alt="" /></td>
<td><a href="http://www.webforumz.com/"><img name="Untitled1_r2_c2" src="webforums link/Untitled-1_r2_c2.gif" width="182" height="62" border="0" id="Untitled1_r2_c3" alt="" /></a></td>
<td rowspan="2"><img name="Untitled1_r2_c3" src="webforums link/Untitled-1_r2_c3.gif" width="2" height="63" border="0" id="Untitled1_r2_c4" alt="" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="1" height="62" border="0" id="undefined_3" /></td>
</tr>
<tr>
<td><img name="Untitled1_r3_c2" src="webforums link/Untitled-1_r3_c2.gif" width="182" height="1" border="0" id="Untitled1_r3_c2" alt="" /></td>
<td><img src="webforums link/spacer.gif" alt="" name="undefined_3" width="1" height="1" border="0" id="undefined_3" /></td>
</tr>
</table>
<p align="center"><span class="style14">Inspiration For Web Development</span></p>
<p align="center"> </p>
<p align="center"> </p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="755" valign="top" bgcolor="#FFFFFF"><table width="755" height="102" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img name="" src="images/sign up page banner.jpg" width="755" height="110" alt="" /></td>
</tr>
</table>
<table width="754" height="1356" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="60" height="885"> </td>
<td width="641" valign="top"><table width="642" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="163"> </td>
</tr>
<tr>
<td height="42"><table width="641" height="37" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#990000"><div align="center" class="style2">Please Read Our New Members Registration Information Below</div></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td height="176" valign="top"><table width="643" height="178" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><h5 class="style13">To create your account with us please fill out the form below to start the sign up process. Once you have filled out all the madatory sectors of the sign up form, you will be automatically transffered to paypal to complete the registration process. </h5>
<h5 class="style13">Once your payment has gone through Paypal sucessfully you can login to your account using the username and password you chosen whilst filling out the form below. </h5>
<h5 class="style13">Once you login to your account you can click the profile button located on the left side of the site, this option will have automatically loaded your profile from our database. Feel free to edite your profile at any time, and remeber once payment is processed your photos are visible to our exstensive list of agents and producers, so please choose your photos & create your profile carefully for best results.</h5></td>
</tr>
</table></td>
</tr>
<tr>
<td height="58"><table width="642" height="38" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="28" bgcolor="#0066FF"><div align="center" class="style2">Below You Can Fill Out Your New Members Registration</div></td>
</tr>
</table></td>
</tr>
</table>
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">
<table width="0" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="41" height="34"> </td>
<td width="167"><div align="right" class="style12">First Name:</div></td>
<td width="390"><label>
<input type="text" name="first_name" id="first_name" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Last Name:</div></td>
<td><label>
<input type="text" name="last_name" id="last_name" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Address:</div></td>
<td><label>
<input type="text" name="address" id="address" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">City:</div></td>
<td><label>
<input type="text" name="city" id="city" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Location Area:</div></td>
<td><label>
<select name="area" id="area">
<option>Any</option>
<option>England-Bath Avon</option>
<option>England-Bedforshire</option>
<option>England-Berkshire</option>
<option>England-Brighton</option>
<option>England-Bristol</option>
<option>England-Buckinghamshire</option>
<option>England-Cambridgeshire</option>
<option>England-Channel Isles</option>
<option>England-Cheshire</option>
<option>England-Cornwall</option>
<option>England-County Durham</option>
<option>England-Cumbria</option>
<option>England-Derbyshire</option>
<option>England-Devon</option>
<option>England-Dorset</option>
<option>England-Essex</option>
<option>England-Gloucestershire</option>
<option>England-Hampshire</option>
<option>England-Herefordshire</option>
<option>England-Huntingdonshire</option>
<option>England-Isle Of White</option>
<option>England-Isle Of Sily</option>
<option>England-Kent</option>
<option>England-Lancashire</option>
<option>England-Leicestershire</option>
<option>England-Lincolnshire</option>
<option>England-London</option>
<option>England-Manchester</option>
<option>England-Merseyside</option>
<option>England-Middlesex</option>
<option>England-Norfolk</option>
<option>England-Northamptonshire</option>
<option>England-Northumberland</option>
<option>England-Nottinghamshire</option>
<option>England-Oxfordshire</option>
<option>England-Rutland</option>
<option>England-Shropshire</option>
<option>England-Somerset</option>
<option>England-Staffordshire</option>
<option>England-Suffolk</option>
<option>England-Surrey</option>
<option>England-Sussex</option>
<option>England-Tyne & Wear</option>
<option>England-Warwickshire</option>
<option>England-West midlands</option>
<option>England-Westmorland</option>
<option>England-Wiltshire</option>
<option>England-Worcestershire</option>
<option>England-Yorkshire</option>
<option>Isle Of Man</option>
<option>N Ireland-Artrim</option>
<option>N Ireland-Amagh</option>
<option>N Ireland-Bellfast</option>
<option>N Ireland-Down</option>
<option>N-Ireland-Femanagh</option>
<option>N-Ireland-Londondery</option>
<option>N-Ireland-Tyrone</option>
<option>Scotland-Aberdeenshire</option>
<option>Scotland-Angus</option>
<option>Scotland-Argylshire</option>
<option>Scotland-Ayrshire</option>
<option>Scotland-Banffshire</option>
<option>Scotland-Berwicshire</option>
<option>Scotland-Buteshire</option>
<option>Scotland-Caithness</option>
<option>Scotland-Clackmannanshire</option>
<option>Scotland-Dumfriesshire</option>
<option>Scotland-Dundee city</option>
<option>Scotland-Edinburgh</option>
<option>Scotland-Falkirk</option>
<option>Scotland-Fife</option>
<option>Scotland-Highland</option>
<option>Scotland-Inverness-shire</option>
<option>Scotland-Isle of Islay</option>
<option>Scotland-Isle of Lewis</option>
<option>Scotland-Isle of Skye</option>
<option>Scotland-Kincarineshire</option>
<option>Scotland-Kinross-shire</option>
<option>Scotland-Kirkcudbrightshire</option>
<option>Scotland-Lanarkshire</option>
<option>Scotland-Midlothian</option>
<option>Scotland-Morayshire</option>
<option>Scotland-Naimshire</option>
<option>Scotland-Orkney</option>
<option>Scotland-Peeblesshire</option>
<option>Scotland-Perthshire</option>
<option>Scotland-Renfrewshire</option>
<option>Scotland-Ross-shire</option>
<option>Scotland-Roxburghshire</option>
<option>Scotland-Selkirkshire</option>
<option>Scotland-Shetland</option>
<option>Scotland-Sterlingshire</option>
<option>Scotland-Sutherland</option>
<option>Scotland-West Lothiann</option>
<option>Scotland-Western Isles</option>
<option>Scotland-Wigtownshire</option>
<option>Wales-Anglesey</option>
<option>Wales-Brecknockshire</option>
<option>Wales-Caemarfonshire</option>
<option>Wales-Cardiff</option>
<option>Wales-Cardiganshire</option>
<option>Wales-Carmarthenshire</option>
<option>Wales-Ceredigion</option>
<option>Wales-Denbighshire</option>
<option>Wales-Flintshire</option>
<option>Wales-Glamorgan</option>
<option>Wales-Gwynedd</option>
<option>Wales-Merioneth</option>
<option>Wales-Monmouthshire</option>
<option>Wales-Montgomeryshire</option>
<option>Wales-Newport</option>
<option>Wales-Pembrokeshire</option>
<option>Wales-Radnorshire</option>
<option>Wales-Swansea</option>
</select>
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Email Address:</div></td>
<td><label>
<input type="text" name="email" id="email" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Phone Number:</div></td>
<td><label>
<input type="text" name="phone" id="phone" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Create Username:</div></td>
<td><label>
<input type="text" name="user_name" id="user_name" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Create Password:</div></td>
<td><label>
<input type="text" name="password" id="password" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right"><span class="style12">Prefered Work Location</span>:</div></td>
<td><label>
<input type="text" name="work_location" id="work_location" />
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Previous Agency Name:</div></td>
<td><label>
<input type="text" name="agency_name" id="agency_name" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Previous Agency Number:</div></td>
<td><label>
<input type="text" name="agency_number" id="agency_number" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Your Talent::</div></td>
<td><label>
<input type="text" name="skills" id="skills" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Tell Us About You:</div></td>
<td><label>
<textarea name="about_me" id="about_me" cols="45" rows="5"></textarea>
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Myspace Address:</div></td>
<td><label>
<input type="text" name="myspace_address" id="myspace_address" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Hotmail\Yahoo Address:</div></td>
<td><label>
<input type="text" name="hotmail_yahoo_address" id="hotmail_yahoo_address" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Male Or Female Gender:</div></td>
<td><label>
<input type="text" name="gender" id="gender" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">How Old Are You:</div></td>
<td><label>
<select name="age" id="age">
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
<option>32</option>
<option>33</option>
<option>34</option>
<option>35</option>
<option>36</option>
<option>37</option>
<option>38</option>
<option>39</option>
<option>40</option>
<option>41</option>
<option>42</option>
<option>43</option>
<option>44</option>
<option>45</option>
<option>46</option>
<option>47</option>
<option>48</option>
<option>49</option>
<option>50</option>
<option>51</option>
<option>52</option>
<option>53</option>
<option>54</option>
<option>55</option>
<option>56</option>
<option>57</option>
<option>58</option>
<option>59</option>
<option>60</option>
<option>61</option>
<option>62</option>
<option>63</option>
<option>64</option>
<option>65</option>
<option>66</option>
<option>67</option>
<option>68</option>
<option>69</option>
<option>70</option>
<option>71</option>
<option>72</option>
<option>73</option>
<option>74</option>
<option>75</option>
<option>76</option>
<option>77</option>
<option>78</option>
<option>79</option>
<option>80</option>
<option>81</option>
<option>82</option>
<option>83</option>
<option>84</option>
<option>85</option>
<option>86</option>
<option>87</option>
<option>88</option>
<option>89</option>
<option>90</option>
<option>91</option>
</select>
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Height:</div></td>
<td><label>
<select name="height_one" id="height_one">
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
</select>
<span class="style12">To</span>
<select name="height_two" id="height_two">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
</select>
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Build:</div></td>
<td><label>
<input type="text" name="build" id="build" />
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Eye Colour:</div></td>
<td><label>
<input type="text" name="eye_colour" id="eye_colour" />
</label></td>
</tr>
<tr>
<td height="37"> </td>
<td><div align="right" class="style12">Hair Colour:</div></td>
<td><label>
<select name="hair_colour" id="hair_colour">
<option>Black</option>
<option>Brown</option>
<option>Blonde</option>
<option>Red</option>
<option>Auburn</option>
<option>Other</option>
</select>
</label></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Prefered Work Type:</div></td>
<td><label>
<select name="desired_work" id="desired_work">
<option>Look-A-Likes</option>
<option>Models & Glamour</option>
<option>Actors & TV Extras</option>
<option>Singers & Vocalists</option>
<option>Theatre & Musicals</option>
<option>Producers&Aegents</option>
</select>
</label></td>
</tr>
<tr>
<td height="35"> </td>
<td><div align="right" class="style12">Upload Image 1:</div></td>
<td><label>
<input type="file" name="photo"><br> </label></td>
</tr>
<tr>
<td height="35"> </td>
<td> </td>
<td><div align="left">
<table width="115" height="91" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/awaiting image.png" width="105" height="108" /></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Upload Image 2:</div></td>
<td><label></label></td>
</tr>
<tr>
<td height="36"> </td>
<td> </td>
<td><table width="115" height="91" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/awaiting image.png" width="105" height="108" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="36"> </td>
<td><div align="right" class="style12">Upload Image 3:</div></td>
<td><label></label></td>
</tr>
<tr>
<td height="37"> </td>
<td> </td>
<td><table width="115" height="91" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/awaiting image.png" width="105" height="108" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="34"> </td>
<td><div align="right" class="style12">Upload Image 4:</div></td>
<td><label></label></td>
</tr>
<tr>
<td height="42"> </td>
<td> </td>
<td><table width="115" height="91" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img name="" src="images/awaiting image.png" width="105" height="108" alt="" /></td>
</tr>
</table>
<p><span class="style12">Please Click Here To Submit Your New Account: </span>
<label></label>
<label>
<input type="submit" value="Add">
</label>
</p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p align="center">
<label></label>
</p></td>
<td width="53"> </td>
</tr>
</table>
<p align="left"> </p>
<p align="center" class="style1">AJL Online Services.com</p>
<p align="center" class="style2">Business Developmet At Its Best</p>
<p></p></td>
</tr>
</table></td>
</tr>
</table>
<p align="center" class="style3">©Copyright 2006 All Rights Reserved | Only4Stars | Actors\Models & Singers Casting Agency | Supplying New Hope To Upcomming Stars</p>
<p align="center" class="style3">Agents & Producers Phone Hotline 07982479130 <br />
</p>
</body>
</html>
My database:
CREATE DATABASE IF NOT EXISTS dbsignup;
USE dbsignup;
CREATE TABLE `customer` (`customer_id` INT( 3 ) NOT NULL
AUTO_INCREMENT,
`first_name` VARCHAR(30) NOT NULL ,
`last_name` VARCHAR(30) NOT NULL ,
`address` VARCHAR(70) NOT NULL ,
`city` VARCHAR(40) NOT NULL ,
`area` VARCHAR(50) NOT NULL ,
`email` VARCHAR(70) NOT NULL ,
`phone` int(20) NOT NULL ,
`user_name` VARCHAR(30) NOT NULL ,
`password` VARCHAR(30) NOT NULL ,
`work_location` VARCHAR(60) NOT NULL ,
`agency_name` VARCHAR(70) NOT NULL ,
`agency_number` VARCHAR(30) NOT NULL ,
`skills` VARCHAR(500) NOT NULL ,
`about_me` VARCHAR(500) NOT NULL ,
`myspace_address` VARCHAR(50) NOT NULL ,
`hotmail_yahoo_address` VARCHAR(50) NOT NULL ,
`gender` VARCHAR(10) NOT NULL ,
`age` VARCHAR(3) NOT NULL ,
`height_one` int(20) NOT NULL ,
`height_two` int(20) NOT NULL ,
`build` VARCHAR(20) NOT NULL ,
`eye_colour` VARCHAR(20) NOT NULL ,
`hair_colour` VARCHAR(30) NOT NULL ,
`desired_work` VARCHAR(100) NOT NULL ,
`photo` VARCHAR(10) NOT NULL ,
`photo2` VARCHAR(10) NOT NULL ,
`photo3` VARCHAR(10) NOT NULL ,
`photo4` VARCHAR(10) NOT NULL , UNIQUE ( `customer_id` ) );
Its a lot of code, but only one problem the name of the image uploaded from the form does not go into the database (Thats it0 everythink else works 
Last edited by longstand; November 27th, 2007 at 11:34 AM..
Reason: Feel like i need to explain the problem better
|
|
|
|
November 27th, 2007, 01:22 PM
|
#2
|
|
Reputable Member
Join Date: Apr 2007
Location: Scotland
Age: 19
Posts: 236
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
Re: Column 'photo' cannot be null
I think your problem is here
Code:
//This gets all the other information from the form
$pic=($_FILES['photo']['name']);
// Connects to your Database
mysql_connect("localhost", "root", "longstand1") or die(mysql_error()) ;
mysql_select_db("dbsignup") or die(mysql_error()) ;
//Writes the information to the database
mysql_query("INSERT INTO `customer` VALUES ('$name')") ;
You have the name of the image stored as $pic.
You, aren't entering $pic into the database anywhere as far as I can see.
You are however trying to insert $name, I can't even figure out what that is. So I assume that $name should be $pic. Try changing name to pic around and see if it works.
e.g.
Code:
mysql_query("INSERT INTO customer('photo') VALUES ('$pic')");
|
|
|
|
|
November 27th, 2007, 02:17 PM
|
#3
|
|
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 30
Posts: 247
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
Re: Column 'photo' cannot be null
Thanks mate al give that a try, hope it works he he
Take Care m8t |
|
|
|
|
November 28th, 2007, 02:39 AM
|
#4
|
|
Highly Reputable Member
Join Date: Apr 2007
Location: Willich, Germany
Age: 22
Posts: 592
Thanks: 0
Thanked 0 Times in 0 Posts
|
Re: Column 'photo' cannot be null
Your other problem could be here:
Code:
GetSQLValueString($_POST['photo'], "text"));
If you have a form input with type="file" then its value does NOT get stored in $_POST['photo']....
I made a test page:
Code:
<html>
<body>
<?php
var_dump($_POST);
echo('<br>');
var_dump($_REQUEST);
echo('<br>');
echo('photo: '.$_POST['photo']);
echo('<br>');
?>
<form>
<input type="file" name="photo">
<input type="submit" value="post">
</form>
</body>
</html>
The output when you post the form looks like so:
Quote:
array(0) { }
array(1) { ["photo"]=> string(8) "logo.png" }
photo:
|
Hope that helps.... |
|
|
|
|
November 28th, 2007, 07:08 AM
|
#5
|
|
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 30
Posts: 247
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
Re: Column 'photo' cannot be null
Cheers for the help & gonna give it a try!!! Hope i finaly crack this today!!
I will have to really use my undersized  php brain & see what i can do
Cheers, |
|
|
|
|
November 30th, 2007, 05:18 PM
|
#6
|
|
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 30
Posts: 247
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
Re: Column 'photo' cannot be null
Ok i have finally sorted me image upload code, i decided to use dreamweavers built in functionality for my signup form by creating records in the server behaviours panel, i have not validated them yet but it still all works just fine without, the image upload code section is commented for easy viewing!!!
I have also spent some time creating a good sql database to go with it, many people are fooled by what a good database looks like, the easy way to answer that is: "if it has no look up tables" its propebly going to clog up\slow down & proov to be utter crap, i have used dynamic links to list the data from the list menus using dreamweaver..
Below is the entire html signup form with the PHP code & all the server behavour's:
<?php require_once('Connections/dbsignup.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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;
}
}
// *** Redirect if username exists
$MM_flag="MM_insert";
if (isset($_POST[$MM_flag])) {
$MM_dupKeyRedirect="user_exists.php";
$loginUsername = $_POST['candidateusername'];
$LoginRS__query = sprintf("SELECT candidateusername FROM tbl_candidate WHERE candidateusername=%s", GetSQLValueString($loginUsername, "text"));
mysql_select_db($database_dbsignup, $dbsignup);
$LoginRS=mysql_query($LoginRS__query, $dbsignup) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
//if there is a row in the database, the username was found - can not add the requested username
if($loginFoundUser){
$MM_qsChar = "?";
//append the username to the redirect page
if (substr_count($MM_dupKeyRedirect,"?") >=1) $MM_qsChar = "&";
$MM_dupKeyRedirect = $MM_dupKeyRedirect . $MM_qsChar ."requsername=".$loginUsername;
header ("Location: $MM_dupKeyRedirect");
exit;
}
}
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "frm_insert")) {
// define constant for upload folder
define ('UPLOAD_DIR','D:/webserver/Apache2/htdocs/uploads/');
// get the file extension
function findext ($filename) {
$filename = strtolower($filename);
$exts = split("[/\\.]", $filename);
$n = count($exts)-1;
$exts = $exts[$n];
return $exts;
}
// apply function to the variable
$ext = findext($_FILES['candidatephoto']['name']);
//rename file using username
$file = $_POST['candidateusername'].'.'.$ext;
move_uploaded_file($_FILES['candidatephoto']['tmp_name'], UPLOAD_DIR.$file);
$insertSQL = sprintf("INSERT INTO tbl_candidate (candidatefname, candidatelname, candidateadress, candidatecity, candidateemail, candidatephone, candidateusername, candidatepassword, candidateworkloc, candidateprevagency, candidateagentnumb, candidatetallent, candidateabout, candidatemyspace, candidatehotmail, candidatephoto, candidatearea, candidateage, candidateheight, candidatefoot, candidatebuild, candidatehair, candidateeye, candidatework, candidategender) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['candidatefname'], "text"),
GetSQLValueString($_POST['candidatelname'], "text"),
GetSQLValueString($_POST['candidateadress'], "text"),
GetSQLValueString($_POST['candidatecity'], "text"),
GetSQLValueString($_POST['candidateemail'], "text"),
GetSQLValueString($_POST['candidatephone'], "text"),
GetSQLValueString($_POST['candidateusername'], "text"),
GetSQLValueString($_POST['candidatepassword'], "text"),
GetSQLValueString($_POST['candidateworkloc'], "text"),
GetSQLValueString($_POST['candidateprevagency'], "text"),
GetSQLValueString($_POST['candidateagentnumb'], "text"),
GetSQLValueString($_POST['candidatetallent'], "text"),
GetSQLValueString($_POST['candidateabout'], "text"),
GetSQLValueString($_POST['candidatemyspace'], "text"),
GetSQLValueString($_POST['candidatehotmail'], "text"),
GetSQLValueString($file, "text"),
GetSQLValueString($_POST['candidatearea'], "int"),
GetSQLValueString($_POST['candidateage'], "int"),
GetSQLValueString($_POST['candidateheight'], "int"),
GetSQLValueString($_POST['candidatefoot'], "int"),
GetSQLValueString($_POST['candidatebuild'], "int"),
GetSQLValueString($_POST['candidatehair'], "int"),
GetSQLValueString($_POST['candidateeye'], "int"),
GetSQLValueString($_POST['candidatework'], "int"),
GetSQLValueString($_POST['candidategender'], "text"));
mysql_select_db($database_dbsignup, $dbsignup);
$Result1 = mysql_query($insertSQL, $dbsignup) or die(mysql_error());
$insertGoTo = "signup_successfull.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsArea = "SELECT * FROM tbl_area ORDER BY areaname ASC";
$rsArea = mysql_query($query_rsArea, $dbsignup) or die(mysql_error());
$row_rsArea = mysql_fetch_assoc($rsArea);
$totalRows_rsArea = mysql_num_rows($rsArea);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsAge = "SELECT * FROM tbl_age ORDER BY agename ASC";
$rsAge = mysql_query($query_rsAge, $dbsignup) or die(mysql_error());
$row_rsAge = mysql_fetch_assoc($rsAge);
$totalRows_rsAge = mysql_num_rows($rsAge);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsHeight = "SELECT * FROM tbl_height ORDER BY heightname ASC";
$rsHeight = mysql_query($query_rsHeight, $dbsignup) or die(mysql_error());
$row_rsHeight = mysql_fetch_assoc($rsHeight);
$totalRows_rsHeight = mysql_num_rows($rsHeight);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsFoot = "SELECT * FROM tbl_foot ORDER BY footname ASC";
$rsFoot = mysql_query($query_rsFoot, $dbsignup) or die(mysql_error());
$row_rsFoot = mysql_fetch_assoc($rsFoot);
$totalRows_rsFoot = mysql_num_rows($rsFoot);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsBuild = "SELECT * FROM tbl_build ORDER BY buildname ASC";
$rsBuild = mysql_query($query_rsBuild, $dbsignup) or die(mysql_error());
$row_rsBuild = mysql_fetch_assoc($rsBuild);
$totalRows_rsBuild = mysql_num_rows($rsBuild);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsHair = "SELECT * FROM tbl_hair ORDER BY hairname ASC";
$rsHair = mysql_query($query_rsHair, $dbsignup) or die(mysql_error());
$row_rsHair = mysql_fetch_assoc($rsHair);
$totalRows_rsHair = mysql_num_rows($rsHair);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsEye = "SELECT * FROM tbl_eye ORDER BY eyename ASC";
$rsEye = mysql_query($query_rsEye, $dbsignup) or die(mysql_error());
$row_rsEye = mysql_fetch_assoc($rsEye);
$totalRows_rsEye = mysql_num_rows($rsEye);
mysql_select_db($database_dbsignup, $dbsignup);
$query_rsWork = "SELECT * FROM tbl_work ORDER BY workname ASC";
$rsWork = mysql_query($query_rsWork, $dbsignup) or die(mysql_error());
$row_rsWork = mysql_fetch_assoc($rsWork);
$totalRows_rsWork = mysql_num_rows($rsWork);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="style/screen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" name="frm_insert" id="frm_insert">
<table border="0" cellpadding="0" cellspacing="0" id="tbl_insert">
<tr valign="baseline">
<td nowrap="nowrap" align="right">First name:</td>
<td><input type="text" name="candidatefname" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Last name:</td>
<td><input type="text" name="candidatelname" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top">Address:</td>
<td><textarea name="candidateadress" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Town/City:</td>
<td><input type="text" name="candidatecity" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Area:</td>
<td>
<select name="candidatearea">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsArea['areaid']; ?>" ><?php echo $row_rsArea['areaname']; ?></option>
<?php } while ($row_rsArea = mysql_fetch_assoc($rsArea)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Email address:</td>
<td><input type="text" name="candidateemail" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Telephone number:</td>
<td><input type="text" name="candidatephone" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Choose username:</td>
<td><input type="text" name="candidateusername" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Choose password:</td>
<td><input type="password" name="candidatepassword" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Desired work location:</td>
<td><input type="text" name="candidateworkloc" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Previous agency name:</td>
<td><input type="text" name="candidateprevagency" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Agency number:</td>
<td><input type="text" name="candidateagentnumb" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Your tallent:</td>
<td><input type="text" name="candidatetallent" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top">About yourself:</td>
<td><textarea name="candidateabout" cols="50" rows="5"></textarea>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Myspace address:</td>
<td><input type="text" name="candidatemyspace" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Hotmail address:</td>
<td><input type="text" name="candidatehotmail" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Gender:</td>
<td><select name="candidategender">
<option value="">Select one...</option>
<option value="m">Male</option>
<option value="f">Female</option>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Age:</td>
<td>
<select name="candidateage">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsAge['ageid']; ?>" ><?php echo $row_rsAge['agename']; ?></option>
<?php } while ($row_rsAge = mysql_fetch_assoc($rsAge)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Height:</td>
<td>
<select name="candidateheight">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsHeight['heightid']; ?>" ><?php echo $row_rsHeight['heightname']; ?></option>
<?php } while ($row_rsHeight = mysql_fetch_assoc($rsHeight)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Ft:</td>
<td>
<select name="candidatefoot">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsFoot['footid']; ?>" ><?php echo $row_rsFoot['footname']; ?></option>
<?php } while ($row_rsFoot = mysql_fetch_assoc($rsFoot)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Build:</td>
<td>
<select name="candidatebuild">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsBuild['buildid']; ?>" ><?php echo $row_rsBuild['buildname']; ?></option>
<?php } while ($row_rsBuild = mysql_fetch_assoc($rsBuild)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Eye:</td>
<td>
<select name="candidateeye">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsEye['eyeid']; ?>" ><?php echo $row_rsEye['eyename']; ?></option>
<?php } while ($row_rsEye = mysql_fetch_assoc($rsEye)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Hair:</td>
<td>
<select name="candidatehair">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsHair['hairid']; ?>" ><?php echo $row_rsHair['hairname']; ?></option>
<?php } while ($row_rsHair = mysql_fetch_assoc($rsHair)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Desired work:</td>
<td>
<select name="candidatework">
<option value="">Select one...</option>
<?php do { ?>
<option value="<?php echo $row_rsWork['workid']; ?>" ><?php echo $row_rsWork['workname']; ?></option>
<?php } while ($row_rsWork = mysql_fetch_assoc($rsWork)); ?>
</select>
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Upload a photo:</td>
<td><input name="candidatephoto" type="file" id="candidatephoto" size="40" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Insert record" /></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="frm_insert" />
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($rsArea);
mysql_free_result($rsAge);
mysql_free_result($rsHeight);
mysql_free_result($rsFoot);
mysql_free_result($rsBuild);
mysql_free_result($rsHair);
mysql_free_result($rsEye);
mysql_free_result($rsWork);
?>
Below is the PHP code isuesed to solve my annoying image upload issue,
Code:
//This is the directory where images will be saved
$target = "images2/";
$target = $target . basename( $_FILES['photo']['name']);
//This gets all the other information from the form
$pic=($_FILES['photo']['name']);
// Connects to your Database
mysql_connect("localhost", "root", "longstand1") or die(mysql_error()) ;
mysql_select_db("dbsignup") or die(mysql_error()) ;
//Writes the information to the database
mysql_query("INSERT INTO `customer` VALUES ('$name')") ;
//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{
//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). "has been uploaded, and your information has been added to the directory";
}
else {
//Gives and error if its not
echo "Sorry Dear Customer There Was A Problem Uploading The Photo.";
}
Below is a example of a crap amature table:
CREATE DATABASE IF NOT EXISTS dbsignup;
USE dbsignup;
CREATE TABLE `customer` (`customer_id` INT( 3 ) NOT NULL
AUTO_INCREMENT,
`first_name` VARCHAR(30) NOT NULL ,
`last_name` VARCHAR(30) NOT NULL ,
`address` VARCHAR(70) NOT NULL ,
`photo` VARCHAR(10) NOT NULL ,
UNIQUE ( `customer_id` ) ); Load of rubbish
Here is a proffesional looking table uasing Mysql Administrator:
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.41-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema dbsignup
--
CREATE DATABASE IF NOT EXISTS dbsignup;
USE dbsignup;
--
-- Definition of table `tbl_age`
--
DROP TABLE IF EXISTS `tbl_age`;
CREATE TABLE `tbl_age` (
`ageid` tinyint(3) unsigned NOT NULL auto_increment,
`agename` varchar(10) NOT NULL,
PRIMARY KEY (`ageid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_age`
--
/*!40000 ALTER TABLE `tbl_age` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_age` ENABLE KEYS */;
--
-- Definition of table `tbl_area`
--
DROP TABLE IF EXISTS `tbl_area`;
CREATE TABLE `tbl_area` (
`areaid` int(10) unsigned NOT NULL auto_increment,
`areaname` varchar(45) NOT NULL,
PRIMARY KEY (`areaid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_area`
--
/*!40000 ALTER TABLE `tbl_area` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_area` ENABLE KEYS */;
--
-- Definition of table `tbl_build`
--
DROP TABLE IF EXISTS `tbl_build`;
CREATE TABLE `tbl_build` (
`buildid` tinyint(3) unsigned NOT NULL auto_increment,
`buildname` varchar(20) NOT NULL,
PRIMARY KEY (`buildid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_build`
--
/*!40000 ALTER TABLE `tbl_build` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_build` ENABLE KEYS */;
--
-- Definition of table `tbl_candidate`
--
DROP TABLE IF EXISTS `tbl_candidate`;
CREATE TABLE `tbl_candidate` (
`candidateid` int(10) unsigned NOT NULL auto_increment,
`candidatefname` varchar(30) NOT NULL,
`candidatelname` varchar(45) NOT NULL,
`candidateadress` varchar(255) NOT NULL,
`candidatecity` varchar(45) NOT NULL,
`candidateemail` varchar(150) NOT NULL,
`candidatephone` varchar(15) NOT NULL,
`candidateusername` varchar(15) NOT NULL,
`candidatepassword` varchar(20) NOT NULL,
`candidateworkloc` varchar(45) NOT NULL,
`candidateprevagency` varchar(45) NOT NULL,
`candidateagentnumb` varchar(45) NOT NULL,
`candidatetallent` varchar(255) NOT NULL,
`candidateabout` varchar(255) NOT NULL,
`candidatemyspace` varchar(180) NOT NULL,
`candidatehotmail` varchar(100) NOT NULL,
`candidatephoto` varchar(45) NOT NULL,
`candidatearea` int(10) unsigned NOT NULL,
`candidateage` tinyint(3) unsigned NOT NULL,
`candidateheight` tinyint(3) unsigned NOT NULL,
`candidatefoot` tinyint(3) unsigned NOT NULL,
`candidatebuild` tinyint(3) unsigned NOT NULL,
`candidatehair` tinyint(3) unsigned NOT NULL,
`candidateeye` tinyint(3) unsigned NOT NULL,
`candidatework` tinyint(3) unsigned NOT NULL,
`candidategender` enum('m','f') NOT NULL,
PRIMARY KEY (`candidateid`),
KEY `FK_tbl_candidate_1` (`candidatearea`),
KEY `FK_tbl_candidate_2` (`candidateage`),
KEY `FK_tbl_candidate_3` (`candidateheight`),
KEY `FK_tbl_candidate_4` (`candidatefoot`),
KEY `FK_tbl_candidate_5` (`candidatebuild`),
KEY `FK_tbl_candidate_6` (`candidatehair`),
KEY `FK_tbl_candidate_7` (`candidateeye`),
KEY `FK_tbl_candidate_8` (`candidatework`),
CONSTRAINT `FK_tbl_candidate_1` FOREIGN KEY (`candidatearea`) REFERENCES `tbl_area` (`areaid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_2` FOREIGN KEY (`candidateage`) REFERENCES `tbl_age` (`ageid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_3` FOREIGN KEY (`candidateheight`) REFERENCES `tbl_height` (`heightid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_4` FOREIGN KEY (`candidatefoot`) REFERENCES `tbl_foot` (`footid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_5` FOREIGN KEY (`candidatebuild`) REFERENCES `tbl_build` (`buildid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_6` FOREIGN KEY (`candidatehair`) REFERENCES `tbl_hair` (`hairid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_7` FOREIGN KEY (`candidateeye`) REFERENCES `tbl_eye` (`eyeid`) ON UPDATE CASCADE,
CONSTRAINT `FK_tbl_candidate_8` FOREIGN KEY (`candidatework`) REFERENCES `tbl_work` (`workid`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_candidate`
--
/*!40000 ALTER TABLE `tbl_candidate` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_candidate` ENABLE KEYS */;
--
-- Definition of table `tbl_eye`
--
DROP TABLE IF EXISTS `tbl_eye`;
CREATE TABLE `tbl_eye` (
`eyeid` tinyint(3) unsigned NOT NULL auto_increment,
`eyename` varchar(15) NOT NULL,
PRIMARY KEY (`eyeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_eye`
--
/*!40000 ALTER TABLE `tbl_eye` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_eye` ENABLE KEYS */;
--
-- Definition of table `tbl_foot`
--
DROP TABLE IF EXISTS `tbl_foot`;
CREATE TABLE `tbl_foot` (
`footid` tinyint(3) unsigned NOT NULL auto_increment,
`footname` varchar(5) NOT NULL,
PRIMARY KEY (`footid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_foot`
--
/*!40000 ALTER TABLE `tbl_foot` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_foot` ENABLE KEYS */;
--
-- Definition of table `tbl_hair`
--
DROP TABLE IF EXISTS `tbl_hair`;
CREATE TABLE `tbl_hair` (
`hairid` tinyint(3) unsigned NOT NULL auto_increment,
`hairname` varchar(15) NOT NULL,
PRIMARY KEY (`hairid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_hair`
--
/*!40000 ALTER TABLE `tbl_hair` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_hair` ENABLE KEYS */;
--
-- Definition of table `tbl_height`
--
DROP TABLE IF EXISTS `tbl_height`;
CREATE TABLE `tbl_height` (
`heightid` tinyint(3) unsigned NOT NULL auto_increment,
`heightname` varchar(10) NOT NULL,
PRIMARY KEY (`heightid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_height`
--
/*!40000 ALTER TABLE `tbl_height` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_height` ENABLE KEYS */;
--
-- Definition of table `tbl_work`
--
DROP TABLE IF EXISTS `tbl_work`;
CREATE TABLE `tbl_work` (
`workid` tinyint(3) unsigned NOT NULL auto_increment,
`workname` varchar(35) NOT NULL,
PRIMARY KEY (`workid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_work`
--
/*!40000 ALTER TABLE `tbl_work` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_work` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
The subject above really bugged me for about a week, i hope this helps any newbies get to grips with submit forms\server behaviours\bindings & file upload using dreamweavers in built functionality & PHP code.  |
|
|
|
|
December 1st, 2007, 09:34 AM
|
#7
|
|
Highly Reputable Member
Join Date: Apr 2007
Location: Willich, Germany
Age: 22
Posts: 592
Thanks: 0
Thanked 0 Times in 0 Posts
|
Re: Column 'photo' cannot be null
Good 4 U longstand!!!
TX for posting your solution!
|
|
|
|
|
December 1st, 2007, 11:08 AM
|
#8
|
|
Reputable Member
Join Date: Oct 2007
Location: Liverpool UK
Age: 30
Posts: 247
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Altering Power: 0
|
Re: Column 'photo' cannot be null
No probs, thanks very much for the comment!! 
Take Care All. |
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
Submit Your Article
Announcements
Contact
