Select-Abfrage nach dropdown-Vorgabe abändern!?

[jagg]

Hi,

i save junior football results in a mysql table
(FIELDS id jugend autor sptag ergebnis spdatum zeit )

With the following lines I generate a site whichs gives me ALL results

Code:
<table border="0" cellspacing="1" cellpadding="2" class="content"
width="100%">
<?
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Order By b.jugend ASC Limit $eintrag,$zps";
$ergebnis = mysql_query($sqlbefehl, $serverid);
while ( $spiel = mysql_fetch_array ($ergebnis)) {
echo "<tr>";
//Jugendmannschaft
echo "<td align=\"center\" class=\"left\" bgcolor=\"$c_right\">";
echo $spiel['jugend'];
echo "</td>";
//Spieltag
echo "<td align=\"center\" class=\"right\" bgcolor=\"$c_right\">";
echo $spiel['sptag'];
echo "</td>";
//Datum ###########:
echo "<td align=\"center\" class=\"left\" bgcolor=\"$c_left\"><font
size=\"1\"><nobr>";
echo date("d.m.Y",$spiel[spdatum]+$time_offset);
echo "</nobr></td></tr>";
?>
</table>
Now I want make dropdown menu above which has all junior teams inside
(junior teams token comes from the mysql field "jugend" and is e.g. A,
B, etc.).

When a user selects e.g. "B" from this dropdown only the lines which
has "B" in the "jugend"-field should be displayed.

How can I do that?

Thanks

Regards,
Jagg

[Philipp Lenssen]

jagg wrote:

How can I do that?

To let you know your title was German...

--
Google Blogoscoped
http://blog.outer-court.com

[Justin Koivisto]

jagg wrote:

With the following lines I generate a site whichs gives me ALL results

Code:
<table border="0" cellspacing="1" cellpadding="2" class="content"
width="100%">
<?
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Order By b.jugend ASC Limit $eintrag,$zps";
$ergebnis = mysql_query($sqlbefehl, $serverid);
while ( $spiel = mysql_fetch_array ($ergebnis)) {
echo "<tr>";
//Jugendmannschaft
echo "<td align=\"center\" class=\"left\" bgcolor=\"$c_right\">";
echo $spiel['jugend'];
echo "</td>";
//Spieltag
echo "<td align=\"center\" class=\"right\" bgcolor=\"$c_right\">";
echo $spiel['sptag'];
echo "</td>";
//Datum ###########:
echo "<td align=\"center\" class=\"left\" bgcolor=\"$c_left\"><font
size=\"1\"><nobr>";
echo date("d.m.Y",$spiel[spdatum]+$time_offset);
echo "</nobr></td></tr>";
?>
</table>

Now I want make dropdown menu above which has all junior teams inside
(junior teams token comes from the mysql field "jugend" and is e.g. A,
B, etc.).

When a user selects e.g. "B" from this dropdown only the lines which
has "B" in the "jugend"-field should be displayed.

How can I do that?

Add a form on the page:

<form>
<select name="opt">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select>
<input type="submit" value="View">
</form>

Then in the code, change to something like this:

if(isset($_GET['opt'])){
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Where b.jugend = '{$_GET['opt']}' Limit $eintrag,$zps";
}else{
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Order By b.jugend ASC Limit $eintrag,$zps";
}

HTH

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.

[jagg]

Justin Koivisto <sp**@koivi.com> wrote in message news:<xd******************@news7.onvoy.net>...

Add a form on the page:

<form>
<select name="opt">
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
</select>
<input type="submit" value="View">
</form>

Then in the code, change to something like this:

if(isset($_GET['opt'])){
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Where b.jugend = '{$_GET['opt']}' Limit $eintrag,$zps";
}else{
$sqlbefehl= "Select *
From $jugendtab b
Left Outer Join $tab_user u on u.id=b.autor
Order By b.jugend ASC Limit $eintrag,$zps";
}

HTH

THANKS YOU VERY MUCH!!!!

It works!

Jagg