MySQL RSS MySQL RSS

Retreiving Information ASAP

Reply

•
•
Join Date: Aug 2008
Posts: 4
Reputation: Farismkhalid is an unknown quantity at this point 
Solved Threads: 0
Farismkhalid Farismkhalid is offline Offline
Newbie Poster

Retreiving Information ASAP

 
0
  #1
Nov 24th, 2008
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,
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Retreiving Information ASAP

 
0
  #2
Nov 24th, 2008
MySql 2000? or MSSQL 2000?

also, what language are you using?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 4
Reputation: Farismkhalid is an unknown quantity at this point 
Solved Threads: 0
Farismkhalid Farismkhalid is offline Offline
Newbie Poster

Re: Retreiving Information ASAP

 
0
  #3
Nov 24th, 2008
•
•
•
•
Originally Posted by dickersonka View Post
MySql 2000? or MSSQL 2000?

also, what language are you using?
mssql 2000
im planing on using HTML or XML
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Retreiving Information ASAP

 
0
  #4
Nov 24th, 2008
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
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 4
Reputation: Farismkhalid is an unknown quantity at this point 
Solved Threads: 0
Farismkhalid Farismkhalid is offline Offline
Newbie Poster

Re: Retreiving Information ASAP

 
0
  #5
Nov 24th, 2008
•
•
•
•
Originally Posted by dickersonka View Post
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
asp Syntax (Toggle Plain Text) 
  1. <%
  2.  
  3. '* database server parameters
  4. Dim serverIP '* ip adress
  5. Dim serverPORT '* ip port
  6. Dim serverDB '* catalog/database name
  7. Dim serverLOGIN '* username
  8. Dim serverPASSWORD '* password
  9.  
  10. '* set your variables here
  11. serverIP = "192.168.100.1"
  12. serverPORT = "1433" '* default port is 1433/TCP
  13. serverDB = "Northwind"
  14. serverLOGIN = "login"
  15. serverPASSWORD = "pass"
  16.  
  17. '* open connection
  18. Dim con
  19. Set con = Server.CreateObject("ADODB.Connection")
  20. con.ConnectionString = "Provider=SQLOLEDB.1;" & _
  21. "Persist Security Info=False;" & _
  22. "Network Library=DBMSSOCN;" & _
  23. "Data Source=" & serverIP & "," & serverPORT & ";" & _
  24. "Initial Catalog=" & serverDB & ";" & _
  25. "User ID=" & serverLOGIN & ";" & _
  26. "Password=" & serverPASSWORD & ";" & _
  27. "Connect Timeout=5;Pooling=False"
  28. Call con.Open()
  29. %>

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
Last edited by peter_budo; Nov 28th, 2008 at 12:24 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Retreiving Information ASAP

 
0
  #6
Nov 24th, 2008
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
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MySQL Forum
Thread Tools Search this Thread



agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groupware hiring hyperic images innerjoins insert ip joebrockmeier join keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC