[SOLVED] DESC & ASC

[DEVILofDARKNESS]

I want to make a form with two radio buttons.

Sort: A-Z [button] Z-A [button];

 

and in the same page I wanna connect to my database and let see the cols DESC or ASC?

 

I was thinking of something like this:

<form action='gedichten.php' method='POST'>
			From Z To A: <input type="radio" name="ZA" value="ZA" CHECKED>
			From A To Z: <input type="radio" name="AZ" value="AZ">
		</form>
                    <?php
require_once 'config.php';                // our database settings
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
        or die('Error connecting to mysql');
mysql_select_db($dbname);
if($_POST['ZA']) {
	$query = sprintf("SELECT PName,UName,PText,URL,category From gedichten ORDER BY PName DESC");
	$result = mysql_query($query);
	while($urlgedicht = mysql_fetch_array($result)) {
		print "<ul><li><a href={$urlgedicht['category']}/{$urlgedicht['URL']}.htm>{$urlgedicht['PName']} | {$urlgedicht['UName']} | {$urlgedicht['category']}</a></li></ul>";
	}
} elseif($_POST['AZ']) {
	$query = sprintf("SELECT PName,UName,PText,URL,category From gedichten ORDER BY PName ASC");
	$result = mysql_query($query);
	while($urlgedicht = mysql_fetch_array($result)) {
		print "<ul><li><a href={$urlgedicht['category']}/{$urlgedicht['URL']}.htm>{$urlgedicht['PName']} | {$urlgedicht['UName']} | {$urlgedicht['category']}</a></li></ul>";
	}
} else {
	print "<script type='text/javascript'>alert('There was an error while trying to give an overview!');</script>";
}
?>

,

 

but it doesn't work at all.

 

[printf]

All radio buttons referring to a single option must have the same name, only values should be different...

 

A quick example...

 

<form action='gedichten.php' method='post'>
From Z To A: <input type="radio" name="order" value="ZA" CHECKED>
From A To Z: <input type="radio" name="order" value="AZ">
</form>
<?php

$order  = 'asc';

require_once 'config.php';

$conn = mysql_connect ( $dbhost,$dbuser,$dbpass ) or die ( 'Connection Error: ' . mysql_error () );

mysql_select_db ( $dbname ) or die ( 'Select Database Error: ' . mysql_error () );

if ( isset ( $_POST['order'] ) )
{
if ( $_POST['order'] == 'ZA' )
{
	$order = 'desc';
}
else if ( $_POST['order'] == 'AZ' )
{
	$order = 'asc';
}
}

$result = mysql_query ( "SELECT PName, UName, PText, URL, category From gedichten ORDER BY PName " . $order . ";" ) or die ( 'Query Error: ' . mysql_error () );

if ( mysql_num_rows ( $result ) == 0 )
{
echo "<script type='text/javascript'>
	alert('There was an error while trying to give an overview!');
</script>
";
}
else
{
while ( $urlgedicht = mysql_fetch_assoc ( $result ) )
{
	echo "	<ul>
	<li>
		<a href='" . $urlgedicht['category'] . "/" . $urlgedicht['URL'] . ".htm'>" . $urlgedicht['PName'] . " | " . $urlgedicht['UName'] . " | " . $urlgedicht['category'] . "</a>
	</li>
</ul>
";
}
}

?>

 

 

Next time don't double post, wait for someone to answer you and if they don't after a day, bump your post then!

[Zane]

well I'll take you word for it...it probably doesn't work, but you'd get better results if you changed your code to this

</pre>
<form action="'gedichten.php'" method="'POST'">
            From Z To A: 
            From A To Z: 
</form>
<br>                    require_once 'config.php';                // our database settings<br>$conn = mysql_connect($dbhost,$dbuser,$dbpass)<br>        or die('Error connecting to mysql');<br>mysql_select_db($dbname);<br>   if(isset($_POST['sort'])) {<br>      $query = sprintf("SELECT PName,UName,PText,URL,category From gedichten ORDER BY PName" . $_POST['sort']);<br>      $rresult = mysql_query($query);<br>      while($urlgedicht = mysql_fetch_array($result))<br>         print "<ul>{$urlgedicht['PName']} | {$urlgedicht['UName']} | {$urlgedicht['category']}</ul>";<br>   } else {<br>      print "<script type="'text/javascript'">alert(&#039;There was an error while trying to give an overview!&#039;);</script>";<br>   }<br>?&g

related radio buttons need to all have the same name