Vermutliches Problem bei "Insert into"

latenight

Hallo erstmal, bin mir jetzt nicht sicher ob ich hier richtig bin oder nicht

ich denke aber mal eher hier als bei mysql

Zu meinem Problem:
Ich habe ein PHP script was ich einigermaßen anpassen musste,

Dabei geht es um ein User control panel für ein Spiel...
Darin sind verschiedene Fraktion aufgeführt wo es möglich ist sich bei genannten zu bewerben...wenn ich jetzt auf den Punkt bewerben gehe und die erforderlichen Daten eingebe und diese Bewerbung Absende kommt nichts in der Datenbank an...

Den genauen Fehler weiß ich jedoch nicht
Ich vermute dass im script der Bereich mit dem "insert into" nicht genügend gefüllt ist

Oder aber auch das mir spalten in der Datenbank fehlen ich habe dort momentan 6 spalten...ich bin mir nur nicht ganz sicher ob es alle nötigen sind

Hier mal der Code:

PHP

<?php	

	if ($_GET['do'] == 'settings')
	{
	if(isset($_SESSION['user']))
	{
		$fraktion = @mysql_result(@mysql_query("SELECT Leader FROM accounts where name='".$_SESSION['user']."'"), 0 );
		if($fraktion != 0)
		{
			$fraktion_leader = @mysql_result(@mysql_query("SELECT name FROM accounts where Leader='".$fraktion."'"), 0 );
			$fraktion_member_count = @mysql_num_rows(@mysql_query("SELECT * FROM accounts where member = '".$fraktion."'"));
			$fraktion_desc = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='".$fraktion."'"), 0 );
			$min_level = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='".$fraktion."'"), 0 );
			$application_stop = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='".$fraktion."'"), 0 );

			if(isset($_POST['submit']))
			{
				$set_desc = clean_it(nl2br($_POST['desc']));
				$set_min_level = clean_it($_POST['min_level']);
				$set_application_stop = clean_it($_POST['application_stop']);

				mysql_query("UPDATE `fraktion` SET description='$set_desc', min_level='$set_min_level', application_stop='$set_application_stop' WHERE id='$fraktion'");

				echo 'Erfolgreich gespeichert!';
			}


			echo '<fieldset><legend>'. fraktion($fraktion) .'</legend>
					<table class="fraktion">
					<form method="post">
						<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'. $fraktion_leader .'</td></tr>
						<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $fraktion_member_count .'</td></tr>
						<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td><select name="min_level"><option value="'. $min_level .'">'. $min_level .'</option><option value=""></option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select></td></tr>
						<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">Bewerbungsstop:</td><td><select name="application_stop"><option value="1">Ja</option><option value="2">Nein</option></select></td></tr>
						<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td><textarea name="desc">'. $fraktion_desc .'</textarea></td></tr>
						<tr><td class="key" width="120px"></td><td><input type="submit" name="submit" value="Save"></td></tr>
					</table>
					</form>
				</fieldset>';


				///// Bewerbungen /////
				$application = mysql_query("SELECT * FROM application where fraktion=". $fraktion ." AND done=1");
				while($application_table = @mysql_fetch_array($application)){
				echo '
					<style type="text/css">
						table#app td{border:1px solid #221d2c;}
					</style>
					<table id="app" width="50%">
						<tr><td class="key">Name</td><td class="key">Level</td><td class="key">Grund</td><td>Status</td></tr>
						<tr><td>'. $application_table['name'] .'</td><td>'. $application_table['level'] .'</td><td>'. $application_table['reason'] .'</td><td><a href="ajax.php?a=frakdone&frakid='. $application_table['id'] .'">Done</a></td></tr>
					</table>
				';
				}
		}
	}
	else
	{
		echo '<div class="fail">Du must eingelogt sein!</div>';
	}
	}
	else if($_GET['do'] == 'apply')
	{
	if(isset($_SESSION['user']))
	{
		$ausgabe = '';
			if(($_POST['send_application']))
			{
				$application_fraktion = clean_it($_POST['app_id']);
				$application_reason = clean_it($_POST['reason']);
				$application_name = clean_it($_SESSION['user']);
				$application_level = mysql_result(mysql_query("SELECT level FROM accounts where name='". $_SESSION['user'] ."'"), 0);

				$is_in_fraktion = mysql_result(mysql_query("SELECT member FROM accounts where name='". $_SESSION['user'] ."'"),0);
				$is_in_leader = mysql_result(mysql_query("SELECT Leader FROM accounts where name='". $_SESSION['user'] ."'"),0);
				$min_level_app = mysql_result(mysql_query("SELECT min_level FROM fraktion where id='". $fraktion ."'"),0);

				if(empty($application_fraktion) or empty($application_reason) or empty($application_name) or empty($application_level))
					{$ausgabe = '<div class="fail">Bitte fülle alle Felder aus.</div>';}
				elseif ($is_in_fraktion != 0)
					{$ausgabe = '<div class="fail">Du bist bereits in einer Fraktion.</div>';}
				elseif ($is_in_leader != 0)
					{$ausgabe = '<div class="fail">Du bist bereits in einer Fraktion.</div>';}
				/*elseif ($min_level_app < $application_level)
					{$ausgabe = '<div class="fail">Dein Level ist zu niedrig!</div>';}*/
				else
					{
						mysql_query("INSERT INTO application VALUES('', '$application_name', '$application_fraktion', '$application_level', '$application_reason', 1)");
					}
			}

			$app_id = @mysql_query("SELECT id FROM fraktion where application_stop = 2");
			echo $ausgabe;
			echo '<form method="post">
				  <table>
					<tr><td class="key">Fraktion:</td><td><select name="app_id">';
						while($application_select = @mysql_fetch_array($app_id)) 
						{
							echo '<option value="'. $application_select['id'].'">'. fraktion($application_select['id']) .'</option>';
						}
				  echo '</select></td></tr>
				  <tr><td class="key">Grund:</td><td><textarea name="reason"></textarea></td></tr>
				  <tr><td></td><td><input type="submit" name="send_application" value="Bewerbung abschicken"></td></tr></table>
				  </form>';
	}
	else
	{
		echo '<div class="fail">Du must eingelogt sein!</div>';
	}
	}
	else
	{	
	if(isset($_SESSION['user']))
	{
		$fraktion_leader = @mysql_result(@mysql_query("SELECT Leader FROM accounts where name='".$_SESSION['user']."'"), 0 );
		if($fraktion_leader != 0)
		{
			echo '<a href="index.php?site=fraktion&amp;do=settings" style="color:hsl(0,100%,50%)">Fraktionseinstellungen</a><br>';
		}

		$user_level = @mysql_result(@mysql_query("SELECT level FROM accounts where id='".$_SESSION['user']."'"), 0 );

		$leader_sapd = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "1"'), 0 );
		$member_count_sapd = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "1"'));
		$desc_sapd = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='1'"), 0 );
		$min_level_sapd = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='1'"), 0 );
		$application_stop_sapd = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='1'"), 0 );

		$leader_fbi = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "2"'), 0 );
		$member_count_fbi = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "2"'));
		$desc_fbi = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='2'"), 0 );
		$min_level_fbi = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='2'"), 0 );
		$application_stop_fbi = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='2'"), 0 );

		$leader_sani = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "4"'), 0 );
		$member_count_sani = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "4"'));
		$desc_sani = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='4'"), 0 );
		$min_level_sani = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='4'"), 0 );
		$application_stop_sani = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='4'"), 0 );

		$leader_lcm = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "5"'), 0 );
		$member_count_lcm = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "5"'));
		$desc_lcm = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='5'"), 0 );
		$min_level_lcm = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='5'"), 0 );
		$application_stop_lcm = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='5'"), 0 );

		$leader_yakuza = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "6"'), 0 );
		$member_count_yakuza = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "6"'));
		$desc_yakuza = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='6'"), 0 );
		$min_level_sapd = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='1'"), 0 );
		$application_stop_sapd = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='1'"), 0 );

		$leader_hitman = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "8"'), 0 );
		$member_count_hitman = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "8"'));
		$desc_hitman = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='8'"), 0 );
		$min_level_hitman = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='8'"), 0 );
		$application_stop_hitman = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='8'"), 0 );

		$leader_news_reporter = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "9"'), 0 );
		$member_count_news_reporter = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "9"'));
		$desc_news_reporter = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='9'"), 0 );
		$min_level_news_reporter = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='9'"), 0 );
		$application_stop_news_reporter = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='9'"), 0 );

		$leader_grove = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "12"'), 0 );
		$member_count_grove = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "12"'));
		$desc_grove = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='12'"), 0 );
		$min_level_grove = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='12'"), 0 );
		$application_stop_grove = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='12'"), 0 );

		$leader_ballas = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "13"'), 0 );
		$member_count_ballas = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "13"'));
		$desc_ballas = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='13'"), 0 );
		$min_level_ballas = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='13'"), 0 );
		$application_stop_ballas = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='13'"), 0 );

		$leader_sfrive = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "22"'), 0 );
		$member_count_sfrive = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "18"'));
		$desc_sfrive = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='18'"), 0 );
		$min_level_sfrive = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='18'"), 0 );
		$application_stop_sfrive = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='18'"), 0 );

		$leader_rmafia = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "23"'), 0 );
		$member_count_rmafia = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "23"'));
		$desc_rmafia = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='23'"), 0 );
		$min_level_rmafia = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='23'"), 0 );
		$application_stop_rmafia = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='23'"), 0 );

		$leader_ordnungsamt = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "18"'), 0 );
		$member_count_ordnungsamt = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "18"'));
		$desc_ordnungsamt = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='18'"), 0 );
		$min_level_ordnungsamt = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='18'"), 0 );
		$application_stop_ordnungsamt = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='18'"), 0 );

		echo '	
				<fieldset><legend>San Andreas Police Department</legend>
					<img src="images/misc/sapd.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sapd)){echo $leader_sapd; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sapd .'</td></tr>
							<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sapd > $user_level){echo $min_level_sapd;}else{echo'<span class="stop">'. $min_level_sapd .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sapd .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sapd == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Federal Bureau of Investigation</legend>
					<img src="images/misc/fbi.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_fbi)){echo $leader_fbi; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_fbi .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_fbi > $user_level){echo $min_level_fbi;}else{echo'<span class="stop">'. $min_level_fbi .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_fbi .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_fbi == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Sanitäter</legend>
					<img src="images/misc/sanitäter.png" alt="Sanitäter" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sani)){echo $leader_sani; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sani .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sani > $user_level){echo $min_level_sani;}else{echo'<span class="stop">'. $min_level_sani .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sani .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sani == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>La Cosa Nostra</legend>
					<img src="images/misc/lcn.png" alt="LCN" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_lcm)){echo $leader_lcm; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_lcm .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_lcm > $user_level){echo $min_level_lcm;}else{echo'<span class="stop">'. $min_level_lcm .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_lcm .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_lcm == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Yakuza</legend>
					<img src="images/misc/yakuzza.png" alt="Yakuzza" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_yakuza)){echo $leader_yakuza; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_yakuza .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_yakuza > $user_level){echo $min_level_yakuza;}else{echo'<span class="stop">'. $min_level_yakuza .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_yakuza .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_yakuza == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Hitman</legend>
					<img src="images/misc/hitman.png" alt="Hitman" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_hitman)){echo $leader_hitman; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_hitman .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_hitman > $user_level){echo $min_level_hitman;}else{echo'<span class="stop">'. $min_level_hitman .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_hitman .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_hitman == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>News Reporter</legend>
					<img src="images/misc/reporter.png" alt="Reporter" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_news_reporter)){echo $leader_news_reporter; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_news_reporter .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_news_reporter > $user_level){echo $min_level_news_reporter;}else{echo'<span class="stop">'. $min_level_news_reporter .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_news_reporter .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_news_reporter == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Grove Street</legend>
					<img src="images/misc/grove.png" alt="Grove Street" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_grove)){echo $leader_grove; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_grove .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_grove > $user_level){echo $min_level_grove;}else{echo'<span class="stop">'. $min_level_grove .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_grove .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_grove == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Ballas</legend>
					<img src="images/misc/ballas.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_ballas)){echo $leader_ballas; }else{echo '<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_ballas .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_ballas > $user_level){echo $min_level_ballas;}else{echo'<span class="stop">'. $min_level_ballas .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_ballas .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_ballas == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>S.F. Rifa</legend>
					<img src="images/misc/sfrifa.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sfrive)){echo $leader_sfrive; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sfrive .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sfrive > $user_level){echo $min_level_sfrive;}else{echo'<span class="stop">'. $min_level_sfrive .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sfrive .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sfrive == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Russen Mafia</legend>
					<img src="images/misc/russenmafia.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_rmafia)){echo $leader_rmafia; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_rmafia .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_rmafia > $user_level){echo $min_level_rmafia;}else{echo'<span class="stop">'. $min_level_rmafia .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_rmafia .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_rmafia == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
				<fieldset><legend>Ordnungsamt</legend>
					<img src="images/misc/ordnungsamt.png" alt="SAPD" align="left" style="margin-right:5px;">
						<table class="fraktion">
							<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_ordnungsamt)){echo $leader_ordnungsamt; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_ordnungsamt .'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_ordnungsamt < $user_level){echo $min_level_ordnungsamt;}else{echo'<span class="stop">'. $min_level_sapd .'</span>';} echo'</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_ordnungsamt .'</td></tr>
							<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
							<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_ordnungsamt == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&amp;do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
						</table>
				</fieldset>
		';
	}
	else
	{
		include('includes/login.php');
	}
	}
?>

Alles anzeigen

Ich hoffe ihr könnt mit verraten welche spalten ich in der Tabelle "application" brauche und warum keine Bewerbung versendet wird ;/
Mfg Chris

Bandit

Wenn ich solche Zeilen sehe

PHP

$fraktion_leader = @mysql_result(@mysql_query("SELECT name FROM accounts where Leader='".$fraktion."'"), 0 );

dann wird mir aber leicht übel. Verschachtelte Aufrufe mit @ davor, einfach nur grausam, wie eigentlich der komplette Quellcode.

Außerdem solltest du auf MySQLi umstellen, denn die MySQL-Schnittstelle ist veraltet.

Richtig debuggen

1. Man bemerkt, dass ein Skript nicht das tut, was es soll.
2. Man schreibt an den Anfang des Scriptes die Zeile: error_reporting(-1);
3. Man verwendet ini_set('display_errors', true); damit die Fehler auch angezeigt werden.
4. Man versucht, die Stelle die daran Schuld sein kann, schonmal einzugrenzen. Falls dies nicht geht, wird zunächst das komplette Skript als fehlerhaft angesehen.
5. An markanten Stellen im Skript lässt man sich wichtige Variableninhalte ausgeben und ggf. auch in bedingten Anweisungen eine kurze Ausgabe machen, um zu überprüfen, welche Bedingung ausgeführt wurde. Wichtig bei MySQL Fehlern (...not a valid MySQL result resource...): mysqli_error() verwenden oder Abfrage ausgeben und zb mit phpmyadmin testen.
6. Schritt 5 wird so lange wiederholt, bis Unstimmigkeiten im Skript auffallen
7. Damit hat man das Problem (Unstimmigkeit) gefunden und kann versuchen diese zu beheben. Hierzu dienen dann die PHP-Dokumentation und andere Quellen als Ratgeber.
8. Lässt sich das konkrete Problem trotzdem nicht beheben, kann man in Foren um Rat fragen.
9. Das Programm läuft und man kann die Debug-Ausgaben wieder entfernen.

latenight

Hallo Bandit vielen dank für deine Antwort,
Da ich ein Anfänger in Sachen PHP und mysql bin gab mir Dein Beitrag auch direkt neue Fragen unzwar,

Da ich dieses (von dir liebe voll genannt Häufchen elend) nicht fabriziert habe frage ich mich was an diesem kleinem @ so schlimm ist?

Was ist denn das besondere an mysqli das du mir sagst ich sollte darauf umsteigen?

Wo Wird in_set('display_errors', True) verwendet?

Mysqli error() verwenden? Sollte ich das in diesem Script verwenden oder erst wenn ich umgestellt habe?

Bandit

Ein @ vor einem Funktionsaufruf unterdrückt eventuelle Fehlermeldungen
Die MySQL-Extension wird in den nächsten PHP-Versionen nicht mehr unterstützt, deshalb solltest du auf MySQLi umstellen
Die Zeilen

PHP

error_reporting[E_ALL);
ini_set('display_errors',true);

gehören direkt an den Anfang, also direkt unter dem ersten <?php
Mit der alten MySQL-Extension sollte man das so schreiben:

PHP

$result = mysql_query("........")
   or die ("MySQL-Error: " . mysql_error());

Tags