Long query

Jeremias

I've got some problems with a long query:

	$query= "Insert into data (index, number, 1a, 1b, 2, 3, 41, 42, 43, 5, 61, 62, 63, 64, 64b, 7, 8, 91, 92, 93, bla, 10, 101a, 101b, 101c, 101d, 102a, "
		   ."102b, 102c, 102d, 103a, 103b, 104a, 104b, 104c, 104d, 105a, 105b, 106a, 106b, 107a, 107b, 108a, 108b, 108c, 108d, "
		   ."109a, 109b, 111a, 111b, 112a, 112b, 113, 12, 121, 122, 123a, 123b, 124, 13, 14, 15, 16a, 16b, 16c, 16d, 17a, 17b, 17c, 17d, "
		   ."181, 182, 183, 18a, 18b, 18c, 18d, 191, 192, 193, 19a, 19b, 19c, 19d, 19e, 19f, 19g, 19h, 201, 20a, 20b, 20c, 20d, 21a, 21b, 21c, "
		   ."21d, 22a, 22b, 22c, 22d, 231, 232, 233, 23a, 23b, 23c, 23d, 241, 242, 243, 24a, 24b, 24c, 24d, 25a, 25b, 25c, 25d, 26a, 26b, 26c, "
		   ."26d, 271, 27a, 27b, 27c, 27d, 28a, 28b, 28c, 28d, tca, tcb, amountrsa, amountrsb, 29, 30, 311a, 311b, 312a, 312b, 312c, 321a, "
		   ."322a, 322c, 33, 34, tcma, tcmb, amountrsma, amountrsmb, 35, 36, 37, 37a, 38, 38a, 39, 40a, 40b, 41a, 41b, Interviewer, datum)"
		   ." VALUES ( 1, '".$_POST['number']."', '".$_POST['1a']."','".$_POST['1b']."', '".$_POST['2']."', '".$_POST['3']."', '".$_POST['41']."', '".$_POST['42']."', '".$_POST['43']."', '".$_POST['5']."', '".$_POST['61']."',"
		   ."'".$_POST['62']."', '".$_POST['63']."', '".$_POST['64']."', , '".$_POST['64b']."' '".$_POST['7']."', '".$_POST['8']."', '".$_POST['91']."', '".$_POST['92']."', '".$_POST['93']."', '".$_POST['10']."',"
		   ."'".$_POST['101a']."', '".$_POST['101b']."', '".$_POST['101c']."', '".$_POST['101d']."', '".$_POST['102a']."', '".$_POST['102b']."', '".$_POST['102c']."', '".$_POST['102d']."',"
		   ."'".$_POST['103a']."', '".$_POST['103b']."', '".$_POST['104a']."', '".$_POST['104b']."', '".$_POST['104c']."', '".$_POST['104d']."', '".$_POST['105a']."', '".$_POST['105b']."',"
		   ."'".$_POST['106a']."', '".$_POST['106b']."', '".$_POST['107a']."', '".$_POST['107b']."', '".$_POST['108a']."', '".$_POST['108b']."', '".$_POST['108c']."', '".$_POST['108d']."'," 		  	
		   ."'".$_POST['109a']."', '".$_POST['109b']."', '".$_POST['111a']."', '".$_POST['111b']."', '".$_POST['112a']."', '".$_POST['112b']."', '".$_POST['113']."', '".$_POST['12']."',"
		   ."'".$_POST['121']."', '".$_POST['122']."', '".$_POST['123a']."', '".$_POST['123b']."', '".$_POST['124']."', '".$_POST['13']."', '".$_POST['14']."', '".$_POST['15']."', '".$_POST['16a']."',"
		   ."'".$_POST['16b']."', '".$_POST['16c']."', '".$_POST['16d']."', '".$_POST['17a']."', '".$_POST['17b']."', '".$_POST['17c']."', '".$_POST['17d']."', '".$_POST['181']."', '".$_POST['182']."',"
		   ."'".$_POST['183']."', '".$_POST['18a']."', '".$_POST['18b']."', '".$_POST['18c']."', '".$_POST['18d']."', '".$_POST['191']."', '".$_POST['192']."', '".$_POST['193']."', '".$_POST['19a']."',"
		   ."'".$_POST['19b']."', '".$_POST['19c']."', '".$_POST['19d']."', '".$_POST['19e']."', '".$_POST['19f']."', '".$_POST['19g']."', '".$_POST['19h']."', '".$_POST['201']."', '".$_POST['20a']."',"
		   ."'".$_POST['20b']."', '".$_POST['20c']."', '".$_POST['20d']."', '".$_POST['21a']."', '".$_POST['21b']."', '".$_POST['21c']."', '".$_POST['21d']."', '".$_POST['22a']."', '".$_POST['22b']."',"
		   ."'".$_POST['22c']."', '".$_POST['22d']."', '".$_POST['231']."', '".$_POST['232']."', '".$_POST['233']."', '".$_POST['23a']."', '".$_POST['23b']."', '".$_POST['23c']."', '".$_POST['23d']."',"
		   ."'".$_POST['241']."', '".$_POST['242']."', '".$_POST['243']."', '".$_POST['24a']."', '".$_POST['24b']."', '".$_POST['24c']."', '".$_POST['24d']."', '".$_POST['25a']."', '".$_POST['25b']."',"
		   ."'".$_POST['25c']."', '".$_POST['25d']."', '".$_POST['26a']."', '".$_POST['26b']."', '".$_POST['26c']."', '".$_POST['26d']."', '".$_POST['271']."', '".$_POST['27a']."', '".$_POST['27b']."',"
		   ."'".$_POST['27c']."', '".$_POST['27d']."', '".$_POST['28a']."', '".$_POST['28b']."', '".$_POST['28c']."', '".$_POST['28d']."', '".$_POST['tca']."', '".$_POST['tcb']."', '".$_POST['amountrsa']."',"
		   ."'".$_POST['amountrsb']."', '".$_POST['29']."', '".$_POST['30']."', '".$_POST['311a']."', '".$_POST['311b']."', '".$_POST['312a']."', '".$_POST['312b']."', '".$_POST['312c']."',"
		   ."'".$_POST['321a']."', '".$_POST['322a']."', '".$_POST['322c']."', '".$_POST['33']."', '".$_POST['34']."', '".$_POST['tcma']."', '".$_POST['tcmb']."', '".$_POST['amountrsma']."',"
		   ."'".$_POST['amountrsmb']."', '".$_POST['35']."', '".$_POST['36']."', '".$_POST['37']."', '".$_POST['37a']."', '".$_POST['38']."', '".$_POST['38a']."', '".$_POST['39']."', '".$_POST['40a']."',"
		   ."'".$_POST['40b']."', '".$_POST['41a']."', '".$_POST['41b']."', '".$_POST['Interviewer']."', '12/12/1200')";

I just can't enter data in my DB, should I split this or should this normaly work? 😕

Jeremias

bubblenut

What's the error it's throwing? You can check this with mysql_error(). If mysql_query() fails display query string and the error (this should be for testing only, you don't want your queries displayed to the world😉)
HTH
Bubble

Jeremias

I used mysql_error() and mysq_errno() and both functions don't give anny output 😕

edit: I tried to display the query and it looks normal.

Jeremias

bubblenut

Sorry if this is a really silly question, but are you actualy running the query?

if(mysql_query($query)) {
  echo('inserted');
} else {
  echo('Error: '.$query.' : '.mysql_error());
}

HTH
Bubble

Jeremias

Jep I'm running it 🙂
Anyhow I'm sick of it right now I'm gonna look into it tonight. I'll keep you guys updated 😉

Thx for the help

Jeremias

Something is clearly wrong even this query doesn't work:

$query="INSERT INTO data (index, number, 1a, 1b) Values ('10', '1212', '23', '12')";

But I can enter data in my database trough the mysql interface. The database connection is also Ok so what am I missing 😕

BooRadLey

only thing I can think of is:

$query="INSERT INTO data (index, number, 1a, 1b) VALUES (10, 1212, 23, 12)";

I think with single qoutes the values are interpreted as strings rather than integers, which I am guessing is your field type. This may help with your original problem, or I might be completely off 😃

Brad