Please Help Out .. Db Problim

Stefan Vorster · Dec 3, 2003

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

Ray at · Dec 3, 2003

select distinct [user] from theTable

Ray at home

Bhaskardeep Khaund · Dec 3, 2003

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 %>

Jeff Cochran · Dec 3, 2003

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

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

Help please	8	Jul 6, 2023
Authority in GoDaddy shared server DB	1	Jul 20, 2025
Please, help me.	1	Jun 30, 2021
How can I find out the id of the first record in a database table, assuming record 1 is deleted?	2	Aug 27, 2025
Can someone pls help me with a little algorithm script	1	Nov 28, 2024
Code help please	4	May 19, 2023
Hello and Help please :-)	1	Jul 16, 2022
Troubles with Fullpage / please help	0	Dec 14, 2023

Please Help Out .. Db Problim

Stefan Vorster

Ray at

Bhaskardeep Khaund

Jeff Cochran

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads