bring up phpMyAdmin

from the top of the menu to the left, click "SQL&quo t;. This will open a window. You'll see a box that has something like:
"SELECT * FROM WHERE 1" --> Delete that text where the box is now blank.

paste in this code:

Code:

Ok. Once the code is entered and I created the database. How do I set it up so my web page will access with usernames and passwords... I remember seeing a code for this, but might have disappeared when the site went off line for a couple days.

Its all in this tutorial:

Complete Members System

Read it though and give it a try. Work with it, and if you get stuck, come here and i'll help.

I guess my real problem is how to make the database connection. I know that you have to use a source code, but I am not sure how I do this or where I put it. I went to the database connection page, but it is pretty brief and over my head. Thanks for helping me by the way!!

this is how you can connect to the database. The inital connection is made with the mysql_connect() ; function, then selected by the mysql_select_db (); function. To make it simpler (in this code sample), variables are set for each parameter (database host, database username and pass, ect).

each time you wish to interact with the database, this code must be executed (makes the connection). You cannot query any data unless you are connected, so - thats why some just put this code in a file, and call upon it when they need to connect.

When you're connected, you can query the database for whatever you need, or execute functions to insert or delete data. Remember the "Introduction to SQL " tutorial, read up on that.

anything else, just ask.

Code:

But where do I put that code... In my html? Somewhere in my webshell?

Ok, whatever file you have, name it with a .php extension. If your file is index.html, rename it to index.php so the server side code is executed.

if it is a php file, html code will be executed as regularly, but when the browser comes across the php code, it is executed by the server and output to the browser as html.

Hi, I think I am close to understanding this...
my page is http://snatchsq uad.com/officer sclub.htm
I need to change it to a .php, which I understand. When I put the code you gave me in the html on frontpage, it just shows up on the page as text. What am I doing wrong.

yes, make your file name "officers club.php"

and when you want php code to be executed, start off with <? //php code in here, and end with ?> just like that. Also, make sure your host supports PHP. If your host does not support PHP on their servers, it would likely just show up as text.

So what are my options if my host doesn't support PHP? Do you know of code for html that will perform the same task?

no, thats the thing about php. Its a server side language that allows you to create dynamic webpages. With HTML, you can only create static webpages.

Search google, I think Lycos offers free PHP web hosting.