SQL and FP2003

D

dragon2309_2

New Member
Hi everyone, i am in a bit of a pickle at the moment. I have an ODBC compliant MySQL database with products in. They have stock codes and descriptions and stock counts. What i need to do is somehow tell frontpage 2003 to connect to the database and look at a certain field in a certain record.

EXAMPLE: Say for product "BR101" i wanted the stock count to be displayed on a webpage, there are 5 of them in stock and i want this number to be displayed in a way that if i change the value in the database it will update automatically on page refresh.

I am already running Windows Server 2003; Enterprise edition Corporate (build 3790) and have the latest ASP.NET and IIS 6.0 installed. I also have Windows SharePoint Services installed.

Any help would be greatly appreciated, thanks a lot.
 
Anybody any ideas, even if its nt a direct answer to the question, just a metion of what language would be used, i assume its PHP. Any of you know any ttorials for PHP. HELP!!

*EDIT* And in case your wondering, the 1st post was me aswell just on a temporary account. :)
 
So, have you any idea if i can get a list of what contents there is in a SQL table on a webpage, i am reading the tutorial on PHP and it doesnt seem to be covering that kind of stuff. Basically i have a table of bracelets for sale and i want to display only the ones that are in stock. Any ideas or sample code would be great.
 
You must log in or register to reply here.
Back
Top