473,396 Members | 1,813 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to insert radio button data into mysql

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

Notice: Undefined index: franchise_hours in E:\wamp\www\franchasebazaar\admin_template\action\ add_indian_franchisor.php on line 29

Notice: Undefined index: investment in E:\wamp\www\franchasebazaar\admin_template\action\ add_indian_franchisor.php on line 36

Notice: Undefined index: franchise_hours in E:\wamp\www\franchasebazaar\admin_template\action\ add_indian_franchisor.php on line 39

Notice: Undefined index: franchise_budget in E:\wamp\www\franchasebazaar\admin_template\action\ add_indian_franchisor.php on line 46

Notice: Undefined index: high_investment in E:\wamp\www\franchasebazaar\admin_template\action\ add_indian_franchisor.php on line 48
INSERT INTO indian_franchisor(brand_name,email_id,password,com pany_name,number_of_employes,international_headqua rters,corporate_address,state,city,pin_code,indian _office,corp_phone_number,website,mobile_number,CE O_name,franchise_head,total_investment,franchise_f ees,space,number_of_hours,franchise_presently,seek ing_franchise_india,industry,segment,multiple_fran chise_model,number_of_model,multiple_total_investm ent,multiple_franchise_fee,multiple_space,mutiple_ hours,summary,presently_franchisees_india,presentl y_franchise_world,company_owned,for_womens,senior_ citizen,franchise_budget,franchise_at_home,high_in vestment_franchise,international_franchise,master_ multiple_franchisees,training_marketing,faq,ideal_ franchisee,testimonial,news,photograph,video,prope rty_requirements,hr_requirments) 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("franchasebazaar", $con);
$action= $_REQUEST["action"];
if($action=="save")
{
echo $sql = "INSERT INTO indian_franchisor('brand_name',email_id,password,c ompany_name,number_of_employes,international_headq uarters,corporate_address,state,city,pin_code,indi an_office,corp_phone_number,website,mobile_number, CEO_name,franchise_head,total_investment,franchise _fees,space,number_of_hours,franchise_presently,se eking_franchise_india,industry,segment,multiple_fr anchise_model,number_of_model,multiple_total_inves tment,multiple_franchise_fee,multiple_space,mutipl e_hours,summary,presently_franchisees_india,presen tly_franchise_world,company_owned,for_womens,senio r_citizen,franchise_budget,franchise_at_home,high_ investment_franchise,international_franchise,maste r_multiple_franchisees,training_marketing,faq,idea l_franchisee,testimonial,news,photograph,video,pro perty_requirements,hr_requirments) values ('".$_REQUEST['brandname']."',
'".$_REQUEST['email']."',
'".$_REQUEST['password']."',
'".$_REQUEST['companyname']."',
'".$_REQUEST['number_of_employees']."',
'".$_REQUEST['international_headquarters']."',
'".$_REQUEST['corporate_address']."',
'".$_REQUEST['state']."',
".$_REQUEST['town']."',
".$_REQUEST['pincode']."',
'".$_REQUEST['indian_office']."',
'".$_REQUEST['corporate_phone_number']."',
'".$_REQUEST['mobile_number']."',
'".$_REQUEST['ceo_name']."',
'".$_REQUEST['franchise_head']."',
'".$_REQUEST['total_inverstment']."',
'".$_REQUEST['feein_dollers']."',
'".$_REQUEST['space']."',
'".$_REQUEST['franchise_hours']."',
'".$_REQUEST['present_franchise']."',
'".$_REQUEST['franchiseesinindia']."',
'".$_REQUEST['industry']."',
'".$_REQUEST['segment']."',
'".$_REQUEST['multiple_models']."',
'".$_REQUEST['no_of_models']."',
'".$_REQUEST['investment']."',
'".$_REQUEST['fees']."',
'".$_REQUEST['sq_ft']."',
'".$_REQUEST['franchise_hours']."',
'".$_REQUEST['summary']."',
'".$_REQUEST['in_india']."',
'".$_REQUEST['across_world']."',
'".$_REQUEST['owned_outlets']."',
'".$_REQUEST['womens']."',
'".$_REQUEST['senior_citizen']."',
'".$_REQUEST['franchise_budget']."',
'".$_REQUEST['home']."',
'".$_REQUEST['high_investment']."',
'".$_REQUEST['international_franchisor']."',
'".$_REQUEST['master_franchisees']."',
'".$_REQUEST['training']."',
'".$_REQUEST['faq']."',
'".$_REQUEST['ideal_franchisee']."',
'".$_REQUEST['testimonial']."',
'".$_REQUEST['news']."',
'".$_REQUEST['photos']."',
'".$_REQUEST['videos']."')";
if($result = mysql_query($sql ,$con)) {
echo ' Inserted Sucessfull';
header("Location:../users.php");
}
else {
echo "ERROR: ".mysql_error();
}
}
else if($action=="edit") {
echo $sql = "UPDATE indian_franchisor SET brand_name='".$_REQUEST['brandname']."', email_id='".$_REQUEST['email']."',password='".$_REQUEST['password']."' where id=".$_REQUEST['indianid'];
if($result = mysql_query($sql ,$con))
{
echo 'Information has been Updated';
header("Location:../users.php");
}
else
{
echo "ERROR: ".mysql_error();
}
}
else if($action=="delete")
{

echo $sql = "DELETE from indian_franchisor WHERE id=".$_REQUEST['indianid'];
if($result = mysql_query($sql ,$con))
{
echo 'Information is deleted';
header("Location:../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">Name of the Brand: </td>
<td width="60%" align="left" valign="top"><input 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">&nbsp;</td>
<td align="left" valign="top"><a href="#">Check availability </a></td>
</tr>
<tr>
<td align="left" valign="top">Your Showcase URL On FranchiseBazar.Com:</td>
<td align="left" valign="top"><select name="showcase" id="showcase">
<option value="fb">www.franchisebazar.com/sparkleminds.com</option>
</select> </td>
</tr>
<tr>
<td align="left" valign="top">Email ID<span class="style1">*</span>:</td>
<td align="left" valign="top"><input name="email" type="text" id="email" /></td>
</tr>
<tr>
<td align="left" valign="top">Password:</td>
<td align="left" valign="top"><input name="password" type="text" id="password" /></td>
</tr>
<tr>
<td align="left" valign="top">Confirm Password: </td>
<td align="left" valign="top"><input name="password1" type="text" id="password1" /></td>
</tr>

<tr>
<td align="left" valign="top">Name Of Company:</td>
<td align="left" valign="top"><input name="companyname" type="text" id="companyname" /></td>
</tr>
<tr>
<td align="left" valign="top">Total No Of Employees:</td>
<td align="left" valign="top"><select name="number_of_employees" id="number_of_employees">
<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">International Headquarters at:</td>
<td align="left" valign="top"><input name="international_headquarters" type="text" id="international_headquarters" /></td>
</tr>
<tr>
<td align="left" valign="top">Corporate Address:</td>
<td align="left" valign="top"><input name="corporate_address" type="text" id="corporate_address" /></td>
</tr>
<tr>
<td align="left" valign="top">State:</td>
<td align="left" valign="top"><input name="state" type="text" id="state" /></td>
</tr>
<tr>
<td align="left" valign="top">City/Town:</td>
<td align="left" valign="top"><input name="town" type="text" id="town" /></td>
</tr>
<tr>
<td align="left" valign="top">Zip/Pin Code:</td>
<td align="left" valign="top"><input 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"><select name="indian_office" id="indian_office">
<option value="yes">yes</option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Corporate
Phone Numbers:</td>
<td align="left" valign="top"><input name="corporate_phone_number" type="text" id="corporate_phone_number" /></td>
</tr>
<tr>
<td align="left" valign="top">Website:</td>
<td align="left" valign="top"><select name="website" id="website">
<option selected="selected">www.sparkleminds.com</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Mobile Number:</td>
<td align="left" valign="top"><input name="mobile_number" type="text" id="mobile_number" /></td>
</tr>
<tr>
<td align="left" valign="top">Director/CEO Name<span class="style1">*</span>:</td>
<td align="left" valign="top"><input name="ceo_name" type="text" id="ceo_name" /></td>
</tr>
<tr>
<td align="left" valign="top">Franchise Head:</td>
<td align="left" valign="top"><input name="franchise_head" type="text" id="franchise_head" /></td>
</tr>
<tr>
<td align="left" valign="top">Total Investment:</td>
<td align="left" valign="top"><select name="total_inverstment" id="total_inverstment">
<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;10000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Franchise Fee/Any Non Refundable Fee:</td>
<td align="left" valign="top"><table width="100%" border="0"cellpadding="3" cellspacing="0">
<tr>
<td width="32%" align="center"><strong>In US$</strong></td>
<td width="68%" align="left"><strong>In Indian Rupee</strong></td>
</tr>
<tr>
<td align="center"><select name="feein_dollers" id="feein_dollers">
<option>No Franchise Fee</option>
<option>50,000-1,00,000</option>
<option>1,00,000-2,00,000</option>
<option>2,00,000-3,00,000</option>
<option>3,00,000-5,00,000</option>
<option>5,00,000-8,00,000</option>
<option>8,00,000-10,00,000</option>
<option>10,00,000-20,00,000</option>
<option>20,00,000-30,00,000</option>
<option>30,00,000-50,00,000</option>
<option>Greater Than 50,00,000</option>
</select></td>
<td align="left"><input name="feein_rupees" type="text" id="feein_rupees" size="12" /></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Space In Sq Ft:</td>
<td align="left" valign="top"><select 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>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 height="125" align="left" valign="top"><table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="9%"><input name="no_of_hours" type="radio" value="hours1" /></td>
<td width="91%">Part Time&lt;20 Hrs A Week 1/4 Time</td>
</tr>
<tr>
<td><input name="no_of_hours" type="radio" value="hours2" /></td>
<td>2/4th Time 20-30 Hrs A Week </td>
</tr>
<tr>
<td><input name="no_of_hours" type="radio" value="hours3" /></td>
<td>3/4th Time 30-40 Hrs A Week </td>
</tr>
<tr>
<td><input name="no_of_hours" type="radio" value="hours4" /></td>
<td>Full Time. (40+ Hrs/Week)</td>
</tr>
<tr>
<td><input name="no_of_hours" type="radio" value="hours5" /></td>
<td>Not required to be present.</td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">Franchisees Presently Available At<span class="style1">*:</span></td>
<td align="left" valign="top"><select name="present_franchise" id="present_franchise">
<option value="india">India</option>
<option value="pakistan">Pakistan</option>
<option value="america">America</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Seeking Franchisees In India At:(Press Ctrl + Down Key To Choose The Exact Locations):</td>
<td align="left" valign="top"><select name="franchiseesinindia" id="franchiseesinindia">
<option value="bangalore">Bangalore</option>
<option value="mysore">Mysore</option>
<option value="hassan">Hassan</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Industry<span class="style1">*</span>:</td>
<td align="left" valign="top"><select name="industry" id="industry">
<option value="logicshore">logicshore</option>
<option value="infosys">Infosys</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Segment Within Industry<span class="style1">*</span>:</td>
<td align="left" valign="top"><select name="segment" id="segment">
<option value="a">a</option>
<option value="b">b</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top"><strong>Multiple Formats</strong></td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">Do You Operate Multiple Franchise Models:</td>
<td align="left" valign="top"><select name="multiple_models" id="multiple_models">
<option value="yes">yes</option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Mention The Number Of Models You Have:</td>
<td align="left" valign="top"><select name="no_of_models" id="no_of_models">
<option>1-3</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Total Investment:</td>
<td align="left" valign="top"><select name="total_investment" id="total_investment">
<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="greaterthan10000">&gt;10000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Franchise Fee/Any Non Refundable Fee:</td>
<td align="left" valign="top"><select name="fees" id="fees">
<option value="nofranchisefee">No Franchise Fee</option>
<option value="50,000-1,00,000">50,000-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,000-20,00,000">10,00,000-20,00,000</option>
<option value="20,00,000-30,00,000">20,00,000-30,00,000</option>
<option value="30,00,000-50,00,000">30,00,000-50,00,000</option>
<option value="Greater Than 50,00,000">Greater Than 50,00,000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Space In Sq Ft:</td>
<td align="left" valign="top"><select 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;100000">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"><table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7%"><input 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">Summary Within 5 Sentences<span class="style1">*</span>:</td>
<td align="left" valign="top"><textarea name="summary" cols="30" rows="5" id="summary"></textarea></td>
</tr>
<tr>
<td align="left" valign="top">How many franchisees do you presently have in India:</td>
<td align="left" valign="top"><select name="in_india" id="in_india">
<option value="none">none</option>
<option value="lessthan5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between16-30">Between16-30</option>
<option value="between31-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">How many franchisees do you have across the world:</td>
<td align="left" valign="top"><select name="across_world" id="across_world">
<option value="yes">Yes</option>
<option value="lessthan5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between16-30">Between16-30</option>
<option value="between31-100">Between 31-100</option>
<option value="morethan100">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;1000</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">How many company owned outlets do you have:</td>
<td align="left" valign="top"><select name="owned_outlets" id="owned_outlets">
<option value="none">none</option>
<option value="lessthan5">Less than 5</option>
<option value="between5-15">Between 5-15</option>
<option value="between16-30">Between16-30</option>
<option value="between31-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">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><strong>Franchise/Business Suitability</strong></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">Is your franchise/Business Opportunity suitable for Women:</td>
<td align="left" valign="top"><select 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"><select name="senior_citizen" id="senior_citizen">
<option value="yes">yes</option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><table width="96%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" valign="top"><input name="low_cost_franchise" type="checkbox" id="low_cost_franchise" value="low_cost_franchise" />
&nbsp;&nbsp;&nbsp;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">&nbsp;</td>
<td width="78%"><table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="5%"><input name="franchise_budget" type="radio" value="budget1" /></td>
<td width="95%">Below 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">Can 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"><select 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"><table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="7%"><input name="high_investment" type="checkbox" id="high_investment" value="high_investment" /></td>
<td width="93%">Capital 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"><select name="international_franchisor" id="international_franchisor">
<option value="yes">yes</option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">Are you seeking Master/Multiple franchisees</td>
<td align="left" valign="top"><select name="master_franchisees" id="master_franchisees">
<option value="yes">yes</option>
<option value="no">no</option>
</select></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td colspan="2" align="left" valign="top"><strong>Franchise Information:</strong></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">Training/Marketing/Other Support:</td>
<td align="left" valign="top"><input name="training" type="text" id="training" /></td>
</tr>
<tr>
<td align="left" valign="top">Top 5 Frequently Asked Q of your Opportunity:</td>
<td align="left" valign="top"><input name="faq" type="text" id="faq" /></td>
</tr>
<tr>
<td align="left" valign="top">Who is your Ideal Franchisee?What is it that you seek from the franchisee?:</td>
<td align="left" valign="top"><input name="ideal_franchisee" type="text" id="ideal_franchisee" /></td>
</tr>

<tr>
<td align="left" valign="top">Franchisee Testimonials:</td>
<td align="left" valign="top"><input name="testimonial" type="text" id="testimonial" /></td>
</tr>
<tr>
<td align="left" valign="top">Company News/Press Releases:</td>
<td align="left" valign="top"><input name="news" type="text" id="news" /></td>
</tr>
<tr>
<td align="left" valign="top">Photographs:</td>
<td align="left" valign="top"><input name="photos" type="text" id="photos" /></td>
</tr>
<tr>
<td align="left" valign="top">Video:</td>
<td align="left" valign="top"><input name="videos" type="text" id="videos" /></td>
</tr>
<tr>
<td align="left" valign="top">Property 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">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
</table>



PLEASE ANYONE HELP ME. I M FRESHER IN PHP
Sep 6 '10 #1
1 3465
before inserting any values check if it is null/empty then create SQL accordingly.
eg,

Expand|Select|Wrap|Line Numbers
  1. if(!isset($_REQUEST['franchise_hours']) || $_REQUEST['franchise_hours']=="" )
  2.    $franchise_hours; = "''";
Use this in the SQL.
Sep 6 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: David | last post by:
Hi, May I know how to create data dynamically in a combo box after clicking on a radio button ? Data are retrieved using a store procedure from a SQL Server. For example : Click Radio Button...
4
by: Jared | last post by:
Radio Button or Check Box and Event Procedures I need to insert either radio buttons or check boxes onto my form. I'm not sure which to use, or if there are other options. I am using the buttons...
6
by: Orchid | last post by:
I have 2 fields with Radio button Data Type, and both fields with more than one options. On Field1, I want the user to select option1, then Field2 is shown and able to select. If the user selects...
14
by: Steve Chatham | last post by:
I have a combo box that gets populated with a group of items based on a sql table. I had in mind that I'd insert a value at the beginning of that combo box, that'd say "No Item Selected" and...
1
sanjay123456
by: sanjay123456 | last post by:
Dear Sir If i am working on sql.php and i am taking radio button forr option of question the i donot understand that when a user click any radio button then how i compre to answer ...
10
by: IchBin | last post by:
I am trying to set the state of a radio button. I do not see what I am doing wrong. Sorry, I am new at this.. I need another set of eyes to look at this snip of code. I am trying to set the radio...
1
by: Jerim79 | last post by:
I have a simple 3 page registration form. One form, one "data validation" script and one "insert into database" script. The customer bounces back and forth from the form to the verification script...
5
by: Fran Jakers | last post by:
Hello all, I'm new to all this and I could really use some help. I've searched the web but cannot find an answer. I have an HTML form with 3 radio buttons and a search field that calls a...
8
by: ilikephp | last post by:
hello. when I am creating a form using the PHP language, everything is going fine and I have the data stored in the sql database, But when I add some radio button for example: <body>...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.