[SOLVED] ORDER BY fails :(

[wmguk]

Hey,

 

$orderby is set using a form.

$orderby = (empty($_POST['orderby'])) ? "name ASC" : $_POST['orderby'] ;

 

then the actual form

<form action="../show_tile.php" method="POST" name="search">
            <input type="image" name="orderby" value="name ASC" src="../images/asc.gif" />
            <input type="hidden" name="colour" value="<? echo $colour ; ?>" />
          </form>
<form action="../show_tile.php" method="POST" name="search">
            <input type="image" name="orderby" value="name DESC" src="../images/desc.gif" />
            <input type="hidden" name="colour" value="<? echo $colour ; ?>" />
          </form>

 

I am using this query:

$result = mysql_query("SELECT * FROM products WHERE colour = '$colour' ORDER BY $orderby");

 

I checked it using a GET and its not passing the variable orderby -

<input type="image" name="orderby" value="name ASC" src="../images/asc.gif" />

 

any thoughts what Ive missed?

[wmguk]

scrub that, i sorted it. just set a hidden type.