var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select fields and create temp field.
Sory, I dont knew how to start but anyway. my problem is somthing like dis.
I have a table and a field and im using mysql 5.0.3.
I want a result like dis.
field1 field2 ,tempfield
aaaa test1 1
bbbb test3 2
cccc test4 3
mmmm test7 4
lllll test8 5
Please be more precise:
1) what is the sort type and order on which column
2) what should happen with ties (i.e. when two or more values are the same w.r.t. the sort type and order)
Just in any order in my sample table has just only 2 fields. Pls look at my query.
select *,_temp_incrementfield from tablename
but i dont knw how to increment in select statement. Sory for my english.
I meant you need an ORDER BY. E.g.
Originally Posted by popskie
SET @rank := 0;
field1, field2, @rank := @rank+1
ORDER BY field2;
thats it , nice shoot . Thanks for the rep.