php bzw mysql prob

Code:

<center>
<?php

if($s == "")
{

$conn_id = mysql_connect("localhost","root","");
mysql_select_db("test",$conn_id);
$result = mysql_query("SELECT nr , zeit , ip , port , game , beschreibung FROM games order by zeit");

$i=0;
while($zeile = mysql_fetch_array($result)) 
{
$i++;
$data[1][$i] = $zeile['nr'];
$data[2][$i] = $zeile['zeit'];
$data[3][$i] = $zeile['ip'];
$data[4][$i] = $zeile['port'];
$data[5][$i] = $zeile['game'];
$data[6][$i] = $zeile['beschreibung'];
}

$j = 0 ;

while($i != $j)
{
$j++;
$stu = substr($data[2][$j],1,2);
$min = substr($data[2][$j],3,2);
$wot = substr($data[2][$j],0,1);
if($wot == "1") {$wot = "Freitag";}
if($wot == "2") {$wot = "Samstag";}
if($wot == "3") {$wot = "Sonntag";}
echo "<table width=35% border='1'>";
echo "  <tr>";
/* echo "    <td width=75% bgcolor='lightsteelblue'> <b>Game:</b>",$data[4][$i],"</td>";    */
echo "<td bgcolor='lightsteelblue'><table border=0 cellpadding=0 cellspacing=0 width=100%><tr><td><b> Game: </b>", $data[5][$j] , "</td><td align='right' bgcolor='lightsteelblue'><b>" , $wot , " um " , $stu , ":" , $min , "</b></td></tr></table></td> ";

echo "  </tr> ";
echo "  <tr> ";
echo "     <td colspan = '2'><b>IP: </b>", $data[3][$j] , " <b>Port: </b>", $data[4][$j] , "<p><b>Beschreibung: </B><br>" , $data[6][$j],"</td>";
echo "   </tr>";
echo "<p>";
echo "<br>";
echo "</table>";
}  /* eowhile , ausgabe */
echo "<p>";

echo "<p><a href ='gsrv.php?s=1'>Neuer Eintrag </A>";
}  /* eoif, kontrolliert ob geschrieben wird */
if($s=="1")
{
?>
<form action="gsrv.php?s=2" method="post">
<table width="75%" border="0">
  <tr><td><div align="right">Uhrzeit (HH:MM): </div>
    </td><td>
      <input type="text" name="Zeit">
    </td></tr><tr>
    <td><div align="right">Tag: </div>
    </td><td>
      <select name="WoT">
        <option value="1">Freitag</option>
        <option value="2">Samstag</option>
        <option value="3">Sonntag</option>
      </select>
    </td></tr>
  <tr><td><div align="right">Game: </div>
    </td><td><input type="text" name="Game">
    </td></tr><tr>
    <td><div align="right">IP: </div>
    </td><td>
      <input type="text" name="Ip">
    </td></tr>
  <tr><td>
      <div align="right">Port: </div>
    </td><td>
      <input type="text" name="Port">
    </td></tr>
  <tr><td>
      <div align="right">Beschreibung: </div>
    </td><td>
    <textarea name="Beschreibung" rows="4" cols="70" wrap="virtual" tabindex="1"></textarea> </td>
  </tr>
</table>
<input type="submit" value="Go">
<?php
}
if($s=="2")
{
$stun = substr($Zeit,0,2);
$min = substr($Zeit,3,2);
$zeit = "$WoT$stun$min";
$conn_id = mysql_connect("localhost","root","");
mysql_select_db("test",$conn_id);
$result = mysql_query("Insert into games (zeit , ip , port , game , beschreibung)
 			values(".$zeit.", ".$Ip." , ".$Port." , ".$Game." , ".$Beschreibung.")");
 			
 			echo "Daten wurden geschrieben<br>";
 			echo "<a href='gsrv.php'>Startseite</A>";
}



?>

Code: PHP

	if (!$result)
	{
		echo mysql_errno(). ": ".mysql_error(). "<br />";
		return;
	}

Zitat von funka

das war kein loesungs ansatz ansich
hau mal ein if (!$result) die(mysql_error()); drunter

Zitat

echo "<table width=35% border='1'>";
echo " <tr>";
/* echo " <td width=75% bgcolor='lightsteelblue'> <b>Game:</b>",$data[4][$i],"</td>"; */
echo "<td bgcolor='lightsteelblue'><table border=0 cellpadding=0 cellspacing=0 width=100%><tr><td><b> Game: </b>", $data[5][$j] , "</td><td align='right' bgcolor='lightsteelblue'><b>" , $wot , " um " , $stu , ":" , $min , "</b></td></tr></table></td> ";

echo " </tr> ";
echo " <tr> ";
echo " <td colspan = '2'><b>IP: </b>", $data[3][$j] , " <b>Port: </b>", $data[4][$j] , "<p><b>Beschreibung: </B><br>" , $data[6][$j],"</td>";
echo " </tr>";
echo "<p>";
echo "<br>";
echo "</table>";
} /* eowhile , ausgabe */
echo "<p>";