How to design a page to access my sql database?

[gbodson]

Well, I use Golive 6 as a design tool, I did not learn any HTML or Java, I just copied things then tried to understand them and duplicate... I did this for a few month now. I work on a site in Spanish www.disjucan.com. I am offering a library account for Canarian Lawyers, Untill now I did it all on paper but sometimes things changes. I would like to offer my customers an access to a page for them, with their details, how much they spent, how much do they have left for spending etc... ( My clients pay a monthly fee which gives them credit up to 10 times the monthly fee...with no interest) but PHp / sql is a bit confusing.
I am used to work this way:I do something small test it and make it work and then I apply it to what I really want.
I am looking for a sample design and database to start to play and learn....
any tip is more than welcomed.

If you want to travel to Gran Canaria check this page i did too: www.casadelmoral.gpbmarketing.com

cheers

[cyanide]

There's alot more involved than just the design of the pages, the structure of the database is extremely important. Not having the properly configured database from the get-go could mean huge head-aches down the road.

Your first stop should be www.hotscripts.com
There's lots of free scripts available, and I'm quite sure you'll find one that suits your needs.

It's also a great way to learn php/MySQL

[iterator]

This one is for all you VBS guru's. I was running into the problem of creating a DSN for mySQL on a server i had no control of. Later i found out there was a mySQL driver for Chillisoft. The best part is there is no DSN no dual authentication from the script to the dsn then to the server. The driver connects the script directly to the server, dramtically decreasing the response time on the mySQL ASP App. The following connection string may not apply to your sepcific application but it has helped me link Apache Chillisoft and MySQL.

objConn.Open "Driver={MySQL};SERVER=127.0.0.1; DATABASE=MyDB; UID=username; PWD=password"
objConn.Execute (strSQL)

[gbodson]

Thank you,

the only way for me to learn and understand is to put my hands into it, fail, fail again then understand and control...

thank you for the adress.

________________
GPB Marketing
"Sencillamente Soluciones..."
www.gpbmarketing.com
www.disjucan.com

[redcircle]

if you are interested in learning for yourself see

www.phpbuilder.com
www.devshed.com