@EDIT: kemel van fout in script die ik net zelf zie. Dus laat maar.
Bedankt.
1.286 views
<tr>
<td colspan="8" align="center">
<input type="submit" value="Actieve leden" name="AL">
<input type="submit" value="Niet Actieve leden" name="NAL">
<input type="submit" value="Alle leden" name="A">
</td>
</tr>
<?php
if (empty($_POST['AL']) && empty($_POST['NAL']) && empty($_POST['A']))
{
$query = "SELECT * FROM leden WHERE LActief = False ORDER BY LNaam ASC";
}
elseif (isset($_POST['AL']))
{
$query = "SELECT * FROM leden WHERE LActief = False ORDER BY LNaam ASC";
}
elseif (isset($_POST['NAL']))
{
$query = "SELECT * FROM leden WHERE LActief = True ORDER BY LNaam ASC";
}
elseif (isset($_POST['AL']))
{
$query = "SELECT * FROM leden ORDER BY LNaam ASC";
}
$result = mysql_query($query);
while($rij = mysql_fetch_array($result))
<tr>
<td colspan="8" align="center">
<form action="leden_save.php?Action=Show" method="post">
<input type="submit" value="Actieve leden" name="AL">
<input type="submit" value="Niet Actieve leden" name="NAL">
<input type="submit" value="Alle leden" name="A">
</form>
</td>
</tr>
<?php
if(!isset($_POST['AL'], $_POST['NAL'], $_POST['A']) || isset($_POST['AL']))
{
$query = "SELECT * FROM leden WHERE LActief = True ORDER BY LNaam ASC";
}
elseif (isset($_POST['NAL']))
{
$query = "SELECT * FROM leden WHERE LActief = False ORDER BY LNaam ASC";
}
elseif (isset($_POST['A']))
{
$query = "SELECT * FROM leden ORDER BY LNaam ASC";
}
$result = mysql_query($query);
while($rij = mysql_fetch_array($result))
if (empty($_POST['AL'], $_POST['NAL'], $_POST['A']) || !empty($_POST['AL']))
{
$query = "SELECT * FROM leden WHERE LActief = True ORDER BY LNaam ASC";
}
elseif (!empty($_POST['NAL']))
{
$query = "SELECT * FROM leden WHERE LActief = False ORDER BY LNaam ASC";
}
elseif (!empty($_POST['A']))
{
$query = "SELECT * FROM leden ORDER BY LNaam ASC";
}