[Is something limiting mysql_query INSERT INTO ~ I need help]

OK, I got it, it was simply the order of my table that has given me such a headache! I appreciate all of you guys time trying to help me and methodically reading my code. Thanks so much.

[Is something limiting mysql_query INSERT INTO ~ I need help]

Array

(

    [stk] => dsf

    [my] => sd

    [mak] => fds

    [mod] => fds

    [mil] => fds

    [pri] => fdsdfs

    [bst] => Cab Chasis

    [len] => sd

    [eng] => s

    [dor] => fds

    [tra] => sd

    [gvw] => sd

    [inc] => s

    [exc] => fds

    [cfo] => fdsfds

    [titl] => fds

    [desc] => fsd

    [vin] => fds

    [pic1] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic2] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic3] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic4] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic5] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic6] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic7] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic8] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

    [pic9] => 30-flat-panel-tft-lcd-cinema-hd-monitor.jpg

)

 

 

this is the return i get when I use

echo '<pre>',print_r($_GET,true),'</pre>'

[Is something limiting mysql_query INSERT INTO ~ I need help]

Ok, so I tested all of the variables coming through and infact they are. Next, i'll try the method PFMaBiSmAd suggest and i'll report back

[Is something limiting mysql_query INSERT INTO ~ I need help]

Yeah, that was going to be my next test, I knew there was a limit. I'll try and have it echo and return every variable and see what I get, i'll keep posted, thanks.

[Is something limiting mysql_query INSERT INTO ~ I need help]

Ok so here's my code first the ajax/javascript, secondly the php. Issue i'm having is that first it wasn't entering any data into my database then eventual through much troubleshooting I figured out that if I add more then 10 variables in my INSERT INTO query it wont work. Ten or less and it works perfect. I CAN NOT figure this out?! Note, at the bottom of the php script I have the script that I would like to work, commented out, and the script that is currently working, active. You can see it only has 10 working entries.

 

function entervehicle(){

var stk = document.getElementById("stk").value
var my = document.getElementById("my").value
var mak = document.getElementById("mak").value
var mod = document.getElementById("mod").value
var mil = document.getElementById("mil").value
var pri = document.getElementById("pri").value
var bst = document.getElementById("bst").value
var len = document.getElementById("len").value
var eng = document.getElementById("eng").value
var dor = document.getElementById("dor").value
var tra = document.getElementById("tra").value
var gvw = document.getElementById("gvw").value
var inc = document.getElementById("inc").value
var exc = document.getElementById("exc").value
var cfo = document.getElementById("cfo").value
var titl = document.getElementById("titl").value
var desc = document.getElementById("desc").value
var vin = document.getElementById("vin").value
var pic1 = document.getElementById("pic1").value
var pic2 = document.getElementById("pic2").value
var pic3 = document.getElementById("pic3").value
var pic4 = document.getElementById("pic4").value
var pic5 = document.getElementById("pic5").value
var pic6 = document.getElementById("pic6").value
var pic7 = document.getElementById("pic7").value
var pic8 = document.getElementById("pic8").value
var pic9 = document.getElementById("pic9").value


var linksubmit ="../php/entervehicle.php?stk=" + stk
										+"&my=" + my
										+"&mak=" + mak
										+"&mod=" + mod
										+"&mil=" + mil
										+"&pri=" + pri
										+"&bst=" + bst
										+"&len=" + len
										+"&eng=" + eng
										+"&dor=" + dor
										+"&tra=" + tra
										+"&gvw=" + gvw
										+"&inc=" + inc
										+"&exc=" + exc
										+"&cfo=" + cfo
										+"&titl=" + titl
										+"&desc=" + desc
										+"&vin=" + vin
										+"&pic1=" + pic1
										+"&pic2=" + pic2
										+"&pic3=" + pic3
										+"&pic4=" + pic4
										+"&pic5=" + pic5
										+"&pic6=" + pic6
										+"&pic7=" + pic7
										+"&pic8=" + pic8
										+"&pic9=" + pic9	

alert(linksubmit);
var entrequest = getHTTPObject();

if(entrequest)
{	
	entrequest.open("GET",linksubmit,true);
	entrequest.onreadystatechange = function(){
		entveh(entrequest);
	};
	entrequest.send(null);
}
}
function entveh(entrequest){
if(entrequest.readyState == 4){
	if(entrequest.status == 200){

		var myPHP = entrequest.responseText;
		document.getElementById("adminmain").innerHTML = myPHP;
	}
}
}

 

 

<?php

$stk = $_GET['stk'];
$my = $_GET['my'];
$mak = $_GET['mak'];
$mod = $_GET['mod'];
$mil = $_GET['mil'];
$pri = $_GET['pri'];
$bst = $_GET['bst'];
$len = $_GET['len'];
$eng = $_GET['eng'];
$dor = $_GET['dor'];
$tra = $_GET['tra'];
$gvw = $_GET['gvw'];
$inc = $_GET['inc'];
$exc = $_GET['exc'];
$cfo = $_GET['cfo'];
$titl = $_GET['titl'];
$desc = $_GET['desc'];
$vin = $_GET['vin'];
$pic1 = $_GET['pic1'];
$pic2 = $_GET['pic2'];
$pic3 = $_GET['pic3'];
$pic4 = $_GET['pic4'];
$pic5 = $_GET['pic5'];
$pic6 = $_GET['pic6'];
$pic7 = $_GET['pic7'];
$pic8 = $_GET['pic8'];
$pic9 = $_GET['pic9'];


require("database.php");


$tresult = mysql_query("INSERT INTO automobile_stat (stock_number,model_year, make, model, miles, price, body_style, length, description, trans)
VALUES ('$stk', '$my', '$mak', '$mod', '$mil', '$pri', '$bst', '$len', '$desc', '$tra')");

/*$tresult = mysql_query("INSERT INTO automobile_stat (stock_number, model_year, make, model, miles, price, body_style, length, description, engine, doors, trans, gvw, int_color, ext_color, car_fax_owner, title_desc, main_picture_src, vin)
VALUES ('$stk', '$my', '$mak', '$mod', '$mil', '$pri', '$mpri', '$bst', '$len', '$desc', '$eng', '$dor', 'tra', '$gvw', '$inc', '$exc', '$cfo', '$titl', 'img', '$vin')");*/

/*$tresult=mysql_query("SELECT * FROM automobile_stat" );
$countrows = mysql_num_rows($tresult);


while($row = mysql_fetch_array($tresult)){

echo $row[stock_number];

    }*/

mysql_close($linkID);

?>