<% Set rsPlayers = Server.CreateObject("ADODB.Recordset") rsPlayers.ActiveConnection = con_string sqlstringPlayers="SELECT Clubs.Name as clubname, Countrylist.countryname, Coaches.ID,Coaches.FullName, Coaches.Picture, Coaches.Mobile, Coaches.Telephone, Coaches.Address, Coaches.City, Coaches.eMail, Coaches.Height, Coaches.Weight, Coaches.CV_English, Coaches.CV_Portuguese, Coaches.CV_Arabic, Coaches.CV_Russian, Coaches.CV_Korean, Coaches.Videofilename FROM (Coaches LEFT JOIN Clubs ON Coaches.Club = Clubs.ID) LEFT JOIN Countrylist ON Coaches.Country = Countrylist.ID;" rsPlayers.Source = sqlstringPlayers rsPlayers.CursorType = 0 rsPlayers.CursorLocation = 2 rsPlayers.LockType = 1 rsPlayers.Open() %>

» <%=pagename%>

<% ctr=1 do while not rsPlayers.eof playername=rsplayers("FullName") Picture=rsplayers("Picture") Club=rsplayers("clubname") Height=rsplayers("Height") Weight=rsplayers("Weight") Video=rsplayers("Videofilename") CV_Portuguese=rsplayers("CV_Portuguese") CV_Arabic=rsplayers("CV_Arabic") CV_Russian=rsplayers("CV_Russian") CV_Korean=rsplayers("CV_Korean") CV_English=rsplayers("CV_English") p_id= rsplayers("id") %> <%if ctr=1 then response.write ""%> <% ctr=ctr+1 if ctr=4 then response.write "" ctr=1 end if%> <% rsplayers.movenext loop %>
<%if Picture<>"" then%>
<%end if%> <%if playername<>"" then%> Name : <%=playername%>
<%end if%> <%if Club<>"" then%> Club : <%=Club%>
<%end if%> <%if Height<>"" then%> Height : <%=Height%> <%end if%> <%if height<>"" and weight<>"" then%> , <%end if%> <%if Weight<>"" then%> Weight : <%=Weight%> <%end if%> <%if Video<>"" then%>
Video: Click Here <%end if%>