Need this to select all with 1 in online which works.
need it to post all with 1 online by name sort by level
currently i cant ewen get it to response.write.
as you may notice ive been playing with Dreamweaver 4 which is the reason of the MM formatting of the names in conn.
******** UPDATED CODE
<%@LANGUAGE="VBSCRIPT"%>
<% MM_wowevi_STRING = "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=HIDDEN; Uid=HIDDEN; Pwd=HIDDEN"
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
if (Request.Form("0") <> "") then Recordset1__MMColParam = Request.Form("0")
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.Source = "SELECT name FROM logon.characters WHERE online = 1 + Replace(Recordset1__MMColParam, "'", "''") + ""
%>
<% Response.Write Now %>
<% response.write (name) %>
<%
Recordset1.Close()
%>
P.S I just removed ALL HTML formating.
wondering if i can use something like
<% do while not eof %>
funktion such as response.write the list of players with 1 in online sorted by level
<% wend %>
or how would i go about that. ?