Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Quick question.  In my database I have 2 tables. 1)initial_users and
2)registered_users.  This is what i want to accomplish.  When someone
signs up with my site the info goes into initial_users which is
working. Once I have verified there information I want to drop there
row of information into registered_users, can I do this with
phpMyAdmin if so I cant figure it out.  And as well is there any other
way that people would suggest how to accomplish this.

Re: phpMyAdmin

I noticed that Message-ID:

Quoted text here. Click to load it

Why two tables?  Why not just have a field that simply records whether
they are verified or not?

Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs /

Re: phpMyAdmin

Rob wrote:
Quoted text here. Click to load it

That was a "INSERT INTO initial_users ..." sql command.

Quoted text here. Click to load it
                      *their*                          *their*
Quoted text here. Click to load it

I know no way to do that in one instruction.
You can do it in two:

    a) INSERT INTO registered_users
       SELECT <col1>, <col2>, ...
       FROM initial_users
       WHERE ...

    b) DELETE FROM inital_users
       WHERE ...

Quoted text here. Click to load it

Don't know phpMyAdmin, but I guess you can type the sql commands
somewhere in its interface and execute them.

Mail to my "From:" address is readable by all at /
== ** ## !! ------------------------------------------------ !! ## ** ==
may bypass my spam filter. If it does, I may reply from another address!

Site Timeline