Tekster & produkter random ?

Bruger du mysql?

function GetRandomText()
 
  strSQL = \"SELECT Count(id) as antal form tabel\"
  set oRs = connect.execute(strSQL)

  Randomize()
  intMove = Int((oRs(\"antal\") - 1 + 1) * Rnd + 1) - 1

set oRs = nothing 

  strSQL = \"SELECT * From tabel\"
set oRs = connect.execute(strSQL)
oRs.move intMove

response.write oRs(\"tekst\")




end function

jeg formoder du ved hvad dine tabeller og kolonner hedder.

function GetRandomText()
 
  strSQL = \"SELECT Count(id) as antal form tabel\"
  set oRs = connect.execute(strSQL)

  Randomize()
  intMove = Int((oRs(\"antal\") - 1 + 1) * Rnd + 1) - 1

set oRs = nothing 

  strSQL = \"SELECT * From tabel\"
set oRs = connect.execute(strSQL)
oRs.move intMove

response.write oRs(\"tekst\")
set oRs = nothing



end function

I mysql er det bare:

SELECT * FROM table ORDER BY RAND();

Du er nok nødt til at putte en limit på også:

SELECT * FROM table ORDER BY RAND() LIMIT 1;

Mine tabeller hedder \"tekster\" og kolonnerne hedder \"nr\"
databasen hedder\"tekster.mdb\"

skal det se således ud når

databasen hedder \"tekster.mdb\"
tabellen hedder \"tekster\"
id hedder \"nr\"
selveteksten hedder \"indhold\"

function GetRandomText()
 
  strSQL = \"SELECT Count(id) as nr form tabel\"
  set oRs = connect.execute(strSQL)

  Randomize()
  intMove = Int((oRs(\"nr\") - 1 + 1) * Rnd + 1) - 1

set oRs = nothing 

  strSQL = \"SELECT * From tabel\"
set oRs = connect.execute(strSQL)
oRs.move intMove

response.write oRs(\"indhold\")
set oRs = nothing

end function

nej sådan her:

function GetRandomText()
 
  strSQL = \"SELECT Count(nr) as antal form tekster\"
  set oRs = connect.execute(strSQL)

  Randomize()
  intMove = Int((oRs(\"antal\") - 1 + 1) * Rnd + 1) - 1

set oRs = nothing 

  strSQL = \"SELECT * From tekster\"
set oRs = connect.execute(strSQL)
oRs.move intMove

response.write oRs(\"indhold\")
set oRs = nothing

end function