RE: [PHP] divide-column?

2005-08-30 Thread Murray @ PlanetThoughtful
> Murray @ PlanetThoughtful wrote: > >>Hi there! > >> > >>How do I do a sort in PHP where a column in a db must be two other > columns > >>divided...`? > > > > > > > > > > Hi Gustav, > > > > You should be able to use the divide operation in your query's ORDER BY > > clause. > > > > Eg > > > > SELE

Re: [PHP] divide-column?

2005-08-30 Thread Jasper Bryant-Greene
Murray @ PlanetThoughtful wrote: Hi there! How do I do a sort in PHP where a column in a db must be two other columns divided...`? Hi Gustav, You should be able to use the divide operation in your query's ORDER BY clause. Eg SELECT * FROM mytable ORDER BY (field1 / field2) You might ne

RE: [PHP] divide-column?

2005-08-30 Thread Murray @ PlanetThoughtful
> Hi there! > > How do I do a sort in PHP where a column in a db must be two other columns > divided...`? Hi Gustav, You should be able to use the divide operation in your query's ORDER BY clause. Eg SELECT * FROM mytable ORDER BY (field1 / field2) Regards, Murray --- "Lost in thought..."

[PHP] divide-column?

2005-08-29 Thread Gustav Wiberg
Hi there! How do I do a sort in PHP where a column in a db must be two other columns divided...`? I tried to use DIV-function in MySQL but it doesn't seem to work ): Of course, I can hard-code it, but i want this value because of sorting ten largest of the resultvalue. ($gradeJoke). Ten best