How to insert radio button data into mysql

[pavithraj]

i m getting error. its not at all inserting into database.showin g error like as below

Notice: Undefined index: franchise_hours in E:\wamp\www\fra nchasebazaar\ad min_template\ac tion\add_indian _franchisor.php on line 29

Notice: Undefined index: investment in E:\wamp\www\fra nchasebazaar\ad min_template\ac tion\add_indian _franchisor.php on line 36

Notice: Undefined index: franchise_hours in E:\wamp\www\fra nchasebazaar\ad min_template\ac tion\add_indian _franchisor.php on line 39

Notice: Undefined index: franchise_budge t in E:\wamp\www\fra nchasebazaar\ad min_template\ac tion\add_indian _franchisor.php on line 46

Notice: Undefined index: high_investment in E:\wamp\www\fra nchasebazaar\ad min_template\ac tion\add_indian _franchisor.php on line 48
INSERT INTO indian_franchis or(brand_name,e mail_id,passwor d,company_name, number_of_emplo yes,internation al_headquarters ,corporate_addr ess,state,city, pin_code,indian _office,corp_ph one_number,webs ite,mobile_numb er,CEO_name,fra nchise_head,tot al_investment,f ranchise_fees,s pace,number_of_ hours,franchise _presently,seek ing_franchise_i ndia,industry,s egment,multiple _franchise_mode l,number_of_mod el,multiple_tot al_investment,m ultiple_franchi se_fee,multiple _space,mutiple_ hours,summary,p resently_franch isees_india,pre sently_franchis e_world,company _owned,for_wome ns,senior_citiz en,franchise_bu dget,franchise_ at_home,high_in vestment_franch ise,internation al_franchise,ma ster_multiple_f ranchisees,trai ning_marketing, faq,ideal_franc hisee,testimoni al,news,photogr aph,video,prope rty_requirement s,hr_requirment s) values ('', '', '', '', '1-10', '', '', '', ', ', 'yes', '', '', '', '', '1-10', 'No Franchise Fee', '0-100 Sq. Ft', '', 'india', 'bangalore', 'logicshore', 'a', 'yes', '1-3', '', 'nofranchisefee ', '0-100 ', '', '', 'none', 'yes', 'none', 'yes', 'yes', '', 'no', '', 'yes', 'yes', '', '', '', '', '', '', '')ERROR: Column count doesn't match value count at row 1

------------------------------------
my code is as below

mysql_select_db ("franchasebaza ar", $con);
$action= $_REQUEST["action"];
if($action=="sa ve")
{
echo $sql = "INSERT INTO indian_franchis or('brand_name' ,email_id,passw ord,company_nam e,number_of_emp loyes,internati onal_headquarte rs,corporate_ad dress,state,cit y,pin_code,indi an_office,corp_ phone_number,we bsite,mobile_nu mber,CEO_name,f ranchise_head,t otal_investment ,franchise_fees ,space,number_o f_hours,franchi se_presently,se eking_franchise _india,industry ,segment,multip le_franchise_mo del,number_of_m odel,multiple_t otal_investment ,multiple_franc hise_fee,multip le_space,mutipl e_hours,summary ,presently_fran chisees_india,p resently_franch ise_world,compa ny_owned,for_wo mens,senior_cit izen,franchise_ budget,franchis e_at_home,high_ investment_fran chise,internati onal_franchise, master_multiple _franchisees,tr aining_marketin g,faq,ideal_fra nchisee,testimo nial,news,photo graph,video,pro perty_requireme nts,hr_requirme nts) values ('".$_REQUEST['brandname']."',
'".$_REQUEST['email']."',
'".$_REQUEST['password']."',
'".$_REQUEST['companyname']."',
'".$_REQUEST['number_of_empl oyees']."',
'".$_REQUEST['international_ headquarters']."',
'".$_REQUEST['corporate_addr ess']."',
'".$_REQUEST['state']."',
".$_REQUEST['town']."',
".$_REQUEST['pincode']."',
'".$_REQUEST['indian_office']."',
'".$_REQUEST['corporate_phon e_number']."',
'".$_REQUEST['mobile_number']."',
'".$_REQUEST['ceo_name']."',
'".$_REQUEST['franchise_head ']."',
'".$_REQUEST['total_inverstm ent']."',
'".$_REQUEST['feein_dollers']."',
'".$_REQUEST['space']."',
'".$_REQUEST['franchise_hour s']."',
'".$_REQUEST['present_franch ise']."',
'".$_REQUEST['franchiseesini ndia']."',
'".$_REQUEST['industry']."',
'".$_REQUEST['segment']."',
'".$_REQUEST['multiple_model s']."',
'".$_REQUEST['no_of_models']."',
'".$_REQUEST['investment']."',
'".$_REQUEST['fees']."',
'".$_REQUEST['sq_ft']."',
'".$_REQUEST['franchise_hour s']."',
'".$_REQUEST['summary']."',
'".$_REQUEST['in_india']."',
'".$_REQUEST['across_world']."',
'".$_REQUEST['owned_outlets']."',
'".$_REQUEST['womens']."',
'".$_REQUEST['senior_citizen ']."',
'".$_REQUEST['franchise_budg et']."',
'".$_REQUEST['home']."',
'".$_REQUEST['high_investmen t']."',
'".$_REQUEST['international_ franchisor']."',
'".$_REQUEST['master_franchi sees']."',
'".$_REQUEST['training']."',
'".$_REQUEST['faq']."',
'".$_REQUEST['ideal_franchis ee']."',
'".$_REQUEST['testimonial']."',
'".$_REQUEST['news']."',
'".$_REQUEST['photos']."',
'".$_REQUEST['videos']."')";
if($result = mysql_query($sq l ,$con)) {
echo ' Inserted Sucessfull';
header("Locatio n:../users.php");
}
else {
echo "ERROR: ".mysql_error() ;
}
}
else if($action=="ed it") {
echo $sql = "UPDATE indian_franchis or SET brand_name='".$ _REQUEST['brandname']."', email_id='".$_R EQUEST['email']."',password='" .$_REQUEST['password']."' where id=".$_REQUEST['indianid'];
if($result = mysql_query($sq l ,$con))
{
echo 'Information has been Updated';
header("Locatio n:../users.php");
}
else
{
echo "ERROR: ".mysql_error() ;
}
}
else if($action=="de lete")
{

echo $sql = "DELETE from indian_franchis or WHERE id=".$_REQUEST['indianid'];
if($result = mysql_query($sq l ,$con))
{
echo 'Information is deleted';
header("Locatio n:../users.php");
}
else
{
echo "ERROR: ".mysql_error() ;
}

}

?>

---------------------------------------
html code is as below

<table width="100%" border="0" align="center" cellpadding="5" cellspacing="3" >
<tr>
<td width="40%" align="left" valign="top">Na me of the Brand: </td>
<td width="60%" align="left" valign="top"><i nput name="brandname " type="text" id="brandname" />
<input type="hidden" name="action" id="action" value="save"/>
<input type="hidden" name="indianid" id="indianid" value="" /> </td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top"><a href="#">Check availability </a></td>
</tr>
<tr>
<td align="left" valign="top">Yo ur Showcase URL On FranchiseBazar. Com:</td>
<td align="left" valign="top"><s elect name="showcase" id="showcase">
<option value="fb">www. franchisebazar. com/sparkleminds.co m</option>
</select> </td>
</tr>
<tr>
<td align="left" valign="top">Em ail ID<span class="style1"> *</span>:</td>
<td align="left" valign="top"><i nput name="email" type="text" id="email" /></td>
</tr>
<tr>
<td align="left" valign="top">Pa ssword:</td>
<td align="left" valign="top"><i nput name="password" type="text" id="password" /></td>
</tr>
<tr>
<td align="left" valign="top">Co nfirm Password: </td>
<td align="left" valign="top"><i nput name="password1 " type="text" id="password1" /></td>
</tr>

<tr>
<td align="left" valign="top">Na me Of Company:</td>
<td align="left" valign="top"><i nput name="companyna me" type="text" id="companyname " /></td>
</tr>
<tr>
<td align="left" valign="top">To tal No Of Employees:</td>
<td align="left" valign="top"><s elect name="number_of _employees" id="number_of_e mployees">
<option>1-10</option>
<option>10-25</option>
<option>25-100</option>
<option>100-500</option>
<option>500-1000</option>
<option>1000-10000</option>
</select> </td>
</tr>
<tr>
<td align="left" valign="top">In ternational Headquarters at:</td>
<td align="left" valign="top"><i nput name="internati onal_headquarte rs" type="text" id="internation al_headquarters " /></td>
</tr>
<tr>
<td align="left" valign="top">Co rporate Address:</td>
<td align="left" valign="top"><i nput name="corporate _address" type="text" id="corporate_a ddress" /></td>
</tr>
<tr>
<td align="left" valign="top">St ate:</td>
<td align="left" valign="top"><i nput name="state" type="text" id="state" /></td>
</tr>
<tr>
<td align="left" valign="top">Ci ty/Town:</td>
<td align="left" valign="top"><i nput name="town" type="text" id="town" /></td>
</tr>
<tr>
<td align="left" valign="top">Zi p/Pin Code:</td>
<td align="left" valign="top"><i nput name="pincode" type="text" id="pincode" /></td>
</tr>
<tr>
<td align="left" valign="top">Do You Have A India Office/Representation: </td>
<td align="left" valign="top"><s elect name="indian_of fice" id="indian_offi ce">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Co rporate
Phone Numbers:</td>
<td align="left" valign="top"><i nput name="corporate _phone_number" type="text" id="corporate_p hone_number" /></td>
</tr>
<tr>
<td align="left" valign="top">We bsite:</td>
<td align="left" valign="top"><s elect name="website" id="website">
<option selected="selec ted">www.sparkl eminds.com</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Mo bile Number:</td>
<td align="left" valign="top"><i nput name="mobile_nu mber" type="text" id="mobile_numb er" /></td>
</tr>
<tr>
<td align="left" valign="top">Di rector/CEO Name<span class="style1"> *</span>:</td>
<td align="left" valign="top"><i nput name="ceo_name" type="text" id="ceo_name" /></td>
</tr>
<tr>
<td align="left" valign="top">Fr anchise Head:</td>
<td align="left" valign="top"><i nput name="franchise _head" type="text" id="franchise_h ead" /></td>
</tr>
<tr>
<td align="left" valign="top">To tal Investment:</td>
<td align="left" valign="top"><s elect name="total_inv erstment" id="total_inver stment">
<option>1-10</option>
<option>10-25</option>
<option>25-100</option>
<option>100-500</option>
<option>500-1000</option>
<option>1000-10000</option>
<option>&gt;100 00</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Fr anchise Fee/Any Non Refundable Fee:</td>
<td align="left" valign="top"><t able width="100%" border="0"cellp adding="3" cellspacing="0" >
<tr>
<td width="32%" align="center"> <strong>In US$</strong></td>
<td width="68%" align="left"><s trong>In Indian Rupee</strong></td>
</tr>
<tr>
<td align="center"> <select name="feein_dol lers" id="feein_dolle rs">
<option>No Franchise Fee</option>
<option>50,00 0-1,00,000</option>
<option>1,00,00 0-2,00,000</option>
<option>2,00,00 0-3,00,000</option>
<option>3,00,00 0-5,00,000</option>
<option>5,00,00 0-8,00,000</option>
<option>8,00,00 0-10,00,000</option>
<option>10,00,0 00-20,00,000</option>
<option>20,00,0 00-30,00,000</option>
<option>30,00,0 00-50,00,000</option>
<option>Great er Than 50,00,000</option>
</select></td>
<td align="left"><i nput name="feein_rup ees" type="text" id="feein_rupee s" size="12" /></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Sp ace In Sq Ft:</td>
<td align="left" valign="top"><s elect name="space" id="space">
<option>0-100 Sq. Ft</option>
<option>100-250 Sq. Ft</option>
<option>250-500 Sq. Ft</option>
<option>500-750 Sq. Ft</option>
<option>750-1000 Sq. Ft</option>
<option>1000-1500 Sq. Ft</option>
<option>1500-2000 Sq Ft</option>
<option>2000-3000 Sq Ft</option>
<option>3000-5000 Sq. Ft</option>
<option>5000-10000 Sq. Ft</option>
<option>10000-20000 Sq Ft</option>
<option>20000-50000 Sq Ft</option>
<option>50000-100000 Sq Ft</option>
<option>Great er Than 100000 Sq Ft</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">No Of Hours the franchisee will have to put in?</td>
<td height="125" align="left" valign="top"><t able width="80%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="9%"><inp ut name="no_of_hou rs" type="radio" value="hours1" /></td>
<td width="91%">Par t Time&lt;20 Hrs A Week 1/4 Time</td>
</tr>
<tr>
<td><input name="no_of_hou rs" type="radio" value="hours2" /></td>
<td>2/4th Time 20-30 Hrs A Week </td>
</tr>
<tr>
<td><input name="no_of_hou rs" type="radio" value="hours3" /></td>
<td>3/4th Time 30-40 Hrs A Week </td>
</tr>
<tr>
<td><input name="no_of_hou rs" type="radio" value="hours4" /></td>
<td>Full Time. (40+ Hrs/Week)</td>
</tr>
<tr>
<td><input name="no_of_hou rs" type="radio" value="hours5" /></td>
<td>Not required to be present.</td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Fr anchisees Presently Available At<span class="style1"> *:</span></td>
<td align="left" valign="top"><s elect name="present_f ranchise" id="present_fra nchise">
<option value="india">I ndia</option>
<option value="pakistan ">Pakistan</option>
<option value="america" >America</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Se eking Franchisees In India At:(Press Ctrl + Down Key To Choose The Exact Locations):</td>
<td align="left" valign="top"><s elect name="franchise esinindia" id="franchisees inindia">
<option value="bangalor e">Bangalore </option>
<option value="mysore"> Mysore</option>
<option value="hassan"> Hassan</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">In dustry<span class="style1"> *</span>:</td>
<td align="left" valign="top"><s elect name="industry" id="industry">
<option value="logicsho re">logicshor e</option>
<option value="infosys" >Infosys</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Se gment Within Industry<span class="style1"> *</span>:</td>
<td align="left" valign="top"><s elect name="segment" id="segment">
<option value="a">a</option>
<option value="b">b</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td align="left" valign="top"><s trong>Multiple Formats</strong></td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td align="left" valign="top">Do You Operate Multiple Franchise Models:</td>
<td align="left" valign="top"><s elect name="multiple_ models" id="multiple_mo dels">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Me ntion The Number Of Models You Have:</td>
<td align="left" valign="top"><s elect name="no_of_mod els" id="no_of_model s">
<option>1-3</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">To tal Investment:</td>
<td align="left" valign="top"><s elect name="total_inv estment" id="total_inves tment">
<option value="1-10">1-10</option>
<option value="10-25">10-25</option>
<option value="25-100">25-100</option>
<option value="100-500">100-500</option>
<option value="500-1000">500-1000</option>
<option value="1000-10000">1000-10000</option>
<option value="greatert han10000">&gt;1 0000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Fr anchise Fee/Any Non Refundable Fee:</td>
<td align="left" valign="top"><s elect name="fees" id="fees">
<option value="nofranch isefee">No Franchise Fee</option>
<option value="50,000-1,00,000">50,00 0-1,00,000</option>
<option value="1,00,000-2,00,000">1,00, 000-2,00,000</option>
<option value="2,00,000-3,00,000">2,00, 000-3,00,000</option>
<option value="3,00,000-5,00,000">3,00, 000-5,00,000</option>
<option value="5,00,000-8,00,000">5,00, 000-8,00,000</option>
<option value="8,00,000-10,00,000">8,00 ,000-10,00,000</option>
<option value="10,00,00 0-20,00,000">10,0 0,000-20,00,000</option>
<option value="20,00,00 0-30,00,000">20,0 0,000-30,00,000</option>
<option value="30,00,00 0-50,00,000">30,0 0,000-50,00,000</option>
<option value="Greater Than 50,00,000">Grea ter Than 50,00,000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Sp ace In Sq Ft:</td>
<td align="left" valign="top"><s elect name="sq_ft" id="sq_ft">
<option value="0-100 ">0-100 Sq. Ft</option>
<option value="100-250">100-250 Sq. Ft</option>
<option value="250-500">250-500 Sq. Ft</option>
<option value="500-750">500-750 Sq. Ft</option>
<option value="750-1000">750-1000 Sq. Ft</option>
<option value="1000-1500">1000-1500 Sq. Ft</option>
<option value="1500-2000">1500-2000 Sq Ft</option>
<option value="2000-3000">2000-3000 Sq Ft</option>
<option value="3000-5000">3000-5000 Sq. Ft</option>
<option value="5000-10000">5000-10000 Sq. Ft</option>
<option value="10000-20000">10000-20000 Sq Ft</option>
<option value="20000-50000">20000-50000 Sq Ft</option>
<option value="50000-100000">50000-100000 Sq Ft</option>
<option value="&gt;1000 00">Greater Than 100000 Sq Ft</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">No Of Hours the franchisee will have to put in:</td>
<td align="left" valign="top"><t able width="80%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="7%"><inp ut name="franchise _hours" type="radio" value="hour1" /></td>
<td width="93%">2/4th Time 20-30 Hrs A Week </td>
</tr>
<tr>
<td><input name="franchise _hours" type="radio" value="hour2" /></td>
<td>3/4th Time 30-40 Hrs A Week </td>
</tr>
<tr>
<td><input name="franchise _hours" type="radio" value="hour3" /></td>
<td>Not required to be present.</td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Su mmary Within 5 Sentences<span class="style1"> *</span>:</td>
<td align="left" valign="top"><t extarea name="summary" cols="30" rows="5" id="summary"></textarea></td>
</tr>
<tr>
<td align="left" valign="top">Ho w many franchisees do you presently have in India:</td>
<td align="left" valign="top"><s elect name="in_india" id="in_india">
<option value="none">no ne</option>
<option value="lessthan 5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between1 6-30">Between16-30</option>
<option value="between3 1-100">Between 31-100</option>
<option value="morethan 100">More than 100</option>
<option value="&gt;200" >&gt;200</option>
<option value="&gt;300" >&gt;300</option>
<option value="&gt;500" >&gt;500</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Ho w many franchisees do you have across the world:</td>
<td align="left" valign="top"><s elect name="across_wo rld" id="across_worl d">
<option value="yes">Yes </option>
<option value="lessthan 5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between1 6-30">Between16-30</option>
<option value="between3 1-100">Between 31-100</option>
<option value="morethan 100">More than 100</option>
<option value="&gt;200" >&gt;200</option>
<option value="&gt;300" >&gt;300</option>
<option value="&gt;500" >&gt;500</option>
<option>&gt;100 0</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Ho w many company owned outlets do you have:</td>
<td align="left" valign="top"><s elect name="owned_out lets" id="owned_outle ts">
<option value="none">no ne</option>
<option value="lessthan 5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between1 6-30">Between16-30</option>
<option value="between3 1-100">Between 31-100</option>
<option value="morethan 100">More than 100</option>
<option value="&gt;200" >&gt;200</option>
<option value="&gt;300" >&gt;300</option>
<option value="&gt;500" >&gt;500</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><s trong>Franchise/Business Suitability</strong></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td align="left" valign="top">Is your franchise/Business Opportunity suitable for Women:</td>
<td align="left" valign="top"><s elect name="womens" id="womens">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Is your franchisee/Business Opportunity suitable for senior citizens, retired professionals &amp;/or people above 45 Yrs of age:</td>
<td align="left" valign="top"><s elect name="senior_ci tizen" id="senior_citi zen">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><t able width="96%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td colspan="2" valign="top"><i nput name="low_cost_ franchise" type="checkbox" id="low_cost_fr anchise" value="low_cost _franchise" />
&nbsp;&nbsp;&nb sp;Is your franchisee/Business Opportunity a low cost franchise:Our Franchise could be listed under the Low Cost Franchise Opportunities Directory </td>
</tr>
<tr>
<td width="22%" valign="top">&n bsp;</td>
<td width="78%"><ta ble width="80%" border="0" align="center" cellpadding="0" cellspacing="0" >
<tr>
<td width="5%"><inp ut name="franchise _budget" type="radio" value="budget1" /></td>
<td width="95%">Bel ow 20 Lakhs</td>
</tr>
<tr>
<td><input name="franchise _budget" type="radio" value="budget" /></td>
<td>Below 10 Lakhs</td>
</tr>
<tr>
<td><input name="franchise _budget" type="radio" value="budget" /></td>
<td>Below 5 Lakhs</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Ca n your franchisee work from home and do not need to arrange a separate property:If yes, your franchise would be listed under the work from home franchise directory:</td>
<td align="left" valign="top"><s elect name="home" id="home">
<option value="no">no</option>
<option value="yes">yes </option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Is your franchisee a High Investment franchise:Our Franchise could be listed under the High Investment Franchise Opportunities Directory:</td>
<td align="left" valign="top"><t able width="80%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="7%"><inp ut name="high_inve stment" type="checkbox" id="high_invest ment" value="high_inv estment" /></td>
<td width="93%">Cap ital Investment Range is above 50 Lakhs</td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Is your franchise a International Franchise:Our Franchise could be listed under the international franchise opportunity section:</td>
<td align="left" valign="top"><s elect name="internati onal_franchisor " id="internation al_franchisor">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Ar e you seeking Master/Multiple franchisees</td>
<td align="left" valign="top"><s elect name="master_fr anchisees" id="master_fran chisees">
<option value="yes">yes </option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><s trong>Franchise Information:</strong></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
<tr>
<td align="left" valign="top">Tr aining/Marketing/Other Support:</td>
<td align="left" valign="top"><i nput name="training" type="text" id="training" /></td>
</tr>
<tr>
<td align="left" valign="top">To p 5 Frequently Asked Q of your Opportunity:</td>
<td align="left" valign="top"><i nput name="faq" type="text" id="faq" /></td>
</tr>
<tr>
<td align="left" valign="top">Wh o is your Ideal Franchisee?What is it that you seek from the franchisee?:</td>
<td align="left" valign="top"><i nput name="ideal_fra nchisee" type="text" id="ideal_franc hisee" /></td>
</tr>

<tr>
<td align="left" valign="top">Fr anchisee Testimonials:</td>
<td align="left" valign="top"><i nput name="testimoni al" type="text" id="testimonial " /></td>
</tr>
<tr>
<td align="left" valign="top">Co mpany News/Press Releases:</td>
<td align="left" valign="top"><i nput name="news" type="text" id="news" /></td>
</tr>
<tr>
<td align="left" valign="top">Ph otographs:</td>
<td align="left" valign="top"><i nput name="photos" type="text" id="photos" /></td>
</tr>
<tr>
<td align="left" valign="top">Vi deo:</td>
<td align="left" valign="top"><i nput name="videos" type="text" id="videos" /></td>
</tr>
<tr>
<td align="left" valign="top">Pr operty Requirements:</td>
<td align="left" valign="top"><a href="#">I want to list my property requirements now</a></td>
</tr>
<tr>
<td align="left" valign="top">HR Requirements:</td>
<td align="left" valign="top"><a href="#">I want to Post HR Requirements Now</a></td>
</tr>
<tr>
<td align="left" valign="top">&n bsp;</td>
<td align="left" valign="top">&n bsp;</td>
</tr>
</table>



PLEASE ANYONE HELP ME. I M FRESHER IN PHP

[pradeepkr13]

before inserting any values check if it is null/empty then create SQL accordingly.
eg,

if(!isset($_REQUEST['franchise_hours']) || $_REQUEST['franchise_hours']=="" )
   $franchise_hours; = "''";

Use this in the SQL.