my db query too long?

[youdrovemetoit]

<?php
		if(isset($_POST["submit"])){

		// update level
		$LEVEL[old] = $_POST["level"];
		$LEVEL[name] = preg_replace("![^0-9]!","",$LEVEL[old]);
		if($LEVEL[old] !== $LEVEL[name]){
			$ADD[error] = "Level must only contain numbers (0-9)";
		}
		$LEVEL[description] = $_POST["description"];
		if($LEVEL[description] == ""){
			$ADD[error] = "Please enter a level description";
		}
		$LEVEL[lh] = $_POST["lh"];
		$LEVEL[tt] = $_POST["tt"];
		$LEVEL[faq] = $_POST["faq"];
		$LEVEL[departments] = $_POST["departments"];
		$LEVEL[operators] = $_POST["operators"];
		$LEVEL[lv] = $_POST["levels"];
		$LEVEL[stats] = $_POST["stats"];
		$LEVEL[transcripts] = $_POST["transcripts"];
		$LEVEL[view] = $_POST["view"];
		$LEVEL[add] = $_POST["add"];
		$LEVEL[edit] = $_POST["edit"];
		$LEVEL[delete] = $_POST["delete"];

		// Check to see if level exists
		$result_search = DATABASE_query("SELECT * FROM $DB[prefix]levels");
		while($search = DATABASE_fetch($result_search)){
			$SEARCH[level] = $search["level"];
			if($SEARCH[level] == $LEVEL[level]){
				$ADD[error] = "Level already exists";
			}
		}


		if(!isset($ADD[error])){
			DATABASE_query("INSERT INTO $DB[prefix]levels (level,description,lh,tt,faq,departments,operators,levels,stats,transcripts,add,view,edit,delete) VALUES ('$LEVEL[name]','$LEVEL[description]','$LEVEL[lh]','$LEVEL[tt]','$LEVEL[faq]','$LEVEL[departments]','$LEVEL[operators]','$LEVEL[lv]','$LEVEL[stats]','$LEVEL[transcripts]','$LEVEL[add]','$LEVEL[view]','$LEVEL[edit]','$LEVEL[delete]')");
			echo("<div align=\"center\">Level added</div>");
		}else{
			echo("<div align=\"center\">".$ADD[error]."</div>");
		}


	}else{
		//display form..

?>

What is wrong with this code.. there is a form that submits all the info and it returns 'Level Added' but the info is not actually put in the database. DATABASE_query is a function i have for querying the database and it is included into the script and works fine for all my other queries. This has been annoying me for hours!!!

Mike

[bad76]

Hi,
are you triing to output mysql_error() ?!?

To full debug use this:

echo $thisquery;
$result=mysql_query($thisquery) or die(mysql_error());

i hope this help...

[youdrovemetoit]

for some reason my host does not allow viewing of errors :S

[bad76]

Originally posted by youdrovemetoit
for some reason my host does not allow viewing of errors :S

😕 Are you sure? But you note is not a php error, is like an echo command... make a try...

And try to put at the start of your code error_reporting(E_ALL);

Else you have to install an apache/php/mysql on your pc... you can't program without view errors...

[youdrovemetoit]

ok i'll try.. i have put the error reporting to e_all and when there is an error it just shows a blank page.
I'll have to run it on fireserv and see

[youdrovemetoit]

ok ive run it on my local machine and got this error..

You have an error in your SQL syntax near 'add,view,edit,delete) VALUES ('5','jnyhdtrsk','0','0','0','0','0','0','0','0','0' at line 1

but to my knowledge the code is correct ?!

[youdrovemetoit]

'add' must be a reserved function.. i changed the query to add instead and it worked fine :rolleyes:

[SLAYeeK]

I think, what you need in redeclare your variables f.e.

$lv=$LEVEL[lv];

It's give you very easy query string.

You must not use symbols [ and ]. Only "easy" variables. MySQL cann't "understand" this symbols.

[youdrovemetoit]

i have had no problems with it understanding my variables such as $LEVEL[id] 😕

[bad76]

Originally posted by youdrovemetoit
ok ive run it on my local machine and got this error..

You have an error in your SQL syntax near 'add,view,edit,delete) VALUES ('5','jnyhdtrsk','0','0','0','0','0','0','0','0','0' at line 1

but to my knowledge the code is correct ?!

This tells you the error is "transcripts" field, or some just before...
look if exists and if it's right written.

You can also try this, if fields are in the same order of table:
"INSERT INTO $DB[prefix]levels VALUES ('$LEVEL[name]','$LEVEL[description]','$LEVEL[lh]', etc etc...)"

see you