[RESOLVED] Ordering a colum, depending on a nother colum??

[gszauer]

<?php
$server = "localhost";
$user = "program";  

$pass = "*******";
$database = "program_program";
$tableName = "db_x";


$conn = @mysql_connect($server,$user,$pass); 
$database = @mysql_select_db($database,$conn); 


$query = @mysql_query("SELECT * FROM $tableName ORDER BY id WHERE listing=home"); 
$total_rows = @mysql_num_rows($query); 
$counter = 0; 
while($ourData = @mysql_fetch_array($query)){ 
     $id = $ourData["id"]; 
     $tn = $ourData["tn"]; 
     $sold = $ourData["sold"]; 
     $listing = $ourData["listing"];
     $description = $ourData["description"];
     $price = $ourData["price"];
     $address = $ourData["address"];
     $counter++; 
     print("&id$counter=$id&id$counter=$id&tn$counter=$tn&sold$counter=$sold&listing$counter=$listing&description$counter=$description&price$counter=$price&address$counter=$address"); 
} 

print("&total=$total_rows"); 
?>

Here is my problem:
$query = @("SELECT FROM $tableName ORDER BY id ");
Works just fine, now i only need the rows where the listing colums value equals home, so i made the code into
$query = @("SELECT FROM $tableName ORDER BY id WHERE listing=home");
But it doesnt work if i do that...
Can anyone help?
thank you for your time
~Gabor Szauer

[programmer79]

Your query is not formatted properly. You should always place the order by at the end. Good Luck!

SELECT * FROM $tableName WHERE listing=home ORDER BY id

[gszauer]

In case someone has a simular problem, the proper code is
SELECT * FROM $tableName WHERE listing='home' ORDER BY id
(Need the ' ' s in there)
Thanks for the help programmer79