Please Help Out .. Db Problim

#1 July 19th, 2005, 09:54 AM

Ok i have a table in a database that looks like this

Id , user , Time
1 test 200312341
2 test 324234234
3 userna 232837872

But i just wanne show on the page

test
userna

How can i do that

#2 July 19th, 2005, 09:55 AM

select distinct [user] from theTable

Ray at home

"Stefan Vorster" <doggy@webmail.co.za> wrote in message
news:01a401c3b96c$bcaa26a0$a001280a@phx.gbl...[color=blue]
> Ok i have a table in a database that looks like this
>
> Id , user , Time
> 1 test 200312341
> 2 test 324234234
> 3 userna 232837872
>
> But i just wanne show on the page
>
> test
> userna
>
> How can i do that[/color]

#3 July 19th, 2005, 09:55 AM

Hi,

Paste this code into a new asp file. Set you Database Connection(objConn) and put your table names.

<html>
<head><title></title></head>
<body>
<table width="80%" align="center">
<%
Dim id, objRs
id = Trim(Request.Form("id"))
sql = "select * from table_name "
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objConn
while not objrs.EOF
%>
<tr>
<td><%=objRs("id")%></td>
<td><%=objRs("user")%></td>
<td><%=objRs("time")%></td>
</tr>
<%objrs.MoveNext
Wend
%>
</table>
</body>
</html>
<%Set objRs = Nothing %>

#4 July 19th, 2005, 09:55 AM

On Tue, 2 Dec 2003 23:11:56 -0800, "Stefan Vorster"
<doggy@webmail.co.za> wrote:
[color=blue]
>Ok i have a table in a database that looks like this
>
>Id , user , Time
>1 test 200312341
>2 test 324234234
>3 userna 232837872
>
>But i just wanne show on the page
>
>test
>userna
>
>How can i do that[/color]

How are you currently showing everything? Either just select the User
column in your SQL query, or when your query returns everything, just
display the user column.

SELECT user FROM table
{Display the whole record set using GetString()}

- or -

SELECT * FROM table
{Display only the User field in a loop}

I prefer the former, you might look at:

http://www.aspfaq.com/show.asp?id=2467

Jeff

What is Bytes?

Popular Articles