OFFTOPIC HILFE-SQL

[falcon76]

Hallo Leute,

in einem Thread wurde geschrieben, dies sei ein Forum von Spielern für Spieler....

mein Problem hat mit Ryzom indirekt zu tun,

ich bastel an einem Charaktersheet auf basis PHP und SQL für unsere Gilde. Ich schreibe Quelltext, ohne Editor, an sich ohne Probleme....

Doch,

der besagte Charakterbogen mit MySQL Version 3.23.47 hat mittlerweile über 40 Einträge auf der Tabelle charakter....

beim Updaten des Charakterbogens macht er folgende Fehlermeldung:

An der Konsole angemeldet!
Datenbank ausgewählt!
Tabellenfehler!
Fehler #1064 - You have an error in your SQL syntax near 'int='0',wis='0',str='0',bal='0',dex='0',will='0',close='0',heins='0',hzwei='0',r' at line 1

ich habe die Zeile Mehrfach durchexerziert.

Unter googlen von SQL Fehler Nr. 1064 erhalte ich nicht als spekulationen und fehlerbehebung wie "hatte ich auch, einfach abwarten, bei mir wars irgendwann einfach weg"???!!!??!!

Vielleicht kann mir jemand was dazu sagen -> bin durchaus bereit mein geschriebenes Wissen dann auch weiterzugeben....

Danke und Hoffe keinen drüber für diesen Missbrauch zu bekommen

[arax13]

Hi Falcon,

kannst du das komplette Statement mal posten ?
Ein hilfreiches Tool könnte das hier sein.

Ansonsten würde ich auf das Feld 'int' tippen, das ist eigentlich auf
allen Datenbanken ein reservierter Begriff. Du solltest da mal die Hilfe
von mySQL durchstöbern

[falcon76]

function eintragmember()
{
global $connection,$name,$titel,$rasse,$orden,$con,$meta,$int,$wis,$str,$bal,$dex,$will,$close,$h1,$h2,$range,$offaff,$ele,$defaff,$heal,$armor,$schmuck,$nah,$fern,$wueste,$wald,$dschungel,$seenland,$urwurzel,$hp,$sap,$sta,$focus,$waffe,$ruestung,$mv,$mad,$blind,$root,$stun,$sleep,$fear,$healhp,$healsta,$healsap,$anmerkung;

$update = mysql_query("UPDATE charakter SET name='$name',titel='$titel',rasse='$rasse',orden='$orden',con='$con',meta='$meta',int='$int',wis='$wis',str='$str',bal='$bal',dex='$dex',will='$will',close='$close',heins='$h1',hzwei='$h2',range='$range',offaff='$offaff',ele='$ele',defaff='$defaff',heal='$heal',armor='$armor',schmuck='$schmuck',nah='$nah',fern='$fern',wueste='$wueste',wald='$wald',dschungel='$dschungel',seenland='$seenland',urwurzel='$urwurzel',hp='$hp',sap='$sap',sta='$sta',focus='$focus',waffe='$waffe',ruestung='$ruestung',mv='$mv',mad='$mad',blind='$blind',root='$root',stun='$stun',sleep='$sleep',fear='$fear',healhp='$healhp',healsta='$healsta',healsap='$healsap',anmerkung='$anmerkung' WHERE name='$name'");
if($update)
{
$affected = mysql_affected_rows($connection);
echo '<div class="post2">Es wurde(n) ';
echo $affected; /* 10 */
echo ' Datensätze geändert</div>';
echo '<table border="0" bgcolor="#ffffff" align="center" width="100%">';
}
else
{
echo "An der Konsole angemeldet!";
echo '<br>';
echo "Datenbank ausgewählt!";
echo '<br>';
echo "Tabellenfehler!";
echo '<br>';
echo 'Fehler #',mysql_errno(),' - ',mysql_error();
echo '<br>';
}
}

so sieht die Funktion exakt aus....

normalerweise würde er im Fehlerlog auswerfen, dass der Fehler in der eintrag.php in zeile xy(aufruf funktion)

und in zeile xy der funktionen.php ist. als normalerweise macht er das. komischerweise sagt er hier in zeile 1, was weder auf die eintrag.php noch auf die funktionen.php zutrifft.

tabellenstruktur:

Tabellenstruktur für Tabelle `charakter`
#

CREATE TABLE charakter (
id int(11) NOT NULL auto_increment,
name varchar(30) default NULL,
pw varchar(30) default NULL,
email varchar(30) default NULL,
titel varchar(30) default NULL,
rasse enum('Zorai','Tryker','Fyros','Matis') default NULL,
orden enum('Exterminator','Operator','Reiniger','Novize') default NULL,
con smallint(4) NOT NULL default '0',
int smallint(4) NOT NULL default '0',
str smallint(4) NOT NULL default '0',
dex smallint(4) NOT NULL default '0',
meta smallint(4) NOT NULL default '0',
wis smallint(4) NOT NULL default '0',
bal smallint(4) NOT NULL default '0',
will smallint(4) NOT NULL default '0',
close smallint(4) NOT NULL default '0',
heins smallint(4) NOT NULL default '0',
hzwei smallint(4) NOT NULL default '0',
range smallint(4) NOT NULL default '0',
offaff smallint(4) NOT NULL default '0',
ele smallint(4) NOT NULL default '0',
defaff smallint(4) NOT NULL default '0',
heal smallint(4) NOT NULL default '0',
armor smallint(4) NOT NULL default '0',
armortype enum('leicht','mittel','schwer') default NULL,
schmuck smallint(4) NOT NULL default '0',
nah smallint(4) NOT NULL default '0',
nahtype enum('1h','2h') default NULL,
fern smallint(4) NOT NULL default '0',
ferntype enum('1h','2h') default NULL,
wueste smallint(4) NOT NULL default '0',
wald smallint(4) NOT NULL default '0',
dschungel smallint(4) NOT NULL default '0',
seenland smallint(4) NOT NULL default '0',
urwurzel smallint(4) NOT NULL default '0',
hp smallint(4) NOT NULL default '0',
sta smallint(4) NOT NULL default '0',
sap smallint(4) NOT NULL default '0',
focus smallint(4) NOT NULL default '0',
Anmerkung mediumtext,
rechte enum('Administrator','Operator','Mitglied','Gast') default 'Gast',
cookie enum('j','n') default NULL,
bildname varchar(30) default NULL,
waffe smallint(4) NOT NULL default '0',
ruestung smallint(4) NOT NULL default '0',
healhp smallint(2) NOT NULL default '0',
healsta smallint(2) NOT NULL default '0',
healsap smallint(2) NOT NULL default '0',
acid smallint(2) NOT NULL default '0',
cold smallint(2) NOT NULL default '0',
rot smallint(2) NOT NULL default '0',
mad smallint(2) NOT NULL default '0',
blind smallint(2) NOT NULL default '0',
root smallint(2) NOT NULL default '0',
sapcrystal smallint(2) NOT NULL default '0',
stun smallint(2) NOT NULL default '0',
sleep smallint(2) NOT NULL default '0',
fear smallint(2) NOT NULL default '0',
mv smallint(3) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

danke im voraus

achso, der einzige unterschied zu anderen erfassungsmasken und tabellen liegt in dem formular, das hier den zusatz enctype="mulitpart/form-data" hat, und bei den tabellen das sie mehr als 20 felder hat.....

Erfassungsmaske:

function updatememberlist()
{
global $connection,$row,$feld,$name,$code;
echo '<table border="0" width="100%" align="center" bgcolor="#ffffff">';
$code="21";
$result = mysql_query("SELECT * FROM charakter ORDER BY name ASC");
if($result)
{
echo "<span class='postdetails'><tr>";
echo "<td>Name</td>";
echo "<td>Orden</td>";
echo "<td>Fighter</td>";
echo "<td>Mage</td>";
echo "<td>Crafter</td>";
echo "<td>Forager</td>";
echo "<td>Waffe QL</td>";
echo "<td>Rüstung QL</td>";
echo "<td>Heal HP</td>";
echo "<td>Heal STA</td>";
echo "<td>Heal SAP</td>";
echo "<td>Sap Crystal</td>";
echo "<td>Madness</td>";
echo "<td>Beschreibung</td>";
echo "</tr></span>";
while($row = mysql_fetch_array($result))
{
echo '<tr>';
echo "<td class='post2'><div class='postcolor'>$row[name]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[orden]</div></td>";
if($row[close]>$row[heins] AND $row[close]>$row[hzwei] AND $row[close]>$row[range])
{
echo "<td class='post2'><div class='postcolor'>$row[close]</div></td>";
}
else
{
if($row[heins]>$row[hzwei] AND $row[heins]>$row[close] AND $row[heins]>$row[range])
{
echo "<td class='post2'><div class='postcolor'>$row[heins]</div></td>";
}
else
{
if($row[hzwei]>$row[heins] AND $row[hzwei]>$row[close] AND $row[hzwei]>$row[range])
{
echo "<td class='post2'><div class='postcolor'>$row[hzwei]</div></td>";
}
else
{
echo "<td class='post2'><div class='postcolor'>$row[range]</div></td>";
}
}
}
if($row[offaff]>$row[ele] AND $row[offaff]>$row[defaff] AND $row[offaff]>$row[heal])
{
echo "<td class='post2'><div class='postcolor'>$row[offaff]</div></td>";
}
else
{
if($row[ele]>$row[offaff] AND $row[ele]>$row[defaff] AND $row[ele]>$row[heal])
{
echo "<td class='post2'><div class='postcolor'>$row[ele]</div></td>";
}
else
{
if($row[defaff]>$row[offaff] AND $row[defaff]>$row[ele] AND $row[defaff]>$row[heal])
{
echo "<td class='post2'><div class='postcolor'>$row[defaff]</div></td>";
}
else
{
echo "<td class='post2'><div class='postcolor'>$row[heal]</div></td>";
}
}
}
if($row[armor]>$row[schmuck] AND $row[armor]>$row[nah] AND $row[armor]>$row[fern])
{
echo "<td class='post2'><div class='postcolor'>$row[armor]</div></td>";
}
else
{
if($row[schmuck]>$row[armor] AND $row[schmuck]>$row[nah] AND $row[schmuck]>$row[fern])
{
echo "<td class='post2'><div class='postcolor'>$row[schmuck]</div></td>";
}
else
{
if($row[nah]>$row[armor] AND $row[nah]>$row[schmuck] AND $row[nah]>$row[fern])
{
echo "<td class='post2'><div class='postcolor'>$row[nah]</div></td>";
}
else
{
echo "<td class='post2'><div class='postcolor'>$row[fern]</div></td>";
}
}
}
if($row[wueste]>$row[wald] AND $row[wueste]>$row[dschungel] AND $row[wueste]>$row[seenland] AND $row[wueste]>$row[urwurzel])
{
echo "<td class='post2'><div class='postcolor'>$row[wueste]</div></td>";
}
else
{
if($row[wald]>$row[wueste] AND $row[wald]>$row[dschungel] AND $row[wald]>$row[seenland] AND $row[wald]>$row[urwurzel])
{
echo "<td class='post2'><div class='postcolor'>$row[wald]</div></td>";
}
else
{
if($row[dschungel]>$row[wueste] AND $row[dschungel]>$row[wald] AND $row[dschungel]>$row[seenland] AND $row[dschungel]>$row[urwurzel])
{
echo "<td class='post2'><div class='postcolor'>$row[dschungel]</div></td>";
}
else
{
if($row[seenland]>$row[wueste] AND $row[seenland]>$row[wald] AND $row[seenland]>$row[dschungel] AND $row[seenland]>$row[urwurzel])
{
echo "<td class='post2'><div class='postcolor'>$row[seenland]</div></td>";
}
else
{
echo "<td class='post2'><div class='postcolor'>$row[urwurzel]</div></td>";
}
}
}
}
echo "<td class='post2'><div class='postcolor'>$row[waffe]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[ruestung]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[healhp]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[healsta]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[healsap]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[sapcrystal]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[mad]</div></td>";
echo "<td class='post2'><div class='postcolor'>$row[anmerkung]</div></td>";
echo '</tr>';
}
}
$result2 = mysql_query("SELECT * FROM charakter where name='$name'");
if($result2)
{
while($feld = mysql_fetch_array($result2))
{
echo '</table>';
echo '<form action="eintrag.php" method="post" enctype="mulitpart/form-data">';
echo '<table border="0" width="100%" align="center" bgcolor="#ffffff">';
echo "<span class='postdetails'><tr>";
echo "<td class='post2' rowspan='4' align='center'><div class='postcolor'><input type='file' name='bildname' value='$feld[bildname]' size='10'><input type='hidden' name='MAX_FILE_SIZE' value='250000'></div></td>";
echo "<td class='post2' colspan='5'><div class='postcolor'>Name:</div></td>";
echo "<td class='post2' colspan='15'><div class='postcolor'><input type='text' size='75' name='name' value='$feld[name]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Verfassung:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='con' size='5' value='$feld[con]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Metabolismus:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='meta' size='5' value='$feld[meta]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5'><div class='postcolor'>Titel:</div></td>";
echo "<td class='post2' colspan='15'><div class='postcolor'><input type='text' size='75' name='titel' value='$feld[titel]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Intelligenz:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='int' size='5' value='$feld[int]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Weisheit:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='wis' size='5' value='$feld[wis]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5'><div class='postcolor'>Rasse:</div></td>";
echo "<td class='post2' colspan='15'><div class='postcolor'><input type='text' size='75' name='rasse' value='$feld[rasse]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Stärke:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='str' size='5' value='$feld[str]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Gleichgewicht:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='bal' size='5' value='$feld[bal]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5'><div class='postcolor'>Orden:</div></td>";
echo "<td class='post2' colspan='15'><div class='postcolor'><input type='text' size='75' name='orden' value='$feld[Orden]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Ausdauer:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' name='dex' size='5' value='$feld[dex]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Wille:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='will' value='$feld[will]'></div></td>";
echo "</tr></span>";

echo "<span class='postdetails'><tr>";
echo "<td class='post2'><div class='postcolor'>Kämpfer:</div></td>";

echo "<td colspan='20' rowspan='4' align='center'>";
/* Innere Tabelle */
echo '<table border="0" width="100%" align="center" bgcolor="#ffffff">';
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' width='25%' align='center'><div class='postcolor'>Nahkampf:</div></td>";
echo "<td class='post2' colspan='5' width='25%' align='center'><div class='postcolor'>Einhand:</div></td>";
echo "<td class='post2' colspan='5' width='25%' align='center'><div class='postcolor'>Zweihand:</div></td>";
echo "<td class='post2' colspan='5' width='25%' align='center'><div class='postcolor'>Fernkampf:</div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='close' value='$feld[close]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='h1' value='$feld[heins]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='h2' value='$feld[hzwei]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='range' value='$feld[range]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Off.Beherr.:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Elementmagie:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Def.Beherr.:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Heilmagie:</div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='offaff' value='$feld[offaff]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='ele' value='$feld[ele]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='defaff' value='$feld[defaff]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='heal' value='$feld[heal]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Rüstungen:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Schmuck:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Nahkampfwaffen:</div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'>Fernkampfwaffen:</div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='armor' value='$feld[armor]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='schmuck' value='$feld[schmuck]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='nah' value='$feld[nah]'></div></td>";
echo "<td class='post2' colspan='5' align='center'><div class='postcolor'><input type='text' size='5' name='fern' value='$feld[fern]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='4' align='center'><div class='postcolor'>Wüste:</div></td>";
echo "<td class='post2' colspan='4' align='center'><div class='postcolor'>Wald:</div></td>";
echo "<td class='post2' colspan='4' align='center'><div class='postcolor'>Dschungel:</div></td>";
echo "<td class='post2' colspan='4' align='center'><div class='postcolor'>Seenland:</div></td>";
echo "<td class='post2' colspan='4' align='center'><div class='postcolor'>Urwurzeln:</div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='4' width='20%' align='center'><div class='postcolor'><input type='text' size='5' name='wueste' value='$feld[wueste]'></div></td>";
echo "<td class='post2' colspan='4' width='20%' align='center'><div class='postcolor'><input type='text' size='5' name='wald' value='$feld[wald]'></div></td>";
echo "<td class='post2' colspan='4' width='20%' align='center'><div class='postcolor'><input type='text' size='5' name='dschungel' value='$feld[dschungel]'></div></td>";
echo "<td class='post2' colspan='4' width='20%' align='center'><div class='postcolor'><input type='text' size='5' name='seenland' value='$feld[seenland]'></div></td>";
echo "<td class='post2' colspan='4' width='20%' align='center'><div class='postcolor'><input type='text' size='5' name='urwurzel' value='$feld[urwurzel]'></div></td>";
echo "</tr></span>";
echo "</table>";
/* Innere Tabelle Ende */
echo "</td>";
echo "<td class='post2'><div class='postcolor'>Lebenspunkte:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='hp' value='$feld[hp]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Waffe - QL:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='waffe' value='$feld[waffe]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2'><div class='postcolor'>Magier:</div></td>";
echo "<td class='post2'><div class='postcolor'>Stamina:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='sta' value='$feld[sta]'></div></td>";
echo "<td class='post2'><div class='postcolor'>Rüstung - QL:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='ruestung' value='$feld[ruestung]'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2'><div class='postcolor'>Handwerk:</div></td>";
echo "<td class='post2'><div class='postcolor'>Sap:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='sap' value='$feld[sap]'></div></td>";
echo "<td class='post2'><div class='postcolor'></div>Magieverstärker - QL:</td>";
echo "<td class='post2'><div class='postcolor'></div><input type='text' size='5' name='mv' value='$feld[mv]'></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2'><div class='postcolor'>Rohstoffgewinnung:</div></td>";
echo "<td class='post2'><div class='postcolor'>Focus:</div></td>";
echo "<td class='post2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[focus]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'></div></td>";
echo "</tr></span>";
echo "</table>";
/* Zauber tabelle */
echo '<table border="0" width="100%" align="center" bgcolor="#ffffff">';
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='25' align='left'><div class='postcolor'>Zauber:</div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Wahnsinn:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Blenden:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Verwurzeln:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Säure:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Kälte:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Verrotten:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Betäuben:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Schlaf:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Angst:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Heile HP:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Heile SAP:</div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'>Heile STA:</div></td>";
echo "<td class='post2'><div class='postcolor'></div></td>";
echo "</tr></span>";
echo "<span class='postdetails'><tr>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[mad]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[blind]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[root]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[acid]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[cold]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[rot]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[stun]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[sleep]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[fear]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[healhp]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[healsap]'></div></td>";
echo "<td class='post2' colspan='2'><div class='postcolor'><input type='text' size='5' name='focus' value='$feld[healsta]'></div></td>";
echo "<td class='post2'><div class='postcolor'></div></td>";
echo "</tr></span>";
echo '</table>';
/* Anmerkung */
echo '<table border="0" width="100%" align="center" bgcolor="#ffffff">';
echo "<span class='postdetails'><tr align='left' valign='top'>";
echo "<td class='post2' align='left' valign='top'><div class='postcolor'>Beschreibung:</div></td>";
echo "<td class='post2' colspan='24' align='left' valign='middle'><div class='postcolor'><textarea rows='7' cols='120' name='anmerkung'>$feld[anmerkung]</textarea></div></td>";
echo "</tr></span>";
echo "<td class='post2' colspan='25' align='center'><div class='postcolor'>Passwort:<input type='password' name='pw'><input type='hidden' name='code' value='21'></div></td>";
echo "</tr></span>";
echo "<td class='post2' colspan='25' align='center'><div class='postcolor'><input type='submit' value='eintragen'></div></td>";
echo "</tr></span>";
echo '</table></form>';
}
}
}


EDIT:

HAHAHAHAHA es war INT

einfach umbenannt, und schon geht!!


DAAAAAAAANNNNNNNKEEEEEEEEE!!!!!!!!!!