Monorail Problem

[Strats]

One of my staff members accidental deleted a couple of my cities.

When he could of just edited them instead lol

So I inserted them back in to the game with a Sql making sure the city Id's were the same as before.

But now the monorail is not how I want it to be.

Rock City For the top superstars 70 Go

Quake Town Time to kick ass. 270 Go

Razors Edge A place for the strong. 200 Go

Ov Avenue Work hard and train here. 150 Go

Ex State A place for the calm. 175 Go

Legends Way Make way for a legend. 300 Go

Is there any way I can make the city list go back in to order like this :

Rock City For the top superstars 70 Go Check Weather

Ov Avenue Work hard and train here. 150 Go Check Weather

Ex State A place for the calm. 175 Go Check Weather

Quake Town Time to kick ass. 270 Go Check Weather

Razors Edge A place for the strong. 200 Go Check Weather

Legends Way Make way for a legend. 300 Go

[Feky]

Re: Monorail Problem

go to you sql table in phpmyadmin and delete one city at a time and add it after the one you want it after its quite simple really

[Dave]

Re: Monorail Problem

Add an order thing to your cities table then modify your code to order by the order number (That sounds confusing lol)

[Strats]

Re: Monorail Problem

I already tried Feckys idea, Still the same.

Sky, yes that sounds confusing lol

[Voice4Vision]

Re: Monorail Problem

Send me both the file and sql for the monorail and I will fix it up for you.

[AlabamaHit]

Re: Monorail Problem

You just want it to order by city level?

Add this to end of your Query,

v2

$q=$db->query("SELECT * FROM cities WHERE cityid != {$ir['location']} AND cityminlevel <= {$ir['level']} ORDER BY cityminlevel ASC");

[Miniman]

Re: Monorail Problem

Just to clear up what AlabamaHit said......You need to add this:

 

ORDER BY cityminlevel ASC

 

To the end of the above query :)

Or just replace the whole query with what AlabamaHit posted

[Strats]

Re: Monorail Problem

Thanks, got it sorted :)