Tu mam wyswietlanie na stronce zawartości tabeli:
Kod
$result = mysql_query("SELECT `id`, `imie`, `nazwisko`, `firma` FROM `klienci");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print '<table><tr>
<td width=15 align="center">
<input type="radio" name="idselect" value="'.$row["id"].'"' . ($_POST['idselect'] == $row["id"] ? ' checked="checked"' : '') . ' />
</td>';
print '<td width="30" align="center">'.$row[id].'</td>
<td width="100" align="center">'.$row[imie].'</td>
<td width="100" align="center">'.$row[nazwisko].'</td>
<td width="100" align="center">'.$row[firma].'</td>';
print '</tr></table>';
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
print '<table><tr>
<td width=15 align="center">
<input type="radio" name="idselect" value="'.$row["id"].'"' . ($_POST['idselect'] == $row["id"] ? ' checked="checked"' : '') . ' />
</td>';
print '<td width="30" align="center">'.$row[id].'</td>
<td width="100" align="center">'.$row[imie].'</td>
<td width="100" align="center">'.$row[nazwisko].'</td>
<td width="100" align="center">'.$row[firma].'</td>';
print '</tr></table>';
}
Tak wyglada select:
Kod
<select name="sortowanie1">
<option value="sort_firmy" <? print (strcmp($_POST['sortowanie1'], 'sort_firmy')?'':' SELECTED'); ?> >Firmy</option>
<option value="sort_id" <? print (strcmp($_POST['sortowanie1'], 'sort_id')?'':' SELECTED'); ?> >Id</option>
</select>
<select name="sortowanie2">
<option value="sort_rosnaco" <? print (strcmp($_POST['sortowanie2'], 'sort_rosnaco')?'':' SELECTED'); ?>>Rosnaco</option>
<option value="sort_malejaco"<? print (strcmp($_POST['sortowanie2'], 'sort_malejaco')?'':' SELECTED'); ?>>Malejaco</option>
</select><input type="submit" name="button_sortuj" value="sortuj">
<option value="sort_firmy" <? print (strcmp($_POST['sortowanie1'], 'sort_firmy')?'':' SELECTED'); ?> >Firmy</option>
<option value="sort_id" <? print (strcmp($_POST['sortowanie1'], 'sort_id')?'':' SELECTED'); ?> >Id</option>
</select>
<select name="sortowanie2">
<option value="sort_rosnaco" <? print (strcmp($_POST['sortowanie2'], 'sort_rosnaco')?'':' SELECTED'); ?>>Rosnaco</option>
<option value="sort_malejaco"<? print (strcmp($_POST['sortowanie2'], 'sort_malejaco')?'':' SELECTED'); ?>>Malejaco</option>
</select><input type="submit" name="button_sortuj" value="sortuj">
Tak wyglada obsługa buttona:
Kod
if(!empty($_POST['button_sortuj']))
{
if (($sortowanie1 == 'sort_firmy') && ($sortowanie2 == 'sort_rosnaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`firma` ASC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_firmy') && ($sortowanie2 == 'sort_malejaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`firma` DESC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_id') && ($sortowanie2 == 'sort_rosnaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`id` ASC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_id') && ($sortowanie2 == 'sort_malejaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`id` DESC;";
$R = mysql_query($Q);
}
{
if (($sortowanie1 == 'sort_firmy') && ($sortowanie2 == 'sort_rosnaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`firma` ASC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_firmy') && ($sortowanie2 == 'sort_malejaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`firma` DESC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_id') && ($sortowanie2 == 'sort_rosnaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`id` ASC;";
$R = mysql_query($Q);
}
elseif (($sortowanie1 == 'sort_id') && ($sortowanie2 == 'sort_malejaco'))
{
$Q = "SELECT * FROM `klienci` ORDER BY `klienci`.`id` DESC;";
$R = mysql_query($Q);
}