[SOLVED] usimg order by

[contra10]

im trying to search mysql in a way that is ordered by one of my rows...the first part of the code works well but if i isset another area and do the same orderinging i get a msqlfetch error

 

<?php
$query = "SELECT * FROM `events` WHERE `country`='$postcountry' and `continent`='$postcontinent' and `state_province` = '$poststate' and `val`= 'true' and `evcategory`='$posteva' ORDER BY dateofevsearch ASC";
if(isset($_POST['submit']) and ($_POST['continent']) and ($_POST['country']) and ($_POST['state']) and ($_POST['eva']) and ($_POST['event']) and ($_POST['city'])){$query .= "and `evcity` = '$postcity' ORDER BY dateofevsearch ASC";}
?>
['code]

[.josh]

remove the order by ... from both parts of your code and concat it to your query after the condition.

[gevans]

try this

 

<?php
$query = "SELECT * FROM `events` WHERE `country`='$postcountry' and `continent`='$postcontinent' and `state_province` = '$poststate' and `val`= 'true' and `evcategory`='$posteva'";
if(isset($_POST['submit']) and ($_POST['continent']) and ($_POST['country']) and ($_POST['state']) and ($_POST['eva']) and ($_POST['event']) and ($_POST['city'])){$query .= " and `evcity` = '$postcity'";}
$query .= " ORDER BY dateofevsearch ASC";
?>