View Single Post
Old 03-06-2007, 12:06 PM   #21 (permalink)
redhead
Newbie
 
redhead's Avatar
 
Join Date: Jun 2002
Location: Denmark
Posts: 1,709
redhead is on a distinguished road
Quote:
I was joking with you about the $160/hr. because I read in one of your replies to the PHP coder thread
heh, I hadn't even noticed that part of your reply..
I read half way through it, befor I started forming my answer
Quote:
Now what I don't understand is where do I write the SQL code to setup the database and tables of information?
I usualy keep it as a text file on my server, that way I have a way of confirming how my tables are formed, when in 6 month, I want to alter something, instead of quering the database to see what is structured I can look at my text file.

But you could write it interactively into the MySQL interface if you wanted to, or you could use something like phpMyadmin.
The thing is, the database-table structuring, is a one time _only_ activation, so it is very unwise to call it from within any activation where you can't control how many times it will be called.
Quote:
Can I make a database in Access and have the Confirmation page and/or Order page query that to display whatever info I need to show to the customer on the Confirmation page?
Sorry, this can not be done, PHP (as of PHP4) only supports the following databases
Quote:
I have many many many more ideas and features I want to add to this website
Naturaly, it is understandable that you want to develop your site, into something you can be proud of. And I'm sure, once you get a feel for how PHP/SQL interacts, you'll realise the beauty of having dynamicaly created pages.
__________________
Don't worry Ma'am, We're university students, We know what We're doing.
-----
If you pull the pin, Mr.Grenade would no longer be your friend.
-----
01000111 01101111 00100000 01000011 00100000 00100001
redhead is offline   Reply With Quote