Advice w/ SQL

Kavok

I basicly have an email confirm script that stores a number in the SQL database until the person can enter the number (that was sent to the email).

Im not that great with SQL, so whats the best way to go about getting the number from the SQL database?

Its under table tc_users_temp in the field confirm (I think I got the terms table and field right 😉 or is it row, not field?)

Would I use one of the mysql_fetch things? Syntax? How? Examples?

LarsLai

$sql = "SELECT confirm FROM table tc_users_temp";
$result = mysql_query($sql, $yourconnectiontodatabase);
$row = mysql_fetch_array($result);
$confirm_number = $row[0];

thats only one possibility. you can use mysql_fetch_row() or mysql_result() or... as well.

dcooper

I have done similar things but slightly differently, i have a field in the database called something like active and its default value will be 0,
you then send the confirmation email to the user with a url like
www.website.com/index.php?action=activate&uid=11

the code at this end then can do something like

$userid = $_GET['uid'];

$query = "update table set active='1' where uis='$userid'";

Dunno if thats any help.

LarsLai

@: that`s a better solution. not only much less complicated for you but for the user.

@: think about it...

Kavok

Alright, thanks for the replies should make the work go easier. 🙂

Now another question:

I have two tables: tc_users, tc_users_temp

tc_users_temp = people who have not confirmed the account.
tc_users = people who have

Now I have a few fields (family name, name, game name, password, email)

How would I easily move them from tc_users_temp to tc_users once they have confirmed the account? Do I have to pull all the information from tc_users_temp through arrays and use a query w/ insert, or is there an easier way?

LarsLai

i personally would not use two tables for this.
one table with one more field, if the user has confirmed or not (1 or 0).
or two tables:
first table - personid, name, address ....
second table - personid, confirmationstatus

Kavok

Well I use two tables so I can simply drop all the data on the temp one every 24hrs or so and not have to worry about accidently dropping real users.

dcooper

I would definately just go for one table, if you wanted to keep it cleaned you can add ANOTHER field to the table with a timestamp plus say 24 hours and when it hits that time without being activate it will get deleted.