Code Comments

Programming Forum and web based access to our favorite programming groups.
For Programmers: Free Programming Magazines | New: Database administration forum
Registration is free! Edit your profileCalendarFind other membersFrequently Asked QuestionsSearch -> 
Code Comments > PHP > PHP SQL >

help with this form


Post New Thread











Thread
Author
help with this form
i have a site whereby you fill in a php form and it sends an auto
responder. at another address i can view what has been put in the
form because its stored on the internet. i have now made the form
alot bigger and now i have run into trouble. here is the code: (the
form itself is called getstartedform.php

--------
<script LANGUAGE="JavaScript">
<!--
function redirect () {
setTimeout("go_now()",4000); }
function go_now ()   { window.location.href =
"getstartedform.php"; }
//-->
</SCRIPT>
</head>

<?php

//extract(_REQUEST);
if (_POST['submit'])
{
user='';//these fields are filled but i took it out for
posting this up
host='';
password='';
database="";
 connection=mysql_connect(host,user,p
assword)
or die ("could not connect to server");
 db=mysql_select_db(database,connectio
n);
sql = "insert into getstarted(name, email,
contactAddress, mobile, workHomeTel, contactPostcode,
projectPostcode, projectGarden, projectLoft, projectRefit,
projectXtension, shopUse, officeUse, homeUse, otherUses, engineer,
partywall, projectManager, design, lifestyle, strucural, planning,
buildingRegs, otherHelp, wheelchair, partialEyesight, terraced,
familyChildren, semiDetached, aged, allergy, detached, other,
otherNeeds, needsRefurbishment, needsExtraSpace, needsExtraLight,
contemporaryDesignstyle, traditionalDesignstyle, mixedDesignstyle,
progTimeComplete1month, progTimeComplete6months,
progTimeComplete9months, budgetCost3kto14k, budgetCost15kto45k,
budgetCostOver45k, importantThanCostYes, importantThanCostNo,
importantThanCostMaybe, importantThanProgYes, importantThanProgNo,
importantThanProgMaybe, importantThanDesYes, importantThanDesNo,
importantThanDesMaybe, build2rent, build2sell, build2keep,
otherBuildingNotes) values
 ('{_POST['name']}','{_POST['email']}',
'{_POST['contact_address']}','{_PO
 ST['mobile']}','{_POST['workhome_tel']}
','{_POST['contact_postcode']}','{
 _POST['project_postcode']}','{_POST['pr
oject_garden']}','{_POST['project_l
oft']}','{_POST['project_r
 efit']}','{_POST['project_extension']}'
,'{_POST['use_shop']}','{_POST['us
 e_office']}','{_POST['use_home']}','{_
POST['use_other']}','{_POST['engine
 er']}','{_POST['partywall']}','{_POST[
'projectmanager']}','{_POST['design
']}','{_POST['lifestyle']}
 ','{_POST['strucural']}','{_POST['plan
ning']}','{_POST['buildingregs']}',
 '{_POST['otherhelp']}','{_POST['wheelc
hair']}','{_POST['partialeyesight']
 }','{_POST['terraced']}','{_POST['fami
lychildren']}','{_POST['semidetache
d']}','{_POST['aged']}','{
 _POST['allergy']}','{_POST['detached']
}','{_POST['other']}','{_POST['oth
 erneeds']}','{_POST['needrefurb']}','{
_POST['need_xspace']}','{_POST['nee
 d_xlight']}','{_POST['designstyle_conte
mporary']}','{_POST['designstyle_tr
aditional']}','{_POST['des
 ignstyle_mixed']}','{_POST['programtime
completion_1m']}','{_POST['programt
 imecompletion_6m']}','{_POST['programti
mecompletion_9m']}','{_POST['budget
 cost_3kto14k']}','{_POST['budgetcost_15
kto45k']}','{_POST['budgetcost_over
45k']}','{_POST['important
 thancost_yes']}','{_POST['importantthan
cost_no']}','{_POST['importantthanc
 ost_maybe']}','{_POST['importantthanpro
gram_yes']}','{_POST['importantthan
 program_no']}','{_POST['importantthanpr
ogram_maybe']}','{_POST['importantt
handesign_yes']}','{_POST[
 'importantthandesign_no']}','{_POST['im
portantthandesign_maybe']}','{_POST
 ['whybuild_rent']}','{_POST['whybuild_s
ell']}','{_POST['whybuild_keep']}',
'{_POST['otherbuildingnotes']}')";

result = mysql_query(sql) or
print(mysql_error());
//mail(to, subject, msg,
additional_headers);
mail(_POST['email'],'hello
there','Hello
'._POST['name'].', thank you for
filling out the form ', "From:
athompson@building-doctors.com");
echo "<table border=1 cellpadding=2 cellspacing=2
><tr><td>";
echo 'Hello '._POST['name'].', thank
you for filling out the form ';
echo "</tr></td></table>";
echo "<body onLoad=redirect() text=#000000
link=#00FFFF vlink=#C0C0C0>";
}
else
{
?>
--------

here is the form

--------
<form method="POST" action="getstartedform.php"
onsubmit="return formCheck(this)">
<tr bgcolor="#F4FFF4">
<td
width="195">name:<br /> <input
type="text" name="name" class="textstyle"
/></td>
<td
width="205">email: <br /> <input
type="text" name="email"
class="textstyle"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
rowspan="2">contact address:
<textarea
name="contact_address" cols="25" rows="2"
id="contact_address"></textarea></td>

<td>mobile:<br /> <input
name="mobile" type="text" class="textstyle"
id="mobile"/></td>
</tr>
<tr>
<td
bgcolor="#F4FFF4">work/home tel:
<input
name="workhome_tel" type="text"
class="textstyle"
id="workhome_tel"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td>contact
postcode:<br /> <input
name="contact_postcode" type="text"
class="textstyle" id="contact_postcode"
/></td>
<td>project
postcode: <br />
<input
name="project_pcode" type="text"
class="textstyle" id="project_pcode"/>
</td>
</tr>
<tr>
<td
colspan="2"><table width="400"
border="1" cellpadding="0" cellspacing="0"
bordercolor="#FFFFFF" class="textstyle">
<tr
bgcolor="#C7E2C0">
<td
width="89"><div
align="center"></div></td>
<td
width="91"><div
align="center">garden</div></td>
<td
width="64"><div
align="center">loft</div></td>
<td
width="76"><div
align="center">refit</div></td>
<td
width="80"><div
align="center">extension</div></td>
</tr>
<tr
bgcolor="#FBFFFB">
<td
height="15" align="center">project</td>

<td><div align="center">

<input name="project_garden"
type="checkbox"  class="textstyle"
id="project_garden" value="1"/>

</div></td>

<td><div align="center">

<input name="project_loft" type="checkbox"
class="textstyle" id="project_loft"
value="1"/>

</div></td>

<td><div align="center">

<input name="project_refit" type="checkbox"
class="textstyle" id="project_refit"
value="1"/>

</div></td>

<td><div align="center">

<input name="project_extension"
type="checkbox"  class="textstyle"
id="project_extension" value="1"/>

</div></td>
</tr>
<tr
bgcolor="#C7E2C0">
<td
align="center"><div
align="center"></div></td>

<td><div
align="center">shop</div></td>

<td><div
align="center">office</div></td>

<td><div
align="center">home</div></td>

<td><div
align="center">other</div></td>
</tr>
<tr
bgcolor="#FBFFFB">
<td
align="center">use</td>

<td><div align="center">

<input name="use_shop" type="checkbox"
class="textstyle" id="use_shop"
value="1"/>

</div></td>

<td><div align="center">

<input name="use_office" type="checkbox"
class="textstyle" id="use_office"
value="1"/>

</div></td>

<td><div align="center">

<input name="use_home" type="checkbox"
class="textstyle" id="use_home"
value="1"/>

</div></td>

<td><div align="center">

<input name="use_other" type="checkbox"
class="textstyle" id="use_other"
value="1"/>

</div></td>
</tr>

</table></td>
</tr>
</table>
<table width="100%"
border="1" cellpadding="0" cellspacing="0"
bordercolor="#F5F5F5" class="textstyle">
<tr>
<td colspan="2"
bgcolor="#305A36" class="boldtext"><div
align="center" class="stylewht">type of help

required</div></td>
<td colspan="2"
bgcolor="#305A36" class="boldtext"><div
align="center" class="stylewht">special
needs</div></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td width="24%"
bordercolor="#FFFFFF"><div
align="right">engineer</div></td>
<td width="25%"
bordercolor="#FFFFFF"
bgcolor="#F4FFF4"><input name="engineer"
type="checkbox"  class="textstyle"
id="engineer" value="1"/></td>
<td width="32%"
bordercolor="#FFFFFF"><div
align="right">Wheelchair
ecology</div></td>
<td width="19%"
bordercolor="#FFFFFF"><input
name="wheelchair" type="checkbox"
class="textstyle" id="wheelchair"
value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">party wall</div></td>
<td
bordercolor="#FFFFFF"><input name="partywall"
type="checkbox"  class="textstyle"
id="partywall" value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">Partial eyesight</div></td>

<td
bordercolor="#FFFFFF"><input
name="partialeyesight" type="checkbox"
class="textstyle" id="partialeyesight"
value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">architect</div></td>
<td
bordercolor="#FFFFFF"><input name="architect"
type="checkbox"  class="textstyle"
id="architect" value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">terraced</div></td>
<td
bordercolor="#FFFFFF"><input name="terraced"
type="checkbox"  class="textstyle"
id="terraced" value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">project manager</div></td>
<td
bordercolor="#FFFFFF"><input
name="projectmanager" type="checkbox"
class="textstyle" id="projectmanager"
value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">family & <br />

children</div></td>
<td
bordercolor="#FFFFFF"><input
name="familychildren" type="checkbox"
class="textstyle" id="familychildren"
value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">design</div></td>
<td
bordercolor="#FFFFFF"><input name="design"
type="checkbox"  class="textstyle"
id="design" value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">semi-detached</div></td>
<td
bordercolor="#FFFFFF"><input
name="semidetached" type="checkbox"
class="textstyle" id="semidetached"
value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">lifestyle</div></td>
<td
bordercolor="#FFFFFF"><input name="lifestyle"
type="checkbox"  class="textstyle"
id="lifestyle" value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">aged</div></td>
<td
bordercolor="#FFFFFF"><input name="aged"
type="checkbox"  class="textstyle"
id="aged" value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">structural</div></td>
<td
bordercolor="#FFFFFF"><input
name="structural" type="checkbox"
class="textstyle" id="structural"
value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">allergy</div></td>
<td
bordercolor="#FFFFFF"><input name="allergy"
type="checkbox"  class="textstyle"
id="allergy" value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">planning</div></td>
<td
bordercolor="#FFFFFF"><input name="planning"
type="checkbox"  class="textstyle"
id="planning" value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">detached</div></td>
<td
bordercolor="#FFFFFF"><input name="detached"
type="checkbox"  class="textstyle"
id="detached" value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td
bordercolor="#FFFFFF"><div
align="right">building regs</div></td>
<td
bordercolor="#FFFFFF"><input
name="buildingregs" type="checkbox"
class="textstyle" id="buildingregs"
value="1"/></td>
<td
bordercolor="#FFFFFF"><div
align="right">other</div></td>
<td
bordercolor="#FFFFFF"><input name="other"
type="checkbox"  class="textstyle"
id="other" value="1"/></td>
</tr>
<tr
bgcolor="#F4FFF4">
<td colspan="2"
bordercolor="#FFFFFF"><div
align="left">other
<input
name="otherhelp" type="text"
class="textstyle" id="otherhelp"
size="20"/>

</div></td>
<td colspan="2"
bordercolor="#FFFFFF"><div
align="right">please specify
<input
name="otherneeds" type="text"
class="textstyle" id="otherneeds"
size="20"/>

</div></td>
</tr>
</table>
<table width="100%"
border="1" cellpadding="0" cellspacing="0"
bordercolor="#F5F5F5" class="textstyle">
<tr
bgcolor="#305A36">
<td colspan="5"
class="boldtext"><div align="center"
class="stylewht">Customer

Preferences</div></td>
</tr>
<tr>
<td
width="1%"> </td>
<td width="17%"
bordercolor="#FFFFFF"
bgcolor="#C7E2C0"> </td>
<td width="26%"
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">refurb</div></td>
<td width="36%"
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">extra

space</div></td>
<td width="20%"
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">extra

light</div></td>
</tr>
<tr>

<td> </td>
<td
align="center" valign="middle"
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="right">Do
you
need...</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="need_refurb" value="1"
/>

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="need_xspace" value="1"
/>

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="need_xlight" value="1"
/>

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="right"></div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">contemporary</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">traditional</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">mixed</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="right">Design

style</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="designstyle_contemporary"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="designstyle_traditional"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="designstyle_mixed"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="right"></div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">1

month</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">6

months</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">9

months</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="right">program
time
completion</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="programtimecompletion_1m"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="programtimecompletion_6m"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="center">
<input
type="radio" name="programtimecompletion_9m"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="right"></div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0">3000k -
14999k</td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">15000k
-
45000k</div></td>
<td
bordercolor="#FFFFFF"
bgcolor="#C7E2C0">  > 45000k</td>

</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="right">budget

cost</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="budgetcost_3k-15k"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="budgetcost_15k-45k"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="budgetcost_over45k"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="right"></div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">yes</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">no</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">maybe</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="right">is
program<br
/>
more important
than cost</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthancost_yes"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthancost_no"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthancost_maybe"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="right">is
design more
important than program<br />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthanprogram_yes"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthanprogram_no"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthanprogram_maybe"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#F2FFF2"><div
align="right">is
cost more
important than design<br />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthandesign_yes"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthandesign_no"
value="1" />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#E9EFE4"><div
align="center">
<input
type="radio" name="imortantthandesign_maybe"
value="1" />

</div></td>
</tr>
<tr>

<td> </td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="right"></div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">to

rent</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">to

sell</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#C7E2C0"><div
align="center">to

keep</div></td>
</tr>
<tr>

<td> </td>
<td align="left"
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="right">Why
are you
building<br />

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="whybuild_rent" value="1"
/>

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="whybuild_sell" value="1"
/>

</div></td>
<td
bordercolor="#FFFFFF" bgcolor="#FBFFFB"><div
align="center">
<input
type="radio" name="whybuild_keep" value="1"
/>

</div></td>
</tr>
<tr>

<td> </td>
<td
align="right" bordercolor="#FFFFFF"
bgcolor="#F4FFF4">any other
notes</td>
<td colspan="2"
bordercolor="#FFFFFF"
bgcolor="#F4FFF4"><textarea
name="otherbuildingnotes" cols="30" rows="2"
class="textstyle"
id="otherbuildingnotes"></textarea></td>
<td
bordercolor="#FFFFFF"
bgcolor="#F4FFF4"> </td>
</tr>
<tr>

<td> </td>
<td
colspan="2"><div align="right">
<input
type="submit" name="Submit" value="Submit"
class="textstyle"/>

</div></td>
<td
colspan="2"><input type="reset"
name="reset" value="Reset"
class="textstyle"/></td>
</tr>
</table>
</form></td>
</tr>
</table>

<?
}
?>
</html>
--------

now here is the php to actually view what has been filled in:

--------
<?php
user="";//again i took it out for this posting. all
values are the same
host="";//with regards to the
user,host,database,password
password="";//for both files
database="";
 connection=mysql_connect(host,user,p
assword)
or die ("could not connect to server");
 db=mysql_select_db(database,connectio
n);
result = mysql_query("select * from
getstarted",connection);
echo "<table border=1 cellpadding=2 cellspacing=2 >";
echo
"<tr><td><b>Name</b></td><td><b>email</b></td><td><b>contact
address</b></td><td><b>mobile</b></td><td><b>work
/ home phone
number</b></td><td><b>contact
postcode</b></td><td><b>project
postcode</b></td><td><b>garden
project</b></td><td><b>loft
project</b></td><td><b>refit
project</b></td><td><b>extension
project</b></td><td><b>for shop
use</b></td><td><b>for office
use</b></td><td><b>for home
use</b></td><td><b>for another
use</b></td><td><b>engineer</b></td><td><b>partywall</b></td><td><b>Project
Manager</b></td><td><b>Design</b></td><td><b>Lifestyle</b></td><td><b>Strucu
ral</b></td><td><b>Planning</b></td><td><b>Building
Regs</b></td><td><b>Other
help</b></td><td><b>Wheelchair
Ecology</b></td><td><b>Partial eye
sight</b></td><td><b>terraced</b></td><td><b>family
and children</b></td><td><b>Semi
detached</b></td><td><b>Aged</b></td><td><b>Allergy</b></td><td><b>Detached<
/b></td><td><b>Other</b></td><td><b>Other
needs</b></td><td><b>needs
refurbishment</b></td><td><b>Need
Extra Space</b></td><td><b>Needs
Extra Light</b></td><td><b>Design
Style:
Contemporary</b></td><td><b>Design
style:
Traditional</b></td><td><b>Design
style:
Mixed</b></td><td><b>Program time
completion: 1
month</b></td><td><b>Program Time
Completion: 6
months</b></td><td><b>Program time
completion: 9
months</b></td><td><b>budget cost of
3k-14k</b></td><td><b>budget cost of
15k-45k</b></td><td><b>budget cost of
over45k</b></td><td><b>important than
cost:
yes</b></td><td><b>important than
cost: no</b></td><td><b>important
than cost:
maybe</b></td><td><b>important than
program:
yes</b></td><td><b>important than
program:
no</b></td><td><b>important than
program:
maybe</b></td><td><b>important than
design:
yes</b></td><td><b>important than
design:
no</b></td><td><b>important than
design: maybe</b></td><td><b>why
build: rent</b></td><td><b>why
build: sell</b></td><td><b>why
build: keep</b></td><td><b>other
building notes</b></td></tr>";
while (myrow = mysql_fetch_array(result))
{
echo "<tr><td>";
echo myrow["name"];
echo "<td>";
echo myrow["email"];
echo "<td>";
echo myrow["contact_address"];
echo "<td>";
echo myrow["mobile"];
echo "<td>";
echo myrow["workhome_tel"];
echo "<td>";
echo myrow["contact_postcode"];
echo "<td>";
echo myrow["project_postcode"];
echo "<td>";
echo myrow["project_garden"];
echo "<td>";
echo myrow["project_loft"];
echo "<td>";
echo myrow["project_extension"];
echo "<td>";
echo myrow["use_shop"];
echo "<td>";
echo myrow["use_office"];
echo "<td>";
echo myrow["use_home"];
echo "<td>";
echo myrow["use_other"];
echo "<td>";
echo myrow["engineer"];
echo "<td>";
echo myrow["partywall"];
echo "<td>";
echo myrow["projectmanager"];
echo "<td>";
echo myrow["design"];
echo "<td>";
echo myrow["lifestyle"];
echo "<td>";
echo myrow["structural"];
echo "<td>";
echo myrow["planning"];
echo "<td>";
echo myrow["buildingregs"];
echo "<td>";
echo myrow["otherhelp"];
echo "<td>";
echo myrow["wheelchair"];
echo "<td>";
echo myrow["partialeyesight"];
echo "<td>";
echo myrow["terraced"];
echo "<td>";
echo myrow["familychildren"];
echo "<td>";
echo myrow["semidetached"];
echo "<td>";
echo myrow["aged"];
echo "<td>";
echo myrow["allergy"];
echo "<td>";
echo myrow["detached"];
echo "<td>";
echo myrow["other"];
echo "<td>";
echo myrow["otherneeds"];
echo "<td>";
echo myrow["needrefurb"];
echo "<td>";
echo myrow["need_xspace"];
echo "<td>";
echo myrow["need_xlight"];
echo "<td>";
echo myrow["designstyle_contemporary"];
echo "<td>";
echo myrow["designstyle_traditional"];
echo "<td>";
echo myrow["designstyle_mixed"];
echo "<td>";
echo myrow["programtimecompletion_1m"];
echo "<td>";
echo myrow["programtimecompletion_6m"];
echo "<td>";
echo myrow["programtimecompletion_9m"];
echo "<td>";
echo myrow["budgetcost_3kto14k"];
echo "<td>";
echo myrow["budgetcost_15kto45k"];
echo "<td>";
echo myrow["budgetcost_over45k"];
echo "<td>";
echo myrow["importantthancost_yes"];
echo "<td>";
echo myrow["importantthancost_no"];
echo "<td>";
echo myrow["importantthancost_maybe"];
echo "<td>";
echo myrow["importantthanprogram_yes"];
echo "<td>";
echo myrow["importantthanprogram_no"];
echo "<td>";
echo myrow["importantthanprogram_maybe"];
echo "<td>";
echo myrow["importantthandesign_yes"];
echo "<td>";
echo myrow["importantthandesign_no"];
echo "<td>";
echo myrow["importantthandesign_maybe"];
echo "<td>";
echo myrow["whybuild_rent"];
echo "<td>";
echo myrow["whybuild_sell"];
echo "<td>";
echo myrow["whybuild_keep"];
echo "<td>";
echo myrow["otherbuildingnotes"];
}
echo "</table>";
?>
--------

what is not happening is the autoresponder isnt working neither is the
viewdb filling up with whatever has be filled out in the getstarted
form. can someone have a look at it and help me with this problem
please.

here is the sql code that i am using:
--------

CREATE TABLE getstarted (
id          MEDIUMINT NOT NULL
AUTO_INCREMENT,
name          CHAR(50) NOT NULL,
email          varchar(75) not null,
contactAddress       varchar(255),
mobile          int(13),
workHomeTel      int(13),
contactPostcode      varchar(8),
projectPostcode      varchar(8),
projectGarden      Tinyint(1) default
'0',
projectLoft      Tinyint(1) default
'0',
projectXtension      Tinyint(1) default
'0',
shopUse         Tinyint(1) default
'0',
officeUse      Tinyint(1) default '0',
homeUse         Tinyint(1) default
'0',
otherUses      varchar(255),
engineer      Tinyint(1) default '0',
partywall      Tinyint(1) default '0',
projectManager      Tinyint(1) default
'0',
design         Tinyint(1) default
'0',
lifestyle      Tinyint(1) default '0',
structural      Tinyint(1) default '0',

planning      Tinyint(1) default '0',
buildingregs      Tinyint(1) default
'0',
otherHelp      varchar(255),
wheelchair      Tinyint(1) default '0',

partialeyesight      Tinyint(1) default
'0',
terraced      Tinyint(1) default '0',
familyChildern      Tinyint(1) default
'0',
semiDetached      Tinyint(1) default
'0',
aged         Tinyint(1) default
'0',
allergy         Tinyint(1) default
'0',
detached      Tinyint(1) default '0',
other         Tinyint(1) default
'0',
otherNeeds      Tinyint(1) default '0',

needsRefurbishment   Tinyint(1) default '0',
needsExtraSpace      Tinyint(1) default
'0',
needsExtraLight      Tinyint(1) default
'0',
contemporarydesignstyle   Tinyint(1) default '0',

tradfitionaldesignstyle   Tinyint(1) default '0',

mixedDesignstyle   Tinyint(1) default '0',
progtimecomplete1month   Tinyint(1) default '0',
progtimecomplete6months   Tinyint(1) default '0',

progtimecomplete9months   Tinyint(1) default '0',

budgetCost3kto14k   Tinyint(1) default '0',
budgetCost15kto44k   Tinyint(1) default '0',
budgetCostOver45k   Tinyint(1) default '0',
importantThanCostYes   Tinyint(1) default '0',
importantThanCostN   Tinyint(1) default '0',
importantThanCostMaybe   Tinyint(1) default '0',
importantThanProgYes   Tinyint(1) default '0',
importantThanProgNo   Tinyint(1) default '0',
importantThanProgMaybe   Tinyint(1) default '0',
importantThandesYes   Tinyint(1) default '0',
importantThandesNo   Tinyint(1) default '0',
importantThandesMaybe   Tinyint(1) default '0',
build2rent      Tinyint(1) default '0',

build2sell      Tinyint(1) default '0',

build2keep      Tinyint(1) default '0',

otherBuildingNotes   varchar(255),
PRIMARY KEY (id)
)
--------



----------------------------------------
The post originated from PHP Freaks:
----------------------------------------
http://www.phpfreaks.com
http://www.phpfreaks.com/forums

Report this thread to moderator Post Follow-up to this message
Old Post
buzzby
08-18-04 08:57 PM

Sponsored Links



Last Thread Next Thread Next
Search this forum -> 
Post New Thread

PHP SQL archive

Show a Printable Version Send to friend Email This Page to Someone! subscribe to this thread Receive updates to this thread
Computer Consultants
Programming Jobs
Visual Basic Controls
SQL Server Programming
Webservices
Java Security
Visual Studio
C# Programming
Visual J++
Software engineering
Open source Software
Perl Programming
PHP Programming
ASP Programming
ASP .NET Programming
Visual Basic Programming
Windows Scripting Host
Java Programming
Java Help
Java Beans
VBScript
Cobol
MAC Applications
Unix Programming
Forum Jump:
All times are GMT. The time now is 04:41 PM.

 
Free MCSE Braindumps | Real Estate Topics
Programming forum archive

Copyrights CodeComments.com 2004 - 2006

Powered by vBulletin Copyright 2000-2006 Jelsoft Enterprises Limited.