sql error
Posted: Sun Jan 25, 2004 3:34 pm
I'm getting the following error...
Column count doesn't match value count at row 1
here is the code for the form html:
here is the code for the php:
Please help!
Column count doesn't match value count at row 1
here is the code for the form html:
Code: Select all
<select name="venture_name">
<option value="1">Joint Venture</option>
<option value="2">Link Exchange</option>
<option value="3">Customer Exchange</option>
<option value="4">Banner Exchange</option>
<option value="5">Advertising Exchange</option>
<option value="6">Offer to Advertise</option>
<option value="7">Offer to Accept Ads</option>
<option value="8">Feature / Technology / Code Exchange</option>
<option value="9">Service / Product Exchange</option>
<option value="10">Resource Exchange</option>
</select>Code: Select all
$venture_name = $_POSTї'venture_name'];
$result = mysql_query("SELECT venture_id FROM venture_master WHERE venture_type = '$venture_name' ", $linkid)
or die("Query failed: " . mysql_error());
while ($row = mysql_fetch_row($result))
{
$venture_id = $rowї'venture_id'];
}