i've created a php script for insert new row in mysql database.
newad.php
mysql table(exported .sql from my db)
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- phpMyAdmin
--
-- Host: localhost
-- Generation Time: Oct 19, 2011 at 03:33 PM
-- Server version: 5.0.92
-- PHP Version: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `freewets_eselling`
--
-- --------------------------------------------------------
--
-- Table structure for table `nkt_eselling`
--
CREATE TABLE IF NOT EXISTS `nkt_eselling` (
`id` int(100) NOT NULL auto_increment,
`category` varchar(500) NOT NULL default '',
`brand` varchar(500) NOT NULL default '',
`vehical` varchar(500) NOT NULL default '',
`location` varchar(500) NOT NULL default '',
`price` varchar(500) NOT NULL default '',
`transmission` varchar(500) NOT NULL default '',
`model` varchar(500) NOT NULL default '',
`condition` varchar(500) NOT NULL default '',
`description` varchar(500) NOT NULL default '',
`antime` int(100) NOT NULL default '0',
`img` varchar(500) NOT NULL,
`exdate` date NOT NULL,
`model_year` varchar(100) NOT NULL,
`milage` varchar(100) NOT NULL,
`engine_volume` varchar(100) NOT NULL,
`fuel_type` varchar(100) NOT NULL,
`door` int(10) NOT NULL,
`exterior_color` varchar(100) NOT NULL,
`drive_type` varchar(100) NOT NULL,
`safety` varchar(500) NOT NULL,
`comfort` varchar(500) NOT NULL,
`system` varchar(500) NOT NULL,
`valiidate` int(10) NOT NULL,
`img1` varchar(100) NOT NULL,
`img2` varchar(100) NOT NULL,
`img3` varchar(100) NOT NULL,
`img4` varchar(100) NOT NULL,
`img5` varchar(100) NOT NULL,
`img6` varchar(100) NOT NULL,
`img7` varchar(100) NOT NULL,
`keyword` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION */;
when im giong to run this it says 'HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while'
Is there something wrong in my code?
newad.php
PHP Code:
<!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>
<title>insert new ad</title><script type="text/javascript"><!--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_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_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><style type="text/css"><!--#form1 table tr th { text-align: right;}#form1 table { text-align: right; font-weight: bold;}body { background-image: url(../images/home_page/background_home.gif);}--></style></head><body onload="MM_preloadImages('../images/logo/logoR.jpg')"><p><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image1','','../images/logo/logoR.jpg',1)"><img src="http://coding-talk.com/f14/images/logo/logo.jpg" name="Image1" width="150" height="104" border="0" id="Image1" /></a> <img src="http://coding-talk.com/f14/images/logo/theme.jpg" width="500" height="105" hspace="125" /></p>
<?php$athora = mysql_connect('localhost','freewets_esellin','esellin');if(!$athora){ die ('Error! server not responding'); }$dbname = 'freewets_eselling';mysql_select_db($dbname, $athora);$go=$_GET['go'];if($go=="done"){$condition=mysql_real_escape_string($_POST['condition']);$S_V_VEHICLE_TYPE=mysql_real_escape_string($_POST['S_V_VEHICLE_TYPE']);$S_V_MAKECD=mysql_real_escape_string($_POST['S_V_MAKECD']);$model=mysql_real_escape_string($_POST['model']);$model_year=mysql_real_escape_string($_POST['model_year']);$milage=mysql_real_escape_string($_POST['milage']);$milageradio=mysql_real_escape_string($_POST['milageradio']);$engine_volume=mysql_real_escape_string($_POST['engine_volume']);$S_V_TRANSMISSIONCD=mysql_real_escape_string($_POST['S_V_TRANSMISSIONCD']);$S_V_FUEL_TYPECD=mysql_real_escape_string($_POST['S_V_FUEL_TYPECD']);$S_V_DOORCD=mysql_real_escape_string($_POST['S_V_DOORCD']);$price=mysql_real_escape_string($_POST['price']);$exterior_color=mysql_real_escape_string($_POST['exterior_color']);$S_V_DRIVE_TYPECD=mysql_real_escape_string($_POST['S_V_DRIVE_TYPECD']);$CH_V_OPTIONCD1=mysql_real_escape_string($_POST['CH_V_OPTIONCD1']);$CH_V_OPTIONCD2=mysql_real_escape_string($_POST['CH_V_OPTIONCD2']);$CH_V_OPTIONCD3=mysql_real_escape_string($_POST['CH_V_OPTIONCD3']);$CH_V_OPTIONCD4=mysql_real_escape_string($_POST['CH_V_OPTIONCD4']);$CH_V_OPTIONCD5=mysql_real_escape_string($_POST['CH_V_OPTIONCD5']);$CH_V_OPTIONCD6=mysql_real_escape_string($_POST['CH_V_OPTIONCD6']);$CH_V_OPTIONCD7=mysql_real_escape_string($_POST['CH_V_OPTIONCD7']);
$CH_V_OPTIONCD21=mysql_real_escape_string($_POST['CH_V_OPTIONCD21']);$CH_V_OPTIONCD22=mysql_real_escape_string($_POST['CH_V_OPTIONCD22']);$CH_V_OPTIONCD23=mysql_real_escape_string($_POST['CH_V_OPTIONCD23']);$CH_V_OPTIONCD24=mysql_real_escape_string($_POST['CH_V_OPTIONCD24']);$CH_V_OPTIONCD25=mysql_real_escape_string($_POST['CH_V_OPTIONCD25']);$CH_V_OPTIONCD26=mysql_real_escape_string($_POST['CH_V_OPTIONCD26']);$CH_V_OPTIONCD27=mysql_real_escape_string($_POST['CH_V_OPTIONCD27']);$CH_V_OPTIONCD28=mysql_real_escape_string($_POST['CH_V_OPTIONCD28']);$CH_V_OPTIONCD29=mysql_real_escape_string($_POST['CH_V_OPTIONCD29']);$CH_V_OPTIONCD210=mysql_real_escape_string($_POST['CH_V_OPTIONCD210']);$CH_V_OPTIONCD211=mysql_real_escape_string($_POST['CH_V_OPTIONCD211']);$CH_V_OPTIONCD212=mysql_real_escape_string($_POST['CH_V_OPTIONCD212']);
$CH_V_OPTIONCD213=mysql_real_escape_string($_POST['CH_V_OPTIONCD213']);$CH_V_OPTIONCD214=mysql_real_escape_string($_POST['CH_V_OPTIONCD214']);$CH_V_OPTIONCD215=mysql_real_escape_string($_POST['CH_V_OPTIONCD215']);$CH_V_OPTIONCD216=mysql_real_escape_string($_POST['CH_V_OPTIONCD216']);$CH_V_OPTIONCD217=mysql_real_escape_string($_POST['CH_V_OPTIONCD217']);$CH_V_OPTIONCD218=mysql_real_escape_string($_POST['CH_V_OPTIONCD218']);$CH_V_OPTIONCD219=mysql_real_escape_string($_POST['CH_V_OPTIONCD219']);$CH_V_OPTIONCD220=mysql_real_escape_string($_POST['CH_V_OPTIONCD220']);$CH_V_OPTIONCD2=mysql_real_escape_string($_POST['CH_V_OPTIONCD2']);$CH_V_OPTIONCD31=mysql_real_escape_string($_POST['CH_V_OPTIONCD31']);$CH_V_OPTIONCD32=mysql_real_escape_string($_POST['CH_V_OPTIONCD32']);$CH_V_OPTIONCD33=mysql_real_escape_string($_POST['CH_V_OPTIONCD33']);$CH_V_OPTIONCD34=mysql_real_escape_string($_POST['CH_V_OPTIONCD34']);$CH_V_OPTIONCD35=mysql_real_escape_string($_POST['CH_V_OPTIONCD35']);
$location=mysql_real_escape_string($_POST['location']);$category=mysql_real_escape_string($_POST['category']);$exdatee=mysql_real_escape_string($_POST['exdate']);$exdate=time()+($exdatee);$validate=mysql_real_escape_string($_POST['validate']);$keyword=mysql_real_escape_string($_POST['keyword']);$img1=mysql_real_escape_string($_POST['img1']);$img2=mysql_real_escape_string($_POST['img2']);$img3=mysql_real_escape_string($_POST['img3']);$img4=mysql_real_escape_string($_POST['img4']);$img5=mysql_real_escape_string($_POST['img5']);$img6=mysql_real_escape_string($_POST['img6']);$img7=mysql_real_escape_string($_POST['img7']);$img=mysql_real_escape_string($_POST['img']);
mysql_query("INSERT INTO nkt_eselling SET condition='$condition',vihical='$S_V_VEHICLE_TYPE',brand='$S_V_MAKECD',model='$model',model_year='$model_year',milage='$milage $milageradio',engine_volume'$engine_volume',transmission='$S_V_TRANSMISSIONCD',fuel_type='$S_V_FUEL_TYPECD',door='$S_V_DOORCD',price='$price',exterior_color='$exterior_color',driver_type='$S_V_DRIVE_TYPECD',safety='$CH_V_OPTIONCD1 $CH_V_OPTIONCD2 $CH_V_OPTIONCD3 $CH_V_OPTIONCD4 $CH_V_OPTIONCD5 $CH_V_OPTIONCD6 $CH_V_OPTIONCD7',comfort='$CH_V_OPTIONCD2 $CH_V_OPTIONCD21 $CH_V_OPTIONCD22 $CH_V_OPTIONCD23 $CH_V_OPTIONCD24 $CH_V_OPTIONCD25 $CH_V_OPTIONCD26 $CH_V_OPTIONCD27 $CH_V_OPTIONCD28 $CH_V_OPTIONCD29 $CH_V_OPTIONCD210 $CH_V_OPTIONCD211 $CH_V_OPTIONCD212 $CH_V_OPTIONCD213 $CH_V_OPTIONCD214 $CH_V_OPTIONCD215 $CH_V_OPTIONCD216 $CH_V_OPTIONCD217 $CH_V_OPTIONCD218 $CH_V_OPTIONCD219 $CH_V_OPTIONCD220',system='$CH_V_OPTIONCD31 $CH_V_OPTIONCD32 $CH_V_OPTIONCD33 $CH_V_OPTIONCD34 $CH_V_OPTIONCD35',location='$location',antime'".time()."',exdate'$exdate',validate='$validate',keyword='$keyword',img='$img',img1='$img1',img2='$img2',img3='$img3',img4='$img4',img5='$img5',img6='$img6',img7='$img7',img8='$img8',") or die ('Error!'.mysql_error());
echo"Ad was add successfully. Check if its showing correctly";}
?>
<form id="form1" name="form1" method="post" action="newad.php?go=done"> <table width="800" border="0" cellpadding="6"> <tr> <th width="132" scope="col"><div align="right">Condition</div></th> <th width="632" scope="col"><div align="left"> <input type="radio" name="condition" id="registered" value="registered" /> <label for="registered">Condition</label> <input type="radio" name="condition" id="unregisterd" value="unregisterd" /> <label for="unregisterd">Unregisterd</label> <input type="radio" name="condition" id="brand_new" value="brand_new" /> <label for="brand_new">Brand New</label> </div></th> </tr> <tr> <td><div align="right">Vehicle Type</div></td> <td align="left"><select name="S_V_VEHICLE_TYPE" onchange="check_vehicle_type();"> <option value="">--Select--</option> <option value="any">Any</option> <option value="bus">Bus</option> <option value="car">Car</option> <option value="cab">Cab</option> <option value="jeep">Jeep</option> <option value="truck/lorry">Truck/Lorry</option> <option value="van">Van</option> <option value="wagon">Wagon</option> </select></td> </tr> <tr> <td><div align="right">Make</div></td> <td><div align="left"><span class="tdTxt2"> <select name="S_V_MAKECD" onchange="check_mfr();"> <option value="">--Select--</option> <option value="audi">Audi</option> <option value="bmw">BMW</option> <option value="chevrolet">Chevrolet</option> <option value="daihatsu">Daihatsu</option> <option value="fiat">Fiat</option> <option value="ford">Ford</option> <option value="honda">Honda</option> <option value="hyundai">Hyundai</option> <option value="isuzu">Isuzu</option> <option value="jaguar">Jaguar</option> <option value="kia">Kia</option> <option value="land_rover">Land Rover</option> <option value="mazda">Mazda</option> <option value="mecedes_benz">Mecedes Benz</option> <option value="mitsubishi">Mitsubishi</option> <option value="nissan">Nissan</option> <option value="peugeot">Peugeot</option> <option value="micro">Micro</option> <option value="subaru">Subaru</option> <option value="suzuki">Suzuki</option> <option value="tata">Tata</option> <option value="toyota">Toyota</option> <option value="volkswagon">Volkswagon</option> <option value="volvo">Volvo</option> <option value="others">Others</option> </select> </span></div></td> </tr> <tr> <td><div align="right"> <label for="model">Model</label> </div></td> <td><div align="left"> <input type="text" name="model" id="model" /> </div></td> </tr> <tr> <td><div align="right"> <label for="model_year">Model Year</label> </div></td> <td><div align="left"> <input type="text" name="model_year" id="model_year" /> </div></td> </tr> <tr> <td><div align="right"> <label for="milage">Milage</label> </div></td> <td><div align="left"> <input type="text" name="milage" id="milage" /> <input type="radio" name="radio" id="k.m" value="k.m" /> <label for="k.m">K.m</label> <input type="radio" name="radio" id="mile" value="mile" /> <label for="mile">Mile</label> </div></td> </tr> <tr> <td><label for="engine_volume">Engine Volume</label></td> <td><div align="left"> <input type="text" name="engine_volume" id="engine_volume" /> CC</div></td> </tr> <tr> <td><div align="right">Transmission</div></td> <td><div align="left"> <select name="S_V_TRANSMISSIONCD"> <option value="">--Select--</option> <option value="automatic">Automatic</option> <option value="manual">Manual</option> <option value="automanual">Automanual</option> </select> </div></td> </tr> <tr> <td><div align="right">Fuel Type</div></td> <td><div align="left"> <select name="S_V_FUEL_TYPECD"> <option value="">--Select--</option> <option value="gasoline">Gasoline</option> <option value="diesel">Diesel</option> <option value="petrol">Petrol</option> <option value="electric">Electric</option> <option value="hybrid_electric">Hybrid-Electric</option> </select> </div></td> </tr> <tr> <td><div align="right">Door</div></td> <td><div align="left"> <select name="S_V_DOORCD"> <option value="">--Select--</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </div></td> </tr> <tr> <td><div align="right"> <label for="price">Price</label> </div></td> <td><div align="left"> <input type="text" name="price" id="price" /> Rs. (You don't need to input the price if you don't want to)</div></td> </tr> <tr> <td><div align="right"> <label for="exterior_color">Exterior Color</label> </div></td> <td><div align="left"> <input type="text" name="exterior_color" id="exterior_color" /> </div></td> </tr> <tr> <td><div align="right">Drive Type</div></td> <td><div align="left"> <select name="S_V_DRIVE_TYPECD"> <option value="">--Select--</option> <option value="all_wheel_drive">All Wheel Drive</option> <option value="2_wheel_drive">2 Wheel Drive</option> <option value="4_wheel_drive">4 Wheel Drive</option> <option value="unspecific">Unspecific</option> </select> </div></td> </tr> <tr> <td valign="top"><div align="right">Safety</div></td> <td><div align="left"> <ul class="optBox"> <li> <input type="checkbox" name="CH_V_OPTIONCD1" value="ABS" class="check salChe" /> ABS</li> <li> <input type="checkbox" name="CH_V_OPTIONCD2" value="Passenger Airbag" class="check salChe" /> Passenger Airbag</li> <li> <input type="checkbox" name="CH_V_OPTIONCD3" value="Alloy Wheels" class="check salChe" /> Alloy Wheels</li> <li> <input type="checkbox" name="CH_V_OPTIONCD4" value="Rear Camera" class="check salChe" /> Rear Camera</li> <li> <input type="checkbox" name="CH_V_OPTIONCD5" value="Single Airbag" class="check salChe" /> Single Airbag</li> <li> <input type="checkbox" name="CH_V_OPTIONCD6" value="Dual Airbag" class="check salChe" /> Dual Airbag</li> <li> <input type="checkbox" name="CH_V_OPTIONCD7" value="Auto Shift Lock" class="check salChe" /> Auto Shift Lock</li> </ul> </div></td> </tr> <tr> <td valign="top"><div align="right">Comfort</div></td> <td><div align="left"> <ul class="optBox"> <li> <input type="checkbox" name="CH_V_OPTIONCD2" value="A/C:front" class="check salChe" /> A/C:front</li> <li> <input type="checkbox" name="CH_V_OPTIONCD22" value="A/C:rear" class="check salChe" /> A/C:rear</li> <li> <input type="checkbox" name="CH_V_OPTIONCD23" value="Adjustable Seat" class="check salChe" /> Adjustable Seat</li> <li> <input type="checkbox" name="CH_V_OPTIONCD24" value="Digital Meter" class="check salChe" /> Digital Meter</li> <li> <input type="checkbox" name="CH_V_OPTIONCD25" value="Full Auto Airconditioner" class="check salChe" /> Full Auto Airconditioner</li> <li> <input type="checkbox" name="CH_V_OPTIONCD26" value="Heating Seat" class="check salChe" /> Heating Seat</li> <li> <input type="checkbox" name="CH_V_OPTIONCD27" value="Leather Seats" class="check salChe" /> Leather Seats</li> <li> <input type="checkbox" name="CH_V_OPTIONCD28" value="Power Door Locks" class="check salChe" /> Power Door Locks</li> <li> <input type="checkbox" name="CH_V_OPTIONCD29" value="Power Steering" class="check salChe" /> Power Steering</li> <li> <input type="checkbox" name="CH_V_OPTIONCD210" value="Power Mirrors" class="check salChe" /> Power Mirrors</li> <li> <input type="checkbox" name="CH_V_OPTIONCD211" value="Power Slide Door" class="check salChe" /> Power Slide Door</li> <li> <input type="checkbox" name="CH_V_OPTIONCD212" value="Power Windows" class="check salChe" /> Power Windows</li> <li> <input type="checkbox" name="CH_V_OPTIONCD213" value="Rear Window Defroster" class="check salChe" /> Rear Window Defroster</li> <li> <input type="checkbox" name="CH_V_OPTIONCD214" value="Rear Window Wiper" class="check salChe" /> Rear Window Wiper</li> <li> <input type="checkbox" name="CH_V_OPTIONCD215" value="Remote Keyless Entry" class="check salChe" /> Remote Keyless Entry</li> <li> <input type="checkbox" name="CH_V_OPTIONCD216" value="Sunroof" class="check salChe" /> Sunroof</li> <li> <input type="checkbox" name="CH_V_OPTIONCD217" value="Tinted Glass" class="check salChe" /> Tinted Glass</li> <li> <input type="checkbox" name="CH_V_OPTIONCD218" value="Smart Key" class="check salChe" /> Smart Key</li> <li> <input type="checkbox" name="CH_V_OPTIONCD219" value="Rear Spoiler" class="check salChe" /> Rear Spoiler</li> <li> <input type="checkbox" name="CH_V_OPTIONCD220" value="Roof Career" class="check salChe" /> Roof Career</li> </ul> </div></td> </tr> <tr> <td valign="top"><div align="right">System</div></td> <td><div align="left"> <ul class="optBox"> <li> <input type="checkbox" name="CH_V_OPTIONCD31" value="Navigation System" class="check salChe" /> Navigation System</li> <li> <input type="checkbox" name="CH_V_OPTIONCD32" value="AM/FM Stereo" class="check salChe" /> AM/FM Stereo</li> <li> <input type="checkbox" name="CH_V_OPTIONCD33" value="CD Player" class="check salChe" /> CD Player</li> <li> <input type="checkbox" name="CH_V_OPTIONCD34" value="DVD" class="check salChe" /> DVD</li> <li> <input type="checkbox" name="CH_V_OPTIONCD35" value="Rear Seat TV Monitor" class="check salChe" /> Rear Seat TV Monitor</li> </ul> </div></td> </tr> <tr> <td valign="top"><div align="right">Location</div></td> <td><div align="left"><input name="location" type="text" /> </div></td> </tr> <tr> <td valign="top"><div align="right">Category(sell=1 , rent=2)</div></td> <td><div align="left"><input name="category" type="text" /> </div></td> </tr> <tr> <td valign="top"><div align="right">Expire date</div></td> <td><div align="left"><input name="exdate" type="text" value="60*60*24*7" /> sec*mins*hours*days eg: if one week from now: 60*60*24*7 </div></td> </tr> <tr> <td valign="top"><div align="right">Validate(1=show ad, 0=dont show)</div></td> <td><div align="left"><input name="validate" type="text" value="1" /> </div></td> </tr> <tr> <td valign="top"><div align="right">Keywords</div></td> <td><div align="left"> <textarea name="keyword" cols="40" rows="10"></textarea> </div></td> </tr> <tr> <td valign="top"><div align="right">Imgs</div></td> <td><div align="left"><input name="img" type="text" value="/" size="40" /> <input name="img1" type="text" value="/" size="40" /> <input name="img2" type="text" value="/" size="40"/> <input name="img3" type="text" value="http://eselling.lk/images/carad/" size="40"/> <input name="img4" type="text" value="" size="40"/> <input name="img5" type="text" value="/" /> <input name="img6" type="text" value="" size="40"/><input name="img7" type="text" value="" size="40"/> Make sure allready uploaded the photos with ad id </div></td> </tr> <tr> <td><div align="right"> <label for="send_application"></label> <input type="submit" name="send_application" id="send_application" value="Send Application" /> </div></td> <td><div align="left"> <label for="reset_form"></label> <input type="reset" name="reset_form" id="reset_form" value="Reset Form" /> </div></td> </tr> </table></form></body></html>
mysql table(exported .sql from my db)
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- phpMyAdmin
--
-- Host: localhost
-- Generation Time: Oct 19, 2011 at 03:33 PM
-- Server version: 5.0.92
-- PHP Version: 5.2.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `freewets_eselling`
--
-- --------------------------------------------------------
--
-- Table structure for table `nkt_eselling`
--
CREATE TABLE IF NOT EXISTS `nkt_eselling` (
`id` int(100) NOT NULL auto_increment,
`category` varchar(500) NOT NULL default '',
`brand` varchar(500) NOT NULL default '',
`vehical` varchar(500) NOT NULL default '',
`location` varchar(500) NOT NULL default '',
`price` varchar(500) NOT NULL default '',
`transmission` varchar(500) NOT NULL default '',
`model` varchar(500) NOT NULL default '',
`condition` varchar(500) NOT NULL default '',
`description` varchar(500) NOT NULL default '',
`antime` int(100) NOT NULL default '0',
`img` varchar(500) NOT NULL,
`exdate` date NOT NULL,
`model_year` varchar(100) NOT NULL,
`milage` varchar(100) NOT NULL,
`engine_volume` varchar(100) NOT NULL,
`fuel_type` varchar(100) NOT NULL,
`door` int(10) NOT NULL,
`exterior_color` varchar(100) NOT NULL,
`drive_type` varchar(100) NOT NULL,
`safety` varchar(500) NOT NULL,
`comfort` varchar(500) NOT NULL,
`system` varchar(500) NOT NULL,
`valiidate` int(10) NOT NULL,
`img1` varchar(100) NOT NULL,
`img2` varchar(100) NOT NULL,
`img3` varchar(100) NOT NULL,
`img4` varchar(100) NOT NULL,
`img5` varchar(100) NOT NULL,
`img6` varchar(100) NOT NULL,
`img7` varchar(100) NOT NULL,
`keyword` varchar(500) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION */;
when im giong to run this it says 'HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while'
Is there something wrong in my code?
Comment