note 90860 added to function.mysql-field-name
| From: | listsheaders at osu1 dot php dot net | Date: | Wed, 13 May 2009 10:28:19 +0000 |
| Subject: | note 90860 added to function.mysql-field-name | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-154538@lists.php.net to get a copy of this message | ||
<?php
include("dbconnect.php");
$spalte = $_GET["spalte"];
$dir = $_GET["richtung"];
if($dir == "ASC"): $dir = "DESC";
else: $dir = "ASC";
endif;
$query="SELECT * FROM spieler ORDER BY $spalte $dir";
$result=mysql_query($query);
$numfields = mysql_num_fields($result);
echo "<table><tr>";
$counter = 0;
for ($i=0; $i < $numfields; $i++) // Kopf
{
$feld = mysql_field_name($result, $i);
echo "<th><a href=index.php?spalte=". $feld . "&richtung=" . $dir
. ">" . $feld . "</a></th>";
}
echo "</tr>";
while ($row = mysql_fetch_row($result)) // Daten
{
if($counter % 2 == 0): $color = "#FFDDDD";
else: $color = "#DDFFFF";
endif;
echo "<tr bgcolor=". $color . "><td>" .
implode($row,"</td><td>")."</td></tr>";
$counter++;
}
echo "</table>";
?>
----
Server IP: 81.223.48.75
Probable Submitter: 83.215.62.203
----
Manual Page -- http://www.php.net/manual/en/function.mysql-field-name.php
Edit -- https://master.php.net/note/edit/90860
Del: integrated -- https://master.php.net/note/delete/90860/integrated
Del: useless -- https://master.php.net/note/delete/90860/useless
Del: bad code -- https://master.php.net/note/delete/90860/bad+code
Del: spam -- https://master.php.net/note/delete/90860/spam
Del: non-english -- https://master.php.net/note/delete/90860/non-english
Del: in docs -- https://master.php.net/note/delete/90860/in+docs
Del: other reasons-- https://master.php.net/note/delete/90860
Reject -- https://master.php.net/note/reject/90860
Search -- https://master.php.net/manage/user-notes.php