[eluser]tnathos[/eluser]
Hi i have the next problem.
I have a table whit the next rows.
id, name
the id field, is an autoincrement and have 10 rows.. so i have 1, 2, 3,..10 in this table.
I need select only 3 rows, but i need select in mode random the rows for example id =2, id=7, id=10, and if again run the select id=4,id=1,id=8.. etc.
for the random i include the sentece select into (for) and send the parameter id using a variable random 1 to 10.. but how i cant get the result and put in a structure for union the others results and retunr to the view?
thanks for the advance