Retreiving Information ASAP

[Farismkhalid]

hello guys,

i know all of you are gurus at this as for i am a rookie,
i am currently using MySQL 2000
and i would like to retreive information from the database from a certain table via an HTML website
what are the scripts that i could run to
1. connect to the database,
2. link some information from the website with a table column.
2. Retreive that infromation, from that table cell;
3. post it on the website
and
4.IF i recieve a succeed response clear that information from the table cell.

Your response is highly appreciated Please!
im currently trying to work something out and this is of real importance to me.

Thanks in advance,

[dickersonka]

MySql 2000? or MSSQL 2000?

also, what language are you using?

[Farismkhalid]

MySql 2000? or MSSQL 2000?

also, what language are you using?

mssql 2000
im planing on using HTML or XML

[dickersonka]

i guess i misspoke, you are going to query a database and what language are you planning on using for that?

also you need to make an effort and show us what you got so far, we won't do it for you

[Farismkhalid]

i guess i misspoke, you are going to query a database and what language are you planning on using for that?

also you need to make an effort and show us what you got so far, we won't do it for you

Im planning on using ASP or XML but im such a rookie i have no one to guide me, for asp i have this to connect to a database

<%

'* database server parameters
Dim serverIP '* ip adress
Dim serverPORT '* ip port
Dim serverDB '* catalog/database name
Dim serverLOGIN '* username
Dim serverPASSWORD '* password

'* set your variables here
serverIP = "192.168.100.1"
serverPORT = "1433" '* default port is 1433/TCP
serverDB = "Northwind"
serverLOGIN = "login"
serverPASSWORD = "pass"

'* open connection
Dim con
Set con = Server.CreateObject("ADODB.Connection")
con.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=" & serverIP & "," & serverPORT & ";" & _
"Initial Catalog=" & serverDB & ";" & _
"User ID=" & serverLOGIN & ";" & _
"Password=" & serverPASSWORD & ";" & _
"Connect Timeout=5;Pooling=False"
Call con.Open()
%>

I dont know what to use to retreive data and clear etc...

the main scenario is, that i have to put this all in an XML portal and query the database retreive info and delete info upon a certain condition.
your help on how to tackle it would be great

[dickersonka]

i would suggest closing this post and starting it in the ASP.net forum, also when you create that post, be specific with what issue you are having, not just lay it out all at once

if you can't connect then say that, if you can't create a query then say that