Order one, then another, then another

[tibberous]

I have a table with several types in an enum, lets say Stores, Offices and Restaurants.

 

I can order by desc, and get Offices, Restaurants, Stores. I can order by asc and get Stores, Restaurants, Offices.

 

Lets say though I wanted Restaurants, Stores, Offices. Is there a way I can say, return X, then Y, then Z?

[ChompGator]

 

Yep use something like this

 

<tr> 
<td style="width: 279px"> 
<table class="top"> 
<tr> 
<td style="width: 95px" class="style10"><strong>Resturant</strong></td> 
<td style="width: 93px" class="style10"><strong>Stores</strong> </td>
<td style="width: 93px" class="style10"><strong>Officies</strong></td>
</tr> 
<? 
mysql_connect("***","**","**");//database connection 
mysql_select_db("legion"); 
                 
$order = "SELECT * FROM tbl_name ORDER BY RESTURANT";  // Where I put Resturant you can change that to stories, offices etc.. 
$result = mysql_query($order);   
while($data = mysql_fetch_row($result)){ 
  echo("<tr><td>$data[0]</td><td>$data[6]</td><td>$data[7]</td><td>$data[1]</td></tr>");  
} 
?> 

 

Above where you see the <Td>$data[0]</td>

where you see the number in the brackets, change that to the column number of whatever columns in your my-sql db

[Mchl]

I don;t believe this query will work... RESTAURANT is not a column name here...

 

Here's alink PFMaBiSmAd showed us yesterday.

http://www.eklekt.com/tutorials/mysql

[ChompGator]

Oh,  Yep

 

Mchl is right...

 

My script will ONLY work if you are retrieving data from an SQL database, if you just have a table with data on a webpage - this query wont work he is right!

 

Thanks!

 

 

[tibberous]

I don;t believe this query will work... RESTAURANT is not a column name here...

 

Here's alink PFMaBiSmAd showed us yesterday.

http://www.eklekt.com/tutorials/mysql

 

Awesome!