hey all-
i have this login code, but im not sure what commands i need to put into the phpmyadmin sql box?

If someone could produce some code, i could produce $$.


<?php

// SCRIPT THAT VERIFIES USERNAME AND GETS ID

$username = $_POST['username'] or exit('Couldn\'t assign username');
$password = $_POST['password'] or exit('Couldn\'t assign password');

// Connect to sql database the_database
$link = mysql_pconnect('localhost', 'mysql_username', 'mysql_password') or exit('Could not connect to the server. Please try again later.');
//print 'Connected to SQL<br />';
mysql_select_db('the_database', $link) or exit('Could not speak with server. Please try again later.');
//print 'Connected to database<br />';

//get id
$query = "SELECT id FROM users WHERE username = '$username' and password = '$password'";
$result = mysql_query("$query") or exit('Error looking up id');
if (mysql_num_rows($result) == 0) {
$error = 'You are not in the system. Please re-check your username and password or <a href="register.html">register</a>.';
exit("$error");
}

$row = mysql_fetch_array($result);
$id = $row['id'];

mysql_free_result($result);

//mysql_close($link); //don't use for persistent connections

// inserts mainpage.php verbatim
require 'mainpage.php';

?>

What do u mean under "what commands i need to put into the phpmyadmin sql box". can u explain your problem?

do you mean what fields you should make?

if you mean what kind of fields, you can use this (I assume you're talking about phpMyAdmin):

CREATE TABLE users (
id
int(4)
unsigned
zerofill
DEFAULT '0000'
NOT NULL
auto_increment,
username varchar(50),
password varchar(50),
PRIMARY KEY (id)
);

that will setup a table named users, 3 fields named id, username, and password. the id field will increment one evertime a new user is added. I hope that's what you wanted. If not, just post.

Something like this should do the trick.

create table users(
id int primary key auto_increment,
username varchar(50) not null,
password varchar(50) not null
);

Hope it helps.

Oh, by the way, no need to pay for something as small as
this :) But donations are always welcome/appreciated :D