Hi there.

I made something so people can register with they email adress and they get given a unique id.

now i would like it so when you go to mysite.com/index.php?their_id_here the page will be able to find out their email address to display from the id.

Hi,

I presume the person is logging in via a form and then gets re-directed to mysite/index.php?their_id_here.

I take it the username and password are stored in the same database table as the user_id and e-mail. If this is the case, I also presume the login queries the database to find the correct username/password combination and retrieves the user_id if a match is found.

Instead of just pulling the user_id, use the same select query to pull the e-mail address as well.

This should work okay

Regards
Ian

They dont get redirected to mysite/index.php?their_id_here because im not really sure how to do it.

I dont know sql really but so far i have managed to write a form in where you type your email address and when you click submit the page will display something like, "Your unique ID is: 05".

Now i want to make it, so when you go to mysite/index.php?their_id_here the page will know the email adress of the user, working it out from the ID in the url.

you can use the header() function to redirect them. so

<?php
header ("Location: mysite/index.php?id=" . urlencode($id));
exit;
?>

of make sure $id set as the unique ID (you can get it the same way you get the ID when you print it).

to get the username from the URL

PHP Code:

$id = $_GET['id'];

// Connect and select the database
mysql_connect ('localhost', 'username', 'password');
mysql_select_db ('your_db');

// Define the sql query to get the email
$sql = "SELECT email FROM you_users_table WHERE id = '$id'";

// Run the query
$result = mysql_query($sql);

// Assign the emai to a variable
$email = mysql_result($result, 0);    // $email = what ever the email that was returned from the query, assuming it exists

// Close the database connection
mysql_close();

// Print their email
print "Your email address is: <strong>" . $email . "</strong>"; 


Im getting an error with one of the lines you gave me "$email = mysql_result($result, 0); // $email = what ever the email that was returned from the query, assuming it exists "

The error is : Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 5 in /home/splinter/public_html/gamersport/temp/page.php on line 14
Your email address is:

Also, is this correct?

$id = $_GET['mysql_insert_id()'];

header ("Location: page.php?id=" . urlencode($id));
exit;

see what is returned from the query

put this somewhere in the page [you can delete later, it just for testing atm]:

PHP Code:

<?php
$id = $_GET['id'];    // This should be the unique ID

mysql_connect ('localhost', 'username', 'password');
mysql_select_db('your_db');

$sql = "SELECT email FROM your_table WHER id = '$id'";

$result = mysql_query($result);

while ($row = mysql_fetch_array ($result)) {    // This will runt he query and display all the results
    print "ID: " . $row['id'] . " | Email: " . $row['email'] . "<br />";

}

mysql_close();

?>

also make sure email is the right name for the field in the database

"Also, is this correct?

$id = $_GET['mysql_insert_id()'];"

Not sure.