auslese problem

T-sneak · 5 Juli 2006

Könnt ihr mir sagen was ich hier falsch mache?
self und gegnerpu sind beides spalten in war drinne
als fehler bekomme ich

Warning: mysql_query(): A link to the server could not be established in /usr/export/www/vhosts/funnetwork/hosting/tsneak/match.php on line 43

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/tsneak/match.php on line 44
Wars

PHP:

<table width="886" border="0">
  <tr>
    <td width="67"><?php 
	$result = mysql_query("SELECT * FROM war'");
	$menge = mysql_num_rows($result);
	echo "$menge Wars";
	
	?>&nbsp;</td>
    <td width="86"><?php 
	$result2 = mysql_query("SELECT * FROM war where `self` > `gegnerpu`'");
	$menge2 = mysql_num_rows($result2);
	echo "$menge2 Wins";
	
	?>&nbsp;</td>
    <td width="85"><?php 
	$result3 = mysql_query("SELECT * FROM war where `self` == `gegnerpu`'");
	$menge3 = mysql_num_rows($result3);
	echo "$menge3 Draws";
	
	?>&nbsp;</td>
	 <td width="630"><?php 
	$result4 = mysql_query("SELECT * FROM war where `self` < `gegnerpu`'");
	$menge4 = mysql_num_rows($result4);
	echo "$menge4 Lose";
	
	?>&nbsp;</td>
  </tr>
</table>

morl · 5 Juli 2006

Du verbindest weder zu einer Datenbank noch wählst du eine aus. Schau dir mal die funktionen mysql_connect() und mysql_select_db() in der php-Referenz an.

T-sneak · 5 Juli 2006

doch ist schon da die verbundung ist ja nur en kleines stück aus dem gesammten code...
naja hier mal allés

PHP:

<?php
session_start();
include("connect.php");
?>

<script language="JavaScript1.2">

function high(which2){
theobject=which2
highlighting=setInterval("highlightit(theobject)",50)
}
function low(which2){
clearInterval(highlighting)
if (which2.style.MozOpacity)
which2.style.MozOpacity=0.3
else if (which2.filters)
which2.filters.alpha.opacity=40
}

function highlightit(cur2){
if (cur2.style.MozOpacity<1)
cur2.style.MozOpacity=parseFloat(cur2.style.MozOpacity)+0.1
else if (cur2.filters&&cur2.filters.alpha.opacity<100)
cur2.filters.alpha.opacity+=10
else if (window.highlighting)
clearInterval(highlighting)
}

</script>


<script language="JavaScript" type="text/javascript">  
function hiddenInfo (id)
{
	if (document.getElementById("div_" + id).style.display == 'none')
	{
		document.getElementById("div_" + id).style.display = "";	
	}
	else
	{	
		document.getElementById("div_" + id).style.display = "none";
	}
}
</script>
<table width="886" border="0">
  <tr>
    <td width="67"><?php 
	$result = mysql_query("SELECT * FROM war'");
	$menge = mysql_num_rows($result);
	echo "$menge Wars";
	
	?>&nbsp;</td>
    <td width="86"><?php 
	$result2 = mysql_query("SELECT * FROM war where `self` > `gegnerpu`'");
	$menge2 = mysql_num_rows($result2);
	echo "$menge2 Wins";
	
	?>&nbsp;</td>
    <td width="85"><?php 
	$result3 = mysql_query("SELECT * FROM war where `self` == `gegnerpu`'");
	$menge3 = mysql_num_rows($result3);
	echo "$menge3 Draws";
	
	?>&nbsp;</td>
	 <td width="630"><?php 
	$result4 = mysql_query("SELECT * FROM war where `self` < `gegnerpu`'");
	$menge4 = mysql_num_rows($result4);
	echo "$menge4 Lose";
	
	?>&nbsp;</td>
  </tr>
</table>
<br />
<a href="#" onclick="hiddenInfo('1')" class="menu_over"><div class="menu"><img src="Bilder/war1on1.jpg" border="0" /></div>
</a>
<span style="display: none" id="div_1">
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC">Datum</td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC">Gegner</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Liga</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Result</td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC">Details</td>
  </tr>
</table>
<?php
$sql = mysql_query("SELECT * FROM war where `player` = '2'order by id desc limit 5000000");

//MSG AUSLESEN IM ARRAY
while($data2 = mysql_fetch_array($sql)){
$home = $data2['self'];
$gegner = $data2['gegnerpu'];

if($home < $gegner){
$font = "red";
}
if($home == $gegner){
$font = "orange";
}
if($home > $gegner){
$font = "#006600";
}


?>
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['datum'] ?></td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['gegner'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['art'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC; color:<?= $font ?>"><?= $home ?> - <?= $gegner ?></td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC"><a href="index.php?inhalt=wardetail&war=<?= $data2['id'] ?>"><img src="http://www.ug.interneo.de/images/icons/foldericons/folder.gif" alt="-[C]-" border="0"/></a></td>
  </tr>
</table>



<? } ?>
</span>
<a href="#" onClick="hiddenInfo('2')" class="menu_over"><div class="menu"><img src="Bilder/war2on2.jpg"  border="0" /></div></a>
<span style="display: none" id="div_2">
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC">Datum</td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC">Gegner</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Liga</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Result</td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC">Details</td>
  </tr>
</table>
<?php
$sql = mysql_query("SELECT * FROM war where `player` = '4'order by id desc limit 5000000");

//MSG AUSLESEN IM ARRAY
while($data2 = mysql_fetch_array($sql)){
$home = $data2['self'];
$gegner = $data2['gegnerpu'];

if($home < $gegner){
$font = "red";
}
if($home == $gegner){
$font = "orange";
}
if($home > $gegner){
$font = "#006600";
}

T-sneak · 5 Juli 2006

PHP:

?>
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['datum'] ?></td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['gegner'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['art'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC; color:<?= $font ?>"><?= $home ?> - <?= $gegner ?></td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC"><a href="index.php?inhalt=wardetail&war=<?= $data2['id'] ?>"><img src="http://www.ug.interneo.de/images/icons/foldericons/folder.gif" alt="[C]" border="0"/></a></td>
  </tr>
</table>



<? } ?>
</span>
<a href="#" onClick="hiddenInfo('3')" class="menu_over"><div class="menu"><img src="Bilder/war3on3.jpg"  border="0" /></div></a>
<span style="display: none" id="div_3">

<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC">Datum</td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC">Gegner</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Liga</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Result</td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC">Details</td>
  </tr>
</table>
<?php
$sql = mysql_query("SELECT * FROM war where `player` = '6'order by id desc limit 5000000");

//MSG AUSLESEN IM ARRAY
while($data2 = mysql_fetch_array($sql)){
$home = $data2['self'];
$gegner = $data2['gegnerpu'];

if($home < $gegner){
$font = "red";
}
if($home == $gegner){
$font = "orange";
}
if($home > $gegner){
$font = "#006600";
}


?>
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['datum'] ?></td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['gegner'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['art'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC; color:<?= $font ?>"><?= $home ?> - <?= $gegner ?></td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC"><a href="index.php?inhalt=wardetail&war=<?= $data2['id'] ?>"><img src="http://www.ug.interneo.de/images/icons/foldericons/folder.gif" alt="[C]" border="0"/></a></td>
  </tr>
</table>



<? } ?>
</span>
<a href="#" onClick="hiddenInfo('4')" class="menu_over"><div class="menu"><img src="Bilder/war4on4.jpg"  border="0" /></div></a>
<span style="display: none" id="div_4">

<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC">Datum</td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC">Gegner</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Liga</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Result</td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC">Details</td>
  </tr>
</table>
<?php
$sql = mysql_query("SELECT * FROM war where `player` = '8'order by id desc limit 5000000");

//MSG AUSLESEN IM ARRAY
while($data2 = mysql_fetch_array($sql)){
$home = $data2['self'];
$gegner = $data2['gegnerpu'];

if($home < $gegner){
$font = "red";
}
if($home == $gegner){
$font = "orange";
}
if($home > $gegner){
$font = "#006600";
}


?>
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['datum'] ?></td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['gegner'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['art'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC; color:<?= $font ?>"><?= $home ?> - <?= $gegner ?></td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC"><a href="index.php?inhalt=wardetail&war=<?= $data2['id'] ?>"><img src="http://www.ug.interneo.de/images/icons/foldericons/folder.gif" alt="[C]" border="0"/></a></td>
  </tr>
</table>



<? } ?>
</span>
<a href="#" onClick="hiddenInfo('5')" class="menu_over"><div class="menu"><img src="Bilder/war5on5.jpg"  border="0" /></div></a>
<p><span style="display: none" id="div_5">
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC">Datum</td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC">Gegner</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Liga</td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC">Result</td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC">Details</td>
  </tr>
</table>
<?php
$sql = mysql_query("SELECT * FROM war where `player` = '10'order by id desc limit 5000000");

//MSG AUSLESEN IM ARRAY
while($data2 = mysql_fetch_array($sql)){
$home = $data2['self'];
$gegner = $data2['gegnerpu'];

if($home < $gegner){
$font = "red";
}
if($home == $gegner){
$font = "orange";
}
if($home > $gegner){
$font = "#006600";
}


?>
<table width="548" style="border:solid 1px; border-color:#CCCCCC">
  <tr>
    <td width="69"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['datum'] ?></td>
    <td width="169"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['gegner'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC"><?= $data2['art'] ?></td>
    <td width="84"  style="border:solid 1px; border-color:#CCCCCC; color:<?= $font ?>"><?= $home ?> - <?= $gegner ?></td>
    <td width="118"  style="border:solid 1px; border-color:#CCCCCC"><a href="index.php?inhalt=wardetail&war=<?= $data2['id'] ?>"><img src="http://www.ug.interneo.de/images/icons/foldericons/folder.gif" alt="[C]" border="0"/></a></td>
  </tr>
</table>



<? } ?>
</span>

sry man kann nur 10000 zeichen machen ^^ deswegen doppelpost

Verhueterli · 5 Juli 2006

supplied argument is not a valid MySQL result resource

Das bedeutet normalerweise, dass die ausgewählte Quelle eine ungültige ist.

Spontan würde ich auf das where in deinen SQL-Befehlen tippen, das schreibt man groß (WHERE).

Ansonsten einfach mal hinter jedes mysql_query([SQL-ANWEISUNG]) folgendes anhängen:

PHP:

or die(mysql_error());

T-sneak · 5 Juli 2006

also das hab ich mal gemacht :)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1

das bekomme ich als fehler

EDIT: ok hab fehler gefunden
waren überall ' zuviel

auslese problem

T-sneak

Mitglied

morl

Neues Mitglied

T-sneak

Mitglied

T-sneak

Mitglied

Verhueterli

Neues Mitglied

T-sneak

Mitglied

Neueste Beiträge