[RESOLVED] Error when run this code nippet!

[spiritssight]

Hello,

I am now almost done with getting my code to work for the filtering of the database, but there a issue that gives the below error, also I have attached the full file to the post if you want to see the whole thing:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

What would cause this error?

count_3 = 0

if ($count_3 == 0)
				{
				echo "There was no record found in the table \"allow\", we are now checking if record ". $i ." matchs the required criteria!<br />";
				$query_is = "INSERT INTO irs_query SELECT * FROM irs_rawdata WHERE EIN = '$fin'";
				$result_is = mysql_query($query_is) OR die("Sorry was unable to insert and select the records from the db table irs_rawdata! <br />" . mysql_error());
				$query_d = "DELETE FROM irs_rawdata WHERE EIN = '$fin'";
				$result_d = mysql_query($query_d) OR die("Was unable delete ". $fin ." from the db table irs_rawdata! <br />" . mysql_error());
				$count_4 = mysql_num_rows($result_is) OR die("Was unable to get number of rows");

				if ($count_4 == 0)
				{
                                    echo "this area works when I set the var for \$count_3 = 1";
				}
			}
			else
			{
			echo "There was one record found in the table \"allow\", we are now adding it to \"irs_query\" and deleted it from \"irs_rawdata\"!<br />";
			$query_d = "DELETE FROM irs_rawdata WHERE EIN = '$fin'";
			$result_d = mysql_query($query_d) OR die("Was unable delete ".$fin." from the db table irs_rawdata! <br />" . mysql_error());
			}

Sincerely,
Christopher

[NogDog]

Is there anything relevant in the server error log?

[spiritssight]

Hello all and NogDog

I have somehow only get that error now with the use of:
also if I block these lines with // then the script works fine (strange) I do need to know if the record that its looking at is inserted or not to know if script needs to go to the next part

ine # 55: $count_4_is = mysql_affected_rows($result_is) OR die("Was
unable to get number of rows");
line # 59: $count_4_d = mysql_affected_rows($result_d) OR die("Was
unable to get number of rows");

see full file attached to know where and whats around and what these line do

I don't know about the server log or for the fact of where that would be, what folder etc if you know for CentOS then I could look.

Thanks for the help!
Christopher

[spiritssight]

Ok, I was doing my code wrong

I was putting var in side the () and that was making it not work I guess.

Now that I got it to tell me 1 I need it to say if its 0 or is there a way to get my if() to work with this by doing if true do ... else do ...

Sincerely,
Christopher