HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while

    i've created a php script for insert new row in mysql database.


    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?
    Last edited by athora; 19.10.11, 19:50.

    #2
    you may need register globals on for it to work i know some servers you have too mine does

    Comment


      #3
      I changed code as
      PHP Code:
      mysql_query("INSERT INTO nkt_eselling ( category,brand,vehical,location,price,transmission,model,condition,description,antime,img,exdate,model_year,milage,engine_volume,fuel_type,door,exterior_color,driver_type,safety,comfort,system,validate,keyword,img1,img2,img3,img4,img5,img6,img7,img8) VALUES ('$category','$S_V_MAKECD','$S_V_VEHICLE_TYPE','$location','$price','$S_V_TRANSMISSIONCD','$model','$condition','','".time()."','$img','$exdate','$model_year','$milage $milageradio','$engine_volume','$S_V_FUEL_TYPECD','$S_V_DOORCD','$exterior_color','$S_V_DRIVE_TYPECD','$CH_V_OPTIONCD1 $CH_V_OPTIONCD2 $CH_V_OPTIONCD3 $CH_V_OPTIONCD4 $CH_V_OPTIONCD5 $CH_V_OPTIONCD6 $CH_V_OPTIONCD7','$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','$CH_V_OPTIONCD31 $CH_V_OPTIONCD32 $CH_V_OPTIONCD33 $CH_V_OPTIONCD34 $CH_V_OPTIONCD35','$validate','$keyword','$img1','$img2','$img3','$img4','$img5','$img6','$img7','$img8')") or die ('Error!'.mysql_error()); 
      and now im getting this error

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition,description,antime,img,exdate,model_yea r,milage,engine_volume,fuel_typ' at line 1

      Comment


        #4
        Maybe the VALUE of condition has an apostrophe, you must escape it before inserting it in your database
        libra.wen.ru

        Comment


          #5
          500 error from your htacesss

          Comment


            #6
            akela right..
            500 error from your htacesss

            Comment

            Working...
            X