Forum PHP.pl

[HTML] pobierz, plaintext 
<form action="klienci.php" method="post">
    <select name="sortowanie1">
        <option value="id" >id</option>
        <option value="imie" >imie</option>
    </select><input type="submit" name="button_sortuj" value="sortuj">
</form>
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$R = mysql_query(&#092;"SELECT * FROM `klienci` ORDER BY `\".$_POST['sortowanie1'].\"` ASC\");
while ($row = mysql_fetch_array($R, MYSQL_ASSOC)) // wyswietlanie listy klientow
{
 
...
 
}
?>
[PHP] pobierz, plaintext 

Cytat(isso @ 30.01.2009, 00:56:57 )

[PHP] pobierz, plaintext 
<?php
$R = mysql_query(&#092;"SELECT * FROM `klienci` ORDER BY `\".$_POST['sortowanie1'].\"` ASC\");
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$query = &#092;"SELECT * FROM klienci ORDER BY \".$_POST['sortowanie1'].\" ASC\";
$R = mysql_query($query);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$R = mysql_query("SELECT * FROM `klienci` ORDER BY `".$_POST['sortowanie1']."` ASC");
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$query = "SELECT * FROM klienci ORDER BY ".$_POST['sortowanie1']." ASC";
$R = mysql_query($query);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
while ($row = mysql_fetch_array($R, MYSQL_ASSOC))
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$query = 'SELECT * FROM klienci ORDER BY "'.$_POST['sortowanie1'].'" ASC';
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
if(!empty($_POST['button_sortuj']))
{
$co = $_POST['sortowanie1'];
$query = "SELECT * FROM klienci ORDER BY $co ASC";
$R = mysql_query($query);
}
elseif(empty($_POST['button_sortuj']))
{
$query = "SELECT * FROM klienci ORDER BY imie ASC";
$R = mysql_query($query);
}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$query = "SELECT * FROM klienci ORDER BY ".$_POST['sortowanie1']." ASC";
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
if($_POST['sortowanie1']){
...
}
?>
[PHP] pobierz, plaintext